| SchemaSpy Analysis of edi_sandbox.ecocom_dp - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on Wed Oct 25 17:00 PDT 2017 |
| ||||||
|
| |||||||
edi_sandbox.ecocom_dp contains 46 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | Comments |
|---|---|---|---|---|---|---|---|
| dataset_summary | length_of_survey_years | int4 | 10 | √ | null | ||
| dataset_summary | max_num_taxa | int4 | 10 | √ | null | ||
| dataset_summary | number_of_years_sampled | int4 | 10 | √ | null | ||
| location | elevation | float8 | 17,17 | √ | null | ||
| dataset_summary | geo_extent_bounding_box_m2 | float8 | 17,17 | √ | null | ||
| location | latitude | float8 | 17,17 | √ | null | ||
| location | longitude | float8 | 17,17 | √ | null | ||
| dataset_summary | std_dev_interval_betw_years | float8 | 17,17 | √ | null | ||
| location_ancillary | datetime | timestamp | 29,6 | ||||
| taxon_ancillary | datetime | timestamp | 29,6 | ||||
| observation | observation_datetime | timestamp | 29,6 | √ | null | ||
| event | event_id | varchar | 100 | ||||
| observation | event_id | varchar | 100 | √ | null | ||
| observation_ancillary | event_id | varchar | 100 | √ | null | ||
| event | event_name | varchar | 100 | √ | null | ||
| location_ancillary | location_ancillary_id | varchar | 100 | ||||
| location | location_id | varchar | 100 | ||||
| location_ancillary | location_id | varchar | 100 | ||||
| observation | location_id | varchar | 100 | ||||
| observation_ancillary | observation_ancillary_id | varchar | 100 | ||||
| observation | observation_id | varchar | 100 | ||||
| dataset_summary | package_id | varchar | 100 | ||||
| observation | package_id | varchar | 100 | ||||
| location | parent_location_id | varchar | 100 | √ | null | ||
| taxon_ancillary | taxon_ancillary_id | varchar | 100 | ||||
| observation | taxon_id | varchar | 100 | ||||
| taxon | taxon_id | varchar | 100 | ||||
| taxon_ancillary | taxon_id | varchar | 100 | ||||
| taxon_ancillary | author | varchar | 200 | √ | null | ||
| taxon | authority_system | varchar | 200 | √ | null | ||
| taxon | authority_taxon_id | varchar | 200 | √ | null | ||
| dataset_summary | original_package_id | varchar | 200 | √ | null | ||
| taxon | taxon_name | varchar | 200 | ||||
| taxon | taxon_rank | varchar | 200 | √ | null | ||
| location_ancillary | unit | varchar | 200 | √ | null | ||
| observation | unit | varchar | 200 | ||||
| observation_ancillary | unit | varchar | 200 | √ | null | ||
| location_ancillary | value | varchar | 200 | ||||
| observation | value | varchar | 200 | ||||
| observation_ancillary | value | varchar | 200 | √ | null | ||
| taxon_ancillary | value | varchar | 200 | ||||
| location_ancillary | variable_name | varchar | 200 | ||||
| observation | variable_name | varchar | 200 | ||||
| observation_ancillary | variable_name | varchar | 200 | √ | null | ||
| taxon_ancillary | variable_name | varchar | 200 | ||||
| location | location_name | varchar | 500 | √ | null |