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