SchemaSpy Analysis of edi_sandbox.ecocom_dp - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Oct 25 17:00 PDT 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

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