| SchemaSpy Analysis of lter_core_mb.lter_metabase | Generated by SchemaSpy |
| Generated by SchemaSpy on Fri Jan 10 15:18 PST 2020 | |
| Database Type: PostgreSQL - 9.2.24 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| DataSet | 12 | 1 | 10 | 4 | |
| DataSetAttributeEnumeration | 3 | 5 | 27 | ||
| DataSetAttributeMissingCodes | 4 | 4 | 69 | ||
| DataSetAttributes | 9 | 6 | 17 | 92 | |
| DataSetEntities | 2 | 2 | 14 | 7 | |
| DataSetKeywords | 3 | 3 | 98 | ||
| DataSetMethod | 8 | 1 | 5 | 4 | |
| DataSetMethodInstruments | 4 | 3 | 2 | ||
| DataSetMethodProtocols | 4 | 3 | 4 | ||
| DataSetMethodProvenance | 2 | 3 | 2 | ||
| DataSetMethodSoftware | 4 | 3 | 3 | ||
| DataSetPersonnel | 2 | 4 | 14 | ||
| DataSetSites | 2 | 4 | 18 | ||
| DataSetTaxa | 3 | 3 | 0 | ||
| DataSetTemporal | 1 | 5 | 1 | ||
| EMLFileTypes | 1 | 19 | 19 | ||
| EMLKeywordTypes | 1 | 2 | 5 | ||
| EMLMeasurementScaleDomains | 1 | 1 | 4 | 7 | |
| EMLMeasurementScales | 1 | 1 | 5 | ||
| EMLNumberTypes | 1 | 1 | 4 | ||
| EMLStorageTypes | 1 | 2 | 20 | ||
| EMLUnitDictionary | 2 | 1 | 9 | 286 | |
| EMLUnitTypes | 1 | 4 | 67 | ||
| ListKeywords | 2 | 2 | 3 | 659 | |
| ListKeywordThesauri | 1 | 5 | 11 | ||
| ListMethodInstruments | 1 | 2 | 2 | ||
| ListMethodProtocols | 1 | 1 | 4 | 102 | |
| ListMethodSoftware | 1 | 6 | 3 | ||
| ListMissingCodes | 1 | 3 | 4 | ||
| ListPeople | 7 | 17 | 9 | ||
| ListPeopleID | 1 | 4 | 6 | ||
| ListSites | 1 | 1 | 16 | 500 | |
| ListTaxa | 2 | 1 | 6 | 0 | |
| ListTaxonomicProviders | 1 | 3 | 12 | ||
| 34 Tables | 197 | 2,066 | |||
| 0 Views | 0 |