The prototype contains all tables, all primary and foreign keys, but no data. All tables are truncated and converted to zero-row tibbles, also for remote data models. Column names retain their type. This is useful for performing creation and population of a database in separate steps.
Examples
dm_financial() %>%
dm_ptype()
#> ── Metadata ────────────────────────────────────────────────────────────────────
#> Tables: `accounts`, `cards`, `clients`, `disps`, `districts`, … (9 total)
#> Columns: 57
#> Primary keys: 8
#> Foreign keys: 7
dm_financial() %>%
dm_ptype() %>%
dm_nrow()
#> accounts cards clients disps districts loans orders tkeys
#> 0 0 0 0 0 0 0 0
#> trans
#> 0