SchemaSpy Analysis of edi_sandbox.ecocom_dp - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Aug 16 14:05 PDT 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

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