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 | geo_extent_bounding_box_m2 | float8 | 17,17 | √ | null | ||
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 | ||
dataset_summary | original_package_id | varchar | 200 | √ | null | ||
dataset_summary | package_id | varchar | 100 | ||||
dataset_summary | std_dev_interval_betw_years | float8 | 17,17 | √ | null | ||
event | event_id | varchar | 100 | ||||
event | event_name | varchar | 100 | √ | null | ||
location | elevation | float8 | 17,17 | √ | null | ||
location | latitude | float8 | 17,17 | √ | null | ||
location | location_id | varchar | 100 | ||||
location | location_name | varchar | 500 | √ | null | ||
location | longitude | float8 | 17,17 | √ | null | ||
location | parent_location_id | varchar | 100 | √ | null | ||
location_ancillary | datetime | timestamp | 29,6 | ||||
location_ancillary | location_ancillary_id | varchar | 100 | ||||
location_ancillary | location_id | varchar | 100 | ||||
location_ancillary | unit | varchar | 200 | √ | null | ||
location_ancillary | value | varchar | 200 | ||||
location_ancillary | variable_name | varchar | 200 | ||||
observation | event_id | varchar | 100 | √ | null | ||
observation | location_id | varchar | 100 | ||||
observation | observation_datetime | timestamp | 29,6 | √ | null | ||
observation | observation_id | varchar | 100 | ||||
observation | package_id | varchar | 100 | ||||
observation | taxon_id | varchar | 100 | ||||
observation | unit | varchar | 200 | ||||
observation | value | varchar | 200 | ||||
observation | variable_name | varchar | 200 | ||||
observation_ancillary | event_id | varchar | 100 | √ | null | ||
observation_ancillary | observation_ancillary_id | varchar | 100 | ||||
observation_ancillary | unit | varchar | 200 | √ | null | ||
observation_ancillary | value | varchar | 200 | √ | null | ||
observation_ancillary | variable_name | varchar | 200 | √ | null | ||
taxon | authority_system | varchar | 200 | √ | null | ||
taxon | authority_taxon_id | varchar | 200 | √ | null | ||
taxon | taxon_id | varchar | 100 | ||||
taxon | taxon_name | varchar | 200 | ||||
taxon | taxon_rank | varchar | 200 | √ | null | ||
taxon_ancillary | author | varchar | 200 | √ | null | ||
taxon_ancillary | datetime | timestamp | 29,6 | ||||
taxon_ancillary | taxon_ancillary_id | varchar | 100 | ||||
taxon_ancillary | taxon_id | varchar | 100 | ||||
taxon_ancillary | value | varchar | 200 | ||||
taxon_ancillary | variable_name | varchar | 200 |