| 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 |