| SchemaSpy Analysis of edi_sandbox.ecocom_dp | Generated by SchemaSpy |
| Generated by SchemaSpy on Wed Oct 25 17:00 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 | 2 | 2 | 0 | ||
| location | 3 | 1 | 6 | 0 | self-referencing; parent of a loc can be another loc |
| location_ancillary | 1 | 6 | 0 | ||
| observation | 4 | 9 | 0 | table holds all the primary obs, with links to taxa, locations, event, summary | |
| observation_ancillary | 1 | 5 | 0 | holds other info about a sampling event, eg, conditions, weather, observers, etc | |
| taxon | 2 | 5 | 0 | ||
| taxon_ancillary | 1 | 6 | 0 | ||
| 8 Tables | 46 | 0 | |||
| 0 Views | 0 |