ecdb_stg Database

TABLES 84

COLUMNS 873

Constraints 99

Anomalies 33

Routines 0

Database Properties

Database Type: PostgreSQL - 10.4

Schema earthchem

ECDB SCHEMA

Tables

Table / View	Children	Parents	Columns	Rows	Type	Comments
citation_curation_entity	0	2	3	4113	Table
related_result	0	3	6	0	Table
d_person	0	1	6	4934	Table
text_data	0	1	3	0	Table
d_ec_status_info	0	1	6	150	Table
dataset	8	1	7	10361	Table
sampling_feature	10	1	10	825305	Table
specimen	0	4	3	785120	Table
d_citation	0	0	17	148	Table
citation_external_identifier	0	2	5	3952	Table	doi etc.
person_external_identifier	0	2	5	0	Table
method_type	1	0	4	8	Table
feature_of_interest_annotation	0	2	3	0	Table
result_type	1	0	3	8	Table
feature_of_interest	1	3	4	84401	Table
country	3	0	6	241	Table
dataset_external_identifier	0	2	5	0	Table
annotation	4	2	7	286600	Table
external_identifier_system	8	1	5	12	Table
d_author_list	0	2	4	726	Table
datasource	0	0	3	665	Table
status_type	0	0	6	0	Table	Status_type table proposed by Steve Richard to handle deprecating/activating/proposing new entries in the database. Schema copied from EarthChem database
annotation_type	2	0	2	82	Table
action_external_identifier	0	2	5	0	Table
d_organization	0	3	17	1277	Table
entity_statistics	0	0	12	129	Table
person	7	0	6	5359	Table
unit	5	0	4	71	Table
orcid	0	1	6	422	Table
variable_type	1	0	3	15	Table
d_affiliation	0	3	12	305	Table
spatial_offset_type	1	0	3	0	Table
sampling_feature_type	6	2	5	48	Table
taxonomic_classifier_external_identifer	0	2	5	0	Table
annotation_type_group	0	3	3	15	Table
feature_of_interest_type	1	0	3	59	Table
spatial_offset	1	4	8	0	Table	depth_interval
d_citation_external_identifier	0	1	5	135	Table
citation_dataset	0	3	4	11053	Table	mimic datasource table
sampling_feature_external_identifier	0	4	5	4035	Table
tmp_latlong	0	0	3	68	Table
numeric_data	0	2	7	7253106	Table
related_feature	0	4	5	792610	Table
relationship_type	4	0	3	23	Table
method	1	2	8	140	Table
users	0	0	2	1	Table
sampling_feature_taxonomic_classifier	0	2	4	526722	Table	will contain information from classification table and more
citation	10	0	16	4214	Table
dataset_type	1	0	3	1	Table
seddb_affiliation	0	1	3	1352	Table
author_list	1	2	4	15707	Table
sampling_feature_annotation	0	2	3	1628049	Table
tmp_3904_igsn	0	0	2	514	Table
state	1	1	8	62	Table
ec_status_info	1	2	6	4213	Table
reference_material_value	1	3	6	0	Table
feature_of_interest_cv	1	0	4	2023	Table
organization	7	4	17	1453	Table
equipment	1	1	14	157	Table
variable	6	1	8	620	Table
curation_entity	2	0	4	2	Table
result_annotation	0	2	3	0	Table
related_action	0	3	4	0	Table
material	2	0	4	11	Table
action_type	1	0	5	30	Table	ObservationAct,ExpeditionAct,SpecimenPreparationAct,SpecimenCollectionAct
equipment_action	0	2	3	1984	Table
annotation_group	1	0	3	2	Table
equipment_type	1	0	4	5	Table
tmp_fe_mo	0	0	17	586	Table
organization_type	2	0	4	24	Table
bibcode	0	1	3	2881	Table
affiliation	2	2	12	5208	Table
action_by	0	2	5	0	Table
action_annotation	0	2	3	9916	Table
lab	0	0	2	771	Table
gma_term_map	0	0	2	0	Table
d1	0	0	1	11988	Table
processing_level	4	0	4	6	Table
user_roles	0	0	2	1	Table
feature_action	1	2	3	901373	Table
action	11	4	13	23261	Table
taxonomic_classifier	4	1	7	493	Table
additional_method_info	0	2	4	37197	Table
result	5	6	15	5928052	Table
v_analyzed_samples	0	1	5	0	View
v_stations	0	1	10	0	View
mv_dataset_summary	0	1	13	0	View
v_expedition_summary	0	0	11	0	View
v_dataset_result	0	4	37	0	View
mv_expedition_summary	0	0	11	0	View
v_specimen_summary	0	0	31	0	View
v_station_summary_with_geom	0	0	15	0	View
v_citation_summary	0	0	22	0	View
v_specimens	0	1	5	0	View
mv_station_summary	0	0	14	0	View
mv_dataset_result_summary	0	4	53	0	View
v_station_summary	0	0	14	0	View
mv_rangeofvariable_summary	0	0	5	0	View
mv_specimen_summary	0	0	31	0	View
v_dataset_result_summary	0	4	53	0	View
v_specimen_summary_with_geom	0	0	26	0	View
v_dataset_summary	0	1	13	0	View
mv_citation_summary	0	0	22	0	View