| SchemaSpy Analysis of lter_core_mb.pkg_mgmt | Generated by SchemaSpy |
| Generated by SchemaSpy on Fri Jan 10 15:05 PST 2020 | |
| Database Type: PostgreSQL - 9.2.24 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| cv_cra | 1 | 2 | 5 | core study area | |
| cv_maint_freq | 1 | 1 | 11 | ||
| cv_mgmt_type | 1 | 2 | 2 | ||
| cv_network_type | 1 | 2 | 5 | ||
| cv_spatial_extent | 1 | 2 | 6 | ||
| cv_spatial_type | 1 | 2 | 4 | ||
| cv_spatio_temporal | 1 | 2 | 4 | ||
| cv_status | 1 | 1 | 10 | ||
| cv_temporal_type | 1 | 2 | 5 | ||
| maintenance_changehistory | 2 | 6 | 2 | ||
| pkg_core_area | 2 | 2 | 3 | core study area | |
| pkg_sort | 7 | 14 | 4 | pkg_state is wordy and pkg_sort is terse. Instead of one really wide table. Just easier to edit. | |
| pkg_state | 2 | 1 | 15 | 4 | aka wordy |
| version_tracker_metabase | 5 | 14 | |||
| vw_backlog | 12 | view | |||
| vw_cataloged | 7 | view | |||
| vw_draft_anticipated | 7 | view | |||
| vw_drafts_bak | 12 | view | |||
| vw_dump | 27 | view | |||
| vw_im_plan | 8 | view | |||
| vw_pub | 13 | view | |||
| vw_self | 12 | view | |||
| vw_temporal | 12 | view | |||
| 14 Tables | 58 | 79 | |||
| 9 Views | 110 |