| SchemaSpy Analysis of edi_sandbox.ecocom_dp | Generated by SchemaSpy |
| Generated by SchemaSpy on Wed Aug 16 14:05 PDT 2017 | |
| Database Type: PostgreSQL - 9.2.19 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| dataset_summary | 1 | 7 | 0 | ||
| event | 1 | 5 | 0 | holds info about a sampling event, eg, conditions, weather, observers, etc | |
| observation | 4 | 9 | 0 | table holds all the primary obs, with links to taxa, locations, event, summary | |
| sampling_location | 3 | 1 | 6 | 0 | self-referencing; parent of a loc can be another loc |
| sampling_location_ancillary | 1 | 6 | 0 | ||
| taxon | 2 | 5 | 0 | ||
| taxon_ancillary | 1 | 6 | 0 | ||
| 7 Tables | 44 | 0 | |||
| 0 Views | 0 |