Dataverse for Teams is limited to 2GB per environment, which is a Team.
You can have multiple apps in a Team, sharing the same 2GB storage pool. The storage amount applies to all types of data within your App(s), e.g. database data, files and log files.
Dataverse storage for Canvas & Model-driven Power Apps and Dynamics 365 is pooled at the tenant level. Different licenses provide different Database,
File and Log capacity. There are default capacities (depending on the license), plus additional per user & per App additions.
Power Automate licenses also provide storage capacity.
Unless you intend to store files within a Dataverse for Teams app, you'll be able to squeeze several hundred thousands of records within your app, more if you don't have many columns on each table.