Constraints

73 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
batch_data_source_batch_fk
data_source_batch.batch_id
batch.batch_id
Restrict delete
data_source_data_source_batch_fk
data_source_batch.data_source_id
data_source.data_source_id
Restrict delete
batch_sample_analyte_determination_fk
analyte_determination.sample_id
analyte_determination.batch_id
batch_sample.sample_id
batch_sample.batch_id
Restrict delete
reference_work_analyte_determination_fk
analyte_determination.reference_id
reference_work.reference_id
Restrict delete
analyte_determination_limit_analyte_determination_fk
analyte_determination.limit_id
analyte_determination_limits.limit_id
Restrict delete
batch_batch_sample_fk
batch_sample.batch_id
batch.batch_id
Restrict delete
sample_batch_sample_fk
batch_sample.sample_id
sample.sample_id
Restrict delete
person_geol_context_provided_by_fk
geol_context_provided_by.person_id
person.person_id
Restrict delete
geol_context_geol_context_provided_by_fk
geol_context_provided_by.geol_context_id
geol_context.geol_context_id
Restrict delete
dic_continent_dic_country_fk
dic_country.continent_code
dic_continent.iso_code
Restrict delete
biostrat_dic_biostrat_fk
biostrat.dic_biostrat_id
dic_biostrat.dic_biostrat_id
Restrict delete
institution_storage_fk
storage.institution_id
institution.institution_id
Restrict delete
person_contact_person
storage.contact_person
person.person_id
Restrict delete
dic_proxy_proxy_published_fk
proxy_published.proxy_id
dic_proxy.proxy_id
Restrict delete
reference_work_proxy_published_fk
proxy_published.reference_id
reference_work.reference_id
Restrict delete
sample_proxy_published_fk
proxy_published.sample_id
sample.sample_id
Restrict delete
sample_alternate_num_fk
alternate_num.sample_id
sample.sample_id
Restrict delete
reference_work_alternate_num_fk
alternate_num.reference_id
reference_work.reference_id
Restrict delete
dic_project_type_project_fk
project.project_type
dic_project_type.project_type
Restrict delete
project_project_samples_fk
project_sample.project_id
project.project_id
Restrict delete
sample_project_samples_fk
project_sample.sample_id
sample.sample_id
Cascade on delete
dic_journal_reference_work_fk
reference_work.journal_id
dic_publication.publication_id
Restrict delete
person_collector_fk
collector.person_id
person.person_id
Restrict delete
collecting_event_collector_fk
collector.coll_event_id
collecting_event.coll_event_id
Restrict delete
analysis_analyte_determination_limits_fk
analyte_determination_limits.analysis_id
analysis.analysis_id
Restrict delete
dic_analyte_analyte_determination_limits_fk
analyte_determination_limits.analyte_code
dic_analyte.analyte_code
Restrict delete
sample_fossil_sample_fk
fossil_sample.sample_id
sample.sample_id
Restrict delete
fossil_fossil_sample_fk
fossil_sample.fossil_id
fossil.fossil_id
Restrict delete
dic_exp_method_analysis_fk
analysis.exp_method_id
dic_exp_method.exp_method_id
Restrict delete
dic_analysis_method_analysis_fk
analysis.ana_method_id
dic_ana_method.ana_method_id
Restrict delete
person_analysis_fk
analysis.run_by
person.person_id
Restrict delete
dic_prep_method_analysis_fk
analysis.prep_id
dic_prep_method.prep_id
Restrict delete
batch_analysis_fk
analysis.batch_id
batch.batch_id
Restrict delete
person_analysis_fk_1
analysis.provided_by
person.person_id
Restrict delete
person_author_fk
author.person_id
person.person_id
Restrict delete
reference_work_author_fk
author.reference_id
reference_work.reference_id
Restrict delete
sample_sample_provided_by_fk
sample_provided_by.sample_id
sample.sample_id
Restrict delete
person_sample_provided_by_fk
sample_provided_by.person_id
person.person_id
Restrict delete
person_interpreted_age_provided_by_fk
interpreted_age_provided_by.person_id
person.person_id
Restrict delete
interpreted_age_interpreted_age_provided_by_fk
interpreted_age_provided_by.interpreted_age_id
interpreted_age.interpreted_age_id
Restrict delete
sample_sed_structure_sample_fk
sed_structure_sample.sample_id
sample.sample_id
Restrict delete
sed_structure_sed_structure_sample_fk
sed_structure_sample.sed_structure_id
dic_sed_structure.sed_structure_id
Restrict delete
basin_dic_basin_type_fk
basin.basin_type_id
dic_basin_type.basin_type_id
Restrict delete
reference_work_dic_analysis_method_fk
dic_ana_method.reference_id
reference_work.reference_id
Restrict delete
institution_batch_fk
batch.lab_id
institution.institution_id
Restrict delete
geological_region_site_fk
site.craton_terrane_id
craton_terrane.craton_terrane_id
Restrict delete
dic_country_site
site.country
dic_country.country
Restrict delete
dic_meta_site_fk
site.metamorphic_bin
dic_meta.meta_id
Restrict delete
basin_site_fk
site.basin_id
basin.basin_id
Restrict delete
reference_work_dic_proxy_fk
dic_proxy.reference_id
reference_work.reference_id
Restrict delete
sample_interpreted_age_fk
interpreted_age.sample_id
sample.sample_id
Restrict delete
reference_work_interpreted_age_fk
interpreted_age.reference_id
reference_work.reference_id
Restrict delete
dic_institution_type_institution_fk
institution.institution_type
dic_institution_type.institution_type
Restrict delete
institution_affiliation_fk
affiliation.institution_id
institution.institution_id
Restrict delete
person_affiliation_fk
affiliation.person_id
person.person_id
Restrict delete
ics_age_geol_age_fk
geol_age.ics_id
dic_ics_age.ics_id
Restrict delete
collecting_event_sample_fk
sample.coll_event_id
collecting_event.coll_event_id
Restrict delete
dic_lith_composition_sample_fk
sample.lith_composition_id
dic_lith_composition.lith_composition_id
Restrict delete
dic_lithology_sample_fk
sample.lith_id
dic_lithology.lith_id
Restrict delete
geol_context_sample_fk
sample.geol_context_id
geol_context.geol_context_id
Restrict delete
storage_sample_fk
sample.storage_id
storage.storage_id
Restrict delete
color_sample_fk
sample.color_id
dic_color.color_id
Restrict delete
dic_lith_texture_sample_fk
sample.lith_texture_id
dic_lith_texture.lith_texture_id
Restrict delete
dic_weathering_sample_fk
sample.weath_grade
dic_weathering.weath_grade
Restrict delete
site_collecting_event_fk
collecting_event.site_id
site.site_id
Restrict delete
lithostrat_strat_fk
lithostrat.strat_id
dic_lithostrat.strat_id
Restrict delete
reference_work_project_citation_fk
project_citation.reference_id
reference_work.reference_id
Restrict delete
project_project_citation_fk
project_citation.project_id
project.project_id
Restrict delete
biostrat_geol_context_fk
geol_context.biostrat_id
biostrat.biostrat_id
Restrict delete
geol_age_geol_context_fk
geol_context.age_id
geol_age.age_id
Restrict delete
strat_geol_context_fk
geol_context.lithostrat_id
lithostrat.lithostrat_id
Restrict delete
environment_geol_context_fk
geol_context.env_id
environment.env_id
Restrict delete
reference_work_dic_exp_method_fk
dic_exp_method.reference_id
reference_work.reference_id
Restrict delete

Check Constraints

Table Constraint Name Constraint
analyte_determination abundance_negative (((abundance >= (0)::numeric) OR ((determination_unit)::text = 'permil'::text)))
analyte_determination abundance_null (((abundance IS NOT NULL) OR (is_above_detection IS NOT NULL) OR (is_below_detection IS NOT NULL)))
environment envchk (((env_bin)::text = ANY (ARRAY['inner shelf'::text, 'outer shelf'::text, 'basinal'::text, 'lacustrine'::text, 'fluvial'::text])))
site metachk ((metamorphic_bin = ANY (ARRAY[1, 2, 3])))