SchemaSpy Analysis of edi_sandbox.ecocom_dp - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Aug 16 14:05 PDT 2017 |
| ||||||
|
edi_sandbox.ecocom_dp contains 44 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_record_id | varchar | 100 | ||||
event | unit | varchar | 200 | √ | null | ||
event | value | varchar | 200 | √ | null | ||
event | variable_name | varchar | 200 | √ | null | ||
observation | event_record_id | varchar | 100 | ||||
observation | observation_datetime | timestamp | 29,6 | √ | null | ||
observation | observation_id | varchar | 100 | ||||
observation | package_id | varchar | 100 | ||||
observation | sampling_location_id | varchar | 100 | ||||
observation | taxon_id | varchar | 100 | ||||
observation | unit | varchar | 200 | ||||
observation | value | varchar | 200 | ||||
observation | variable_name | varchar | 200 | ||||
sampling_location | elevation | float8 | 17,17 | √ | null | ||
sampling_location | latitude | float8 | 17,17 | √ | null | ||
sampling_location | longitude | float8 | 17,17 | √ | null | ||
sampling_location | parent_sampling_location_id | varchar | 100 | √ | null | ||
sampling_location | sampling_location_id | varchar | 100 | ||||
sampling_location | sampling_location_name | varchar | 500 | √ | null | ||
sampling_location_ancillary | datetime | timestamp | 29,6 | ||||
sampling_location_ancillary | sampling_location_ancillary_id | varchar | 100 | ||||
sampling_location_ancillary | sampling_location_id | varchar | 100 | ||||
sampling_location_ancillary | unit | varchar | 200 | √ | null | ||
sampling_location_ancillary | value | varchar | 200 | ||||
sampling_location_ancillary | variable_name | varchar | 200 | ||||
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 |