229 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_aggregatesamples_samples |
|
|
Cascade on delete | ||
| fk_aggregatesamples_aggregatedatasets |
|
|
Cascade on delete | ||
| fk_aggregatesampleages_aggregatechronologies |
|
|
Restrict delete | ||
| fk_aggregatesampleages_sampleages |
|
|
Cascade on delete | ||
| fk_aggregatesampleages_aggregatedatasets |
|
|
Cascade on delete | ||
| fk_chroncontrols_agetypes |
|
|
Restrict delete | ||
| fk_chroncontrols_chronologies |
|
|
Cascade on delete | ||
| fk_chroncontrols_chroncontroltypes |
|
|
Cascade on delete | ||
| fk_chroncontrols_analysisunits |
|
|
Restrict delete | ||
| fk_accumulationrates_variableunits |
|
|
Cascade on delete | ||
| fk_accumulationrates_analysisunits |
|
|
Cascade on delete | ||
| fk_accumulationrates_chronologies |
|
|
Restrict delete | ||
| pub_pty |
|
|
Restrict delete | ||
| fk_eventpublications_publications |
|
|
Cascade on delete | ||
| fk_eventpublications_events |
|
|
Cascade on delete | ||
| fk_samples_taxa |
|
|
Restrict delete | ||
| fk_samples_analysisunits |
|
|
Restrict delete | ||
| fk_samples_datasets |
|
|
Restrict delete | ||
| fk_isostratdata_data |
|
|
Cascade on delete | ||
| fk_isostratdata_elementtypes |
|
|
Cascade on delete | ||
| fk_isostratdata_taxa |
|
|
Restrict delete | ||
| fk_lithology_collectionunits |
|
|
Cascade on delete | ||
| fk_isosamplepretreatments_data |
|
|
Cascade on delete | ||
| fk_isosamplepretreatments_isopretratmenttypes |
|
|
Cascade on delete | ||
| fk_geochronpublications_geochronology |
|
|
Cascade on delete | ||
| fk_geochronpublications_publications |
|
|
Cascade on delete | ||
| fk_formtaxa_taxa1 |
|
|
Cascade on delete | ||
| fk_formtaxa_publications |
|
|
Cascade on delete | ||
| fk_formtaxa_taxa |
|
|
Restrict delete | ||
| fk_chroncontrolranks_chroncontrols |
|
|
Cascade on delete | ||
| fk_chroncontrolranks_chroncontrolaccuracydistributions |
|
|
Cascade on delete | ||
| fk_chroncontrolranks_chroncontrolaccuracyranks |
|
|
Cascade on delete | ||
| fk_chroncontrolranks_chroncontrolaccuracydirections |
|
|
Cascade on delete | ||
| fk_chroncontrolranks_chroncontrolprecisionranks |
|
|
Cascade on delete | ||
| fk_summarydatataphonomy_taphonomictypes |
|
|
Cascade on delete | ||
| fk_summarydatataphonomy_data |
|
|
Cascade on delete | ||
| fk_chronologies_agetypes |
|
|
Cascade on delete | ||
| fk_chronologies_collectionunits |
|
|
Cascade on delete | ||
| fk_chronologies_contacts |
|
|
Restrict delete | ||
| fk_highertaxonid |
|
|
Restrict delete | ||
| fk_taxagroupid |
|
|
Restrict delete | ||
| fk_validatorid |
|
|
Restrict delete | ||
| fk_publicationid |
|
|
Restrict delete | ||
| fk_sampleanalysts_contacts |
|
|
Restrict delete | ||
| fk_sampleanalysts_samples |
|
|
Cascade on delete | ||
| sd_smpid |
|
|
Restrict delete | ||
| fk_specimendates_specimens |
|
|
Cascade on delete | ||
| sd_fcid |
|
|
Restrict delete | ||
| sd_txid |
|
|
Restrict delete | ||
| sd_etyid |
|
|
Restrict delete | ||
| sd_gcid |
|
|
Restrict delete | ||
| fk_analysisunitaltdepths_analysisunits |
|
|
Cascade on delete | ||
| fk_analysisunitaltdepths_analysisunitaltdepthscales |
|
|
Cascade on delete | ||
| fk_unitsdatasettypes_variableunits |
|
|
Cascade on delete | ||
| fk_unitsdatasettypes_datasettypes |
|
|
Cascade on delete | ||
| fk_isovariablescaletypes_isoscaletypes |
|
|
Cascade on delete | ||
| fk_isovariablescaletypes_variables |
|
|
Cascade on delete | ||
| fk_isomatanalsubstrate_isomaterialanalyzedtypes |
|
|
Cascade on delete | ||
| fk_isomatanalsubstrate_isosubstratetypes |
|
|
Cascade on delete | ||
| fk_siteimages_contacts |
|
|
Restrict delete | ||
| fk_siteimages_sites |
|
|
Cascade on delete | ||
| fk_elementtaxagroupmaturities_elementtaxagroup |
|
|
Cascade on delete | ||
| fk_elementtaxagroupmaturities_elementmaturities |
|
|
Cascade on delete | ||
| fk_repositoryspecimens_datasets |
|
|
Cascade on delete | ||
| fk_repositoryspecimens_repositoryinstitutions |
|
|
Restrict delete | ||
| fk_specimens_repositoryinstitutions |
|
|
Cascade on delete | ||
| fk_specimens_data |
|
|
Cascade on delete | ||
| fk_specimens_elementportions |
|
|
Restrict delete | ||
| fk_specimens_elementsymmetries |
|
|
Restrict delete | ||
| fk_specimens_elementmaturities |
|
|
Restrict delete | ||
| fk_specimens_elementtypes |
|
|
Cascade on delete | ||
| fk_specimens_specimendomesticstatus |
|
|
Cascade on delete | ||
| fk_specimens_specimensex |
|
|
Cascade on delete | ||
| fk_taphonomictypes_taphonomicsystems |
|
|
Cascade on delete | ||
| fk_datataxonnotes_data |
|
|
Cascade on delete | ||
| fk_datataxonnotes_contacts |
|
|
Restrict delete | ||
| fk_relativeagepublications_publications |
|
|
Cascade on delete | ||
| fk_relativeagepublications_relativeages |
|
|
Cascade on delete | ||
| fk_externalpublications_externaldatabases |
|
|
Cascade on delete | ||
| fk_externalpublications_publications |
|
|
Cascade on delete | ||
| fk_isometadata_isomaterialanalyzedtypes |
|
|
Null on delete | ||
| fk_isometadata_contacts |
|
|
Restrict delete | ||
| fk_isometadata_isosubstratetypes |
|
|
Null on delete | ||
| fk_isometadata_data |
|
|
Cascade on delete | ||
| fk_geochrons_geochronid |
|
|
Restrict delete | ||
| fk_radiocarbonmethodid |
|
|
Restrict delete | ||
| fk_collectionunits_collectiontypes |
|
|
Cascade on delete | ||
| fk_collectionunits_rocktypes |
|
|
Cascade on delete | ||
| fk_collectionunits_sites |
|
|
Cascade on delete | ||
| fk_collectionunits_depenvttypes |
|
|
Cascade on delete | ||
| fk_samplekeywords_samples |
|
|
Cascade on delete | ||
| fk_samplekeywords_keywords |
|
|
Restrict delete | ||
| fk_depagents_depagenttypes |
|
|
Cascade on delete | ||
| fk_depagents_analysisunits |
|
|
Cascade on delete | ||
| fk_specimentaphonomy_specimens |
|
|
Cascade on delete | ||
| fk_specimentaphonomy_taphonomictypes |
|
|
Cascade on delete | ||
| fk_lithostratunits_lithostrattypes |
|
|
Cascade on delete | ||
| fk_higherlithostratid |
|
|
Restrict delete | ||
| fk_higherrocktypeid |
|
|
Restrict delete | ||
| fk_synonymy_contacts |
|
|
Restrict delete | ||
| fk_synonymy_publications |
|
|
Cascade on delete | ||
| fk_synonymy_taxa2 |
|
|
Restrict delete | ||
| fk_synonymy_taxa1 |
|
|
Cascade on delete | ||
| fk_synonymy_datasets |
|
|
Cascade on delete | ||
| fk_variables_variableunits |
|
|
Cascade on delete | ||
| fk_variables_variablecontexts |
|
|
Cascade on delete | ||
| fk_variables_taxa |
|
|
Cascade on delete | ||
| fk_variables_variableelements |
|
|
Cascade on delete | ||
| fk_synonyms_synonymtypes |
|
|
Cascade on delete | ||
| fk_synonyms_invalidtaxa |
|
|
Cascade on delete | ||
| fk_synonyms_validtaxa |
|
|
Restrict delete | ||
| fk_contacts_contactstatuses |
|
|
Null on delete | ||
| fk_sitegeopolitical_geopoliticalunits |
|
|
Restrict delete | ||
| fk_sitegeopolitical_sites |
|
|
Cascade on delete | ||
| fk_events_eventtypes |
|
|
Cascade on delete | ||
| fk_elementtaxagroupsymmetries_elementtaxagroups |
|
|
Cascade on delete | ||
| fk_elementtaxagroupsymmetries_elementsymmetries |
|
|
Cascade on delete | ||
| fk_datasetdatabases_constituentdatabases |
|
|
Cascade on delete | ||
| fk_datasetdatabases_datasets |
|
|
Cascade on delete | ||
| fk_isobiomarkerbands_isobiomarkertypes |
|
|
Cascade on delete | ||
| fk_sampleages_samples |
|
|
Cascade on delete | ||
| fk_sampleages_chronologies |
|
|
Cascade on delete | ||
| fk_isostandards_datasets |
|
|
Cascade on delete | ||
| fk_isostandards_variables |
|
|
Cascade on delete | ||
| fk_isostandards_isostandardtypes |
|
|
Cascade on delete | ||
| fk_datasettaxagrouptypes_datasettypes |
|
|
Cascade on delete | ||
| fk_datasettaxagrouptypes_taxagrouptypes |
|
|
Cascade on delete | ||
| fk_publicationtranslators_publications |
|
|
Cascade on delete | ||
| fk_taphonomicsystemsdatasettypes_taphonomicsystemsdatasettypes |
|
|
Cascade on delete | ||
| fk_taphonomicsystemsdatasettypes_taphonomicsystems |
|
|
Cascade on delete | ||
| evc_alu |
|
|
Restrict delete | ||
| evc_evt |
|
|
Restrict delete | ||
| evc_ccid |
|
|
Restrict delete | ||
| fk_aggregatechronologies_agetypes |
|
|
Cascade on delete | ||
| fk_aggregatechronologies_aggregatedatasets |
|
|
Cascade on delete | ||
| fk_relativechronology_relativeages |
|
|
Cascade on delete | ||
| rc_ccid |
|
|
Restrict delete | ||
| fk_relativechronology_analysisunits |
|
|
Cascade on delete | ||
| fk_aggregatedatasets_aggregateordertypes |
|
|
Cascade on delete | ||
| fk_collectors_contacts |
|
|
Restrict delete | ||
| fk_collectors_collectionunits |
|
|
Cascade on delete | ||
| fk_taxaalthierarchy_taxa |
|
|
Cascade on delete | ||
| fk_taxaalthierarchy_taxa1 |
|
|
Restrict delete | ||
| fk_taxaalthierarchy_taxaalthierarchytypes |
|
|
Cascade on delete | ||
| fk_publicationeditors_publications |
|
|
Cascade on delete | ||
| fk_isosrmetadata_datasets |
|
|
Cascade on delete | ||
| fk_isosrmetadata_variables |
|
|
Cascade on delete | ||
| fk_specimendatescal_specimendates |
|
|
Cascade on delete | ||
| fk_specimendatescal_calibrationcurves |
|
|
Cascade on delete | ||
| fk_specimendatescal_calibrationprograms |
|
|
Cascade on delete | ||
| fk_calibrationcurves_publications |
|
|
Cascade on delete | ||
| fk_contextsdatasettypes_variablecontexts |
|
|
Cascade on delete | ||
| fk_contextsdatasettypes_datasettypes |
|
|
Cascade on delete | ||
| fk_datasets_collectionunits |
|
|
Cascade on delete | ||
| fk_datasets_datasettypes |
|
|
Cascade on delete | ||
| fk_datasets_embargo |
|
|
Cascade on delete | ||
| leadmodels_pbbasisid_fkey |
|
|
Restrict delete | ||
| leadmodels_analysisunitid_fkey |
|
|
Restrict delete | ||
| fk_lakeparameters_sites |
|
|
Cascade on delete | ||
| fk_lakeparameters_lakeparametertypes |
|
|
Cascade on delete | ||
| fk_data_samples |
|
|
Cascade on delete | ||
| fk_data_variables |
|
|
Cascade on delete | ||
| fk_geochroncontrols_chroncontrols |
|
|
Restrict delete | ||
| fk_geochroncontrols_geochronology |
|
|
Restrict delete | ||
| datauncertainties_dataid_fkey |
|
|
Restrict delete | ||
| datauncertainties_uncertaintyunitid_fkey |
|
|
Restrict delete | ||
| datauncertainties_uncertaintybasisid_fkey |
|
|
Restrict delete | ||
| fk_publicationauthors_contacts |
|
|
Restrict delete | ||
| fk_publicationauthors_publications |
|
|
Cascade on delete | ||
| fk_specimengenbank_specimens |
|
|
Cascade on delete | ||
| fk_higherchroncontroltypeid |
|
|
Restrict delete | ||
| fk_analysisunitaltdepths_variableunits |
|
|
Cascade on delete | ||
| fk_datasetpublications_datasets |
|
|
Cascade on delete | ||
| fk_datasetpublications_publications |
|
|
Restrict delete | ||
| fk_chroncontrolscal14c_calibrationcurves |
|
|
Cascade on delete | ||
| fk_chroncontrolscal14c_chroncontrols |
|
|
Cascade on delete | ||
| fk_chroncontrolscal14c_calibrationprograms |
|
|
Cascade on delete | ||
| fk_depenvthigherid |
|
|
Restrict delete | ||
| fk_geochronology_agetypes |
|
|
Restrict delete | ||
| fk_geochronology_geochrontypes |
|
|
Cascade on delete | ||
| fk_geochronology_samples |
|
|
Cascade on delete | ||
| fk_relativeages_relativeagescales |
|
|
Cascade on delete | ||
| fk_relativeages_relativeageunits |
|
|
Cascade on delete | ||
| fk_constituentdatabases_contacts |
|
|
Restrict delete | ||
| fk_elementtaxagroupportions_elementportions |
|
|
Cascade on delete | ||
| fk_elementtaxagroupportions_elementtaxagroups |
|
|
Cascade on delete | ||
| fk_ecolgroups_ecolsettypes |
|
|
Cascade on delete | ||
| fk_ecolgroups_ecolgrouptypes |
|
|
Cascade on delete | ||
| fk_ecolgroups_taxa |
|
|
Cascade on delete | ||
| fk_elementtaxagrouptypes_elementtypes |
|
|
Cascade on delete | ||
| fk_elementtaxagrouptypes_taxagrouptypes |
|
|
Cascade on delete | ||
| fk_dataprocessors_contacts |
|
|
Restrict delete | ||
| fk_dataprocessors_datasets |
|
|
Cascade on delete | ||
| contactreferences_exdatabaseid_fkey |
|
|
Restrict delete | ||
| contactreferences_contactid_fkey |
|
|
Restrict delete | ||
| fk_analysisunits_collectionunits |
|
|
Cascade on delete | ||
| fk_analysisunits_faciestypes |
|
|
Cascade on delete | ||
| fk_datasettaxonnotes_datasets |
|
|
Cascade on delete | ||
| fk_datasettaxonnotes_taxa |
|
|
Cascade on delete | ||
| fk_datasettaxonnotes_contacts |
|
|
Restrict delete | ||
| fk_isospecimendata_data |
|
|
Cascade on delete | ||
| fk_isospecimendata_specimens |
|
|
Cascade on delete | ||
| evt_cct |
|
|
Restrict delete | ||
| fk_variableelements_elementportions |
|
|
Cascade on delete | ||
| fk_variableelements_elementmaturities |
|
|
Cascade on delete | ||
| fk_variableelements_elementsymmetries |
|
|
Cascade on delete | ||
| fk_variableelements_elementtypes |
|
|
Restrict delete | ||
| fk_analysisunitlithostrat_analysisunits |
|
|
Cascade on delete | ||
| fk_analysisunitlithostrat_lithostrat |
|
|
Cascade on delete | ||
| fk_tephras_events |
|
|
Cascade on delete | ||
| fk_tephras_analysisunits |
|
|
Cascade on delete | ||
| taxonpaths_taxonid_fkey |
|
|
Restrict delete | ||
| geopaths_geoin_fkey |
|
|
Restrict delete | ||
| fk_datasetpis_contacts |
|
|
Restrict delete | ||
| fk_datasetpis_datasets |
|
|
Cascade on delete | ||
| fk_externaltaxa_taxa |
|
|
Cascade on delete | ||
| fk_externaltaxa_externaldatabases |
|
|
Cascade on delete | ||
| fk_datasetsubmissions_datasets |
|
|
Cascade on delete | ||
| fk_datasetsubmissions_contacts |
|
|
Restrict delete | ||
| fk_datasetsubmissions_datasetsubmissiontypes |
|
|
Cascade on delete | ||
| fk_datasetsubmissions_constituentdatabases |
|
|
Cascade on delete | ||
| fk_isoinstrumentation_isoinstrumentationtypes |
|
|
Cascade on delete | ||
| fk_isoinstrumentation_variables |
|
|
Cascade on delete | ||
| fk_isoinstrumentation_datasets |
|
|
Cascade on delete | ||
| fk_isoinstrumentation_isosampleintrosystemtypes |
|
|
Cascade on delete | ||
| fk_datasettypeid |
|
|
Restrict delete | ||
| edt_group |
|
|
Restrict delete | ||
| fk_datasetvariables_datasets |
|
|
Cascade on delete | ||
| fk_datasetvariables_variables |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| leadmodels | leadmodels_cumulativeinventory_check | ((cumulativeinventory > (0)::numeric)) |