Constraints

222 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_aggregatesamples_samples
aggregatesamples.sampleid
samples.sampleid
Cascade on delete
fk_aggregatesamples_aggregatedatasets
aggregatesamples.aggregatedatasetid
aggregatedatasets.aggregatedatasetid
Cascade on delete
fk_aggregatesampleages_aggregatechronologies
aggregatesampleages.aggregatechronid
aggregatechronologies.aggregatechronid
Restrict delete
fk_aggregatesampleages_sampleages
aggregatesampleages.sampleageid
sampleages.sampleageid
Cascade on delete
fk_aggregatesampleages_aggregatedatasets
aggregatesampleages.aggregatedatasetid
aggregatedatasets.aggregatedatasetid
Cascade on delete
fk_chroncontrols_agetypes
chroncontrols.agetypeid
agetypes.agetypeid
Restrict delete
fk_chroncontrols_chronologies
chroncontrols.chronologyid
chronologies.chronologyid
Cascade on delete
fk_chroncontrols_chroncontroltypes
chroncontrols.chroncontroltypeid
chroncontroltypes.chroncontroltypeid
Cascade on delete
fk_chroncontrols_analysisunits
chroncontrols.analysisunitid
analysisunits.analysisunitid
Restrict delete
fk_datasetdoi_datasets
datasetdoi.datasetid
datasets.datasetid
Restrict delete
fk_accumulationrates_variableunits
accumulationrates.variableunitsid
variableunits.variableunitsid
Cascade on delete
fk_accumulationrates_analysisunits
accumulationrates.analysisunitid
analysisunits.analysisunitid
Cascade on delete
fk_accumulationrates_chronologies
accumulationrates.chronologyid
chronologies.chronologyid
Restrict delete
pub_pty
publications.pubtypeid
publicationtypes.pubtypeid
Restrict delete
fk_eventpublications_publications
eventpublications.publicationid
publications.publicationid
Cascade on delete
fk_eventpublications_events
eventpublications.eventid
events.eventid
Cascade on delete
fk_samples_taxa
samples.taxonid
taxa.taxonid
Restrict delete
fk_samples_analysisunits
samples.analysisunitid
analysisunits.analysisunitid
Restrict delete
fk_samples_datasets
samples.datasetid
datasets.datasetid
Restrict delete
fk_isostratdata_data
isostratdata.dataid
data.dataid
Cascade on delete
fk_isostratdata_elementtypes
isostratdata.elementtypeid
elementtypes.elementtypeid
Cascade on delete
fk_isostratdata_taxa
isostratdata.taxonid
taxa.taxonid
Restrict delete
fk_lithology_collectionunits
lithology.collectionunitid
collectionunits.collectionunitid
Cascade on delete
fk_isosamplepretreatments_data
isosamplepretreatments.dataid
data.dataid
Cascade on delete
fk_isosamplepretreatments_isopretratmenttypes
isosamplepretreatments.isopretreatmenttypeid
isopretreatmenttypes.isopretreatmenttypeid
Cascade on delete
fk_geochronpublications_geochronology
geochronpublications.geochronid
geochronology.geochronid
Cascade on delete
fk_geochronpublications_publications
geochronpublications.publicationid
publications.publicationid
Cascade on delete
fk_formtaxa_taxa1
formtaxa.affinityid
taxa.taxonid
Cascade on delete
fk_formtaxa_publications
formtaxa.publicationid
publications.publicationid
Cascade on delete
fk_formtaxa_taxa
formtaxa.taxonid
taxa.taxonid
Restrict delete
fk_chroncontrolranks_chroncontrols
chroncontrolranks.chroncontrolid
chroncontrols.chroncontrolid
Cascade on delete
fk_chroncontrolranks_chroncontrolaccuracydistributions
chroncontrolranks.accuracydistributionid
chroncontrolaccuracydistributions.accuracydistributionid
Cascade on delete
fk_chroncontrolranks_chroncontrolaccuracyranks
chroncontrolranks.accuracyrankid
chroncontrolaccuracyranks.accuracyrankid
Cascade on delete
fk_chroncontrolranks_chroncontrolaccuracydirections
chroncontrolranks.accuracydirectionid
chroncontrolaccuracydirections.accuracydirectionid
Cascade on delete
fk_chroncontrolranks_chroncontrolprecisionranks
chroncontrolranks.precisionrankid
chroncontrolprecisionranks.precisionrankid
Cascade on delete
fk_summarydatataphonomy_taphonomictypes
summarydatataphonomy.taphonomictypeid
taphonomictypes.taphonomictypeid
Cascade on delete
fk_summarydatataphonomy_data
summarydatataphonomy.dataid
data.dataid
Cascade on delete
fk_chronologies_agetypes
chronologies.agetypeid
agetypes.agetypeid
Cascade on delete
fk_chronologies_collectionunits
chronologies.collectionunitid
collectionunits.collectionunitid
Cascade on delete
fk_chronologies_contacts
chronologies.contactid
contacts.contactid
Restrict delete
fk_highertaxonid
taxa.highertaxonid
taxa.taxonid
Restrict delete
fk_taxagroupid
taxa.taxagroupid
taxagrouptypes.taxagroupid
Restrict delete
fk_validatorid
taxa.validatorid
contacts.contactid
Restrict delete
fk_publicationid
taxa.publicationid
publications.publicationid
Restrict delete
fk_sampleanalysts_contacts
sampleanalysts.contactid
contacts.contactid
Restrict delete
fk_sampleanalysts_samples
sampleanalysts.sampleid
samples.sampleid
Cascade on delete
sd_smpid
specimendates.sampleid
samples.sampleid
Restrict delete
fk_specimendates_specimens
specimendates.specimenid
specimens.specimenid
Cascade on delete
sd_fcid
specimendates.fractionid
fractiondated.fractionid
Restrict delete
sd_txid
specimendates.taxonid
taxa.taxonid
Restrict delete
sd_etyid
specimendates.elementtypeid
elementtypes.elementtypeid
Restrict delete
sd_gcid
specimendates.geochronid
geochronology.geochronid
Restrict delete
fk_analysisunitaltdepths_analysisunits
analysisunitaltdepths.analysisunitid
analysisunits.analysisunitid
Cascade on delete
fk_analysisunitaltdepths_analysisunitaltdepthscales
analysisunitaltdepths.altdepthscaleid
analysisunitaltdepthscales.altdepthscaleid
Cascade on delete
fk_unitsdatasettypes_variableunits
unitsdatasettypes.variableunitsid
variableunits.variableunitsid
Cascade on delete
fk_unitsdatasettypes_datasettypes
unitsdatasettypes.datasettypeid
datasettypes.datasettypeid
Cascade on delete
fk_isovariablescaletypes_isoscaletypes
isovariablescaletypes.isoscaletypeid
isoscaletypes.isoscaletypeid
Cascade on delete
fk_isovariablescaletypes_variables
isovariablescaletypes.variableid
variables.variableid
Cascade on delete
fk_isomatanalsubstrate_isomaterialanalyzedtypes
isomatanalsubstrate.isomatanaltypeid
isomaterialanalyzedtypes.isomatanaltypeid
Cascade on delete
fk_isomatanalsubstrate_isosubstratetypes
isomatanalsubstrate.isosubstratetypeid
isosubstratetypes.isosubstratetypeid
Cascade on delete
fk_siteimages_contacts
siteimages.contactid
contacts.contactid
Restrict delete
fk_siteimages_sites
siteimages.siteid
sites.siteid
Cascade on delete
fk_elementtaxagroupmaturities_elementtaxagroup
elementtaxagroupmaturities.elementtaxagroupid
elementtaxagroups.elementtaxagroupid
Cascade on delete
fk_elementtaxagroupmaturities_elementmaturities
elementtaxagroupmaturities.maturityid
elementmaturities.maturityid
Cascade on delete
fk_repositoryspecimens_datasets
repositoryspecimens.datasetid
datasets.datasetid
Cascade on delete
fk_repositoryspecimens_repositoryinstitutions
repositoryspecimens.repositoryid
repositoryinstitutions.repositoryid
Restrict delete
fk_specimens_repositoryinstitutions
specimens.repositoryid
repositoryinstitutions.repositoryid
Cascade on delete
fk_specimens_data
specimens.dataid
data.dataid
Cascade on delete
fk_specimens_elementportions
specimens.portionid
elementportions.portionid
Restrict delete
fk_specimens_elementsymmetries
specimens.symmetryid
elementsymmetries.symmetryid
Restrict delete
fk_specimens_elementmaturities
specimens.maturityid
elementmaturities.maturityid
Restrict delete
fk_specimens_elementtypes
specimens.elementtypeid
elementtypes.elementtypeid
Cascade on delete
fk_specimens_specimendomesticstatus
specimens.domesticstatusid
specimendomesticstatustypes.domesticstatusid
Cascade on delete
fk_specimens_specimensex
specimens.sexid
specimensextypes.sexid
Cascade on delete
fk_taphonomictypes_taphonomicsystems
taphonomictypes.taphonomicsystemid
taphonomicsystems.taphonomicsystemid
Cascade on delete
fk_datataxonnotes_data
datataxonnotes.dataid
data.dataid
Cascade on delete
fk_datataxonnotes_contacts
datataxonnotes.contactid
contacts.contactid
Restrict delete
fk_relativeagepublications_publications
relativeagepublications.publicationid
publications.publicationid
Cascade on delete
fk_relativeagepublications_relativeages
relativeagepublications.relativeageid
relativeages.relativeageid
Cascade on delete
fk_externalpublications_externaldatabases
externalpublications.extdatabaseid
externaldatabases.extdatabaseid
Cascade on delete
fk_externalpublications_publications
externalpublications.publicationid
publications.publicationid
Cascade on delete
fk_isometadata_isomaterialanalyzedtypes
isometadata.isomatanaltypeid
isomaterialanalyzedtypes.isomatanaltypeid
Null on delete
fk_isometadata_contacts
isometadata.analystid
contacts.contactid
Restrict delete
fk_isometadata_isosubstratetypes
isometadata.isosubstratetypeid
isosubstratetypes.isosubstratetypeid
Null on delete
fk_isometadata_data
isometadata.dataid
data.dataid
Cascade on delete
fk_radiocarbonmethodid
radiocarbon.radiocarbonmethodid
radiocarbonmethods.radiocarbonmethodid
Restrict delete
fk_collectionunits_collectiontypes
collectionunits.colltypeid
collectiontypes.colltypeid
Cascade on delete
fk_collectionunits_rocktypes
collectionunits.substrateid
rocktypes.rocktypeid
Cascade on delete
fk_collectionunits_sites
collectionunits.siteid
sites.siteid
Cascade on delete
fk_collectionunits_depenvttypes
collectionunits.depenvtid
depenvttypes.depenvtid
Cascade on delete
fk_samplekeywords_samples
samplekeywords.sampleid
samples.sampleid
Cascade on delete
fk_samplekeywords_keywords
samplekeywords.keywordid
keywords.keywordid
Restrict delete
fk_depagents_depagenttypes
depagents.depagentid
depagenttypes.depagentid
Cascade on delete
fk_depagents_analysisunits
depagents.analysisunitid
analysisunits.analysisunitid
Cascade on delete
fk_specimentaphonomy_specimens
specimentaphonomy.specimenid
specimens.specimenid
Cascade on delete
fk_specimentaphonomy_taphonomictypes
specimentaphonomy.taphonomictypeid
taphonomictypes.taphonomictypeid
Cascade on delete
fk_lithostratunits_lithostrattypes
lithostrat.lithostratunitid
lithostratunits.lithostratunitid
Cascade on delete
fk_higherlithostratid
lithostrat.higherlithostratid
lithostrat.lithostratid
Restrict delete
fk_higherrocktypeid
rocktypes.higherrocktypeid
rocktypes.rocktypeid
Restrict delete
fk_synonymy_contacts
synonymy.contactid
contacts.contactid
Restrict delete
fk_synonymy_publications
synonymy.publicationid
publications.publicationid
Cascade on delete
fk_synonymy_taxa2
synonymy.reftaxonid
taxa.taxonid
Restrict delete
fk_synonymy_taxa1
synonymy.taxonid
taxa.taxonid
Cascade on delete
fk_synonymy_datasets
synonymy.datasetid
datasets.datasetid
Cascade on delete
fk_variables_variableunits
variables.variableunitsid
variableunits.variableunitsid
Cascade on delete
fk_variables_variablecontexts
variables.variablecontextid
variablecontexts.variablecontextid
Cascade on delete
fk_variables_taxa
variables.taxonid
taxa.taxonid
Cascade on delete
fk_variables_variableelements
variables.variableelementid
variableelements.variableelementid
Cascade on delete
fk_synonyms_synonymtypes
synonyms.synonymtypeid
synonymtypes.synonymtypeid
Cascade on delete
fk_synonyms_invalidtaxa
synonyms.invalidtaxonid
taxa.taxonid
Cascade on delete
fk_synonyms_validtaxa
synonyms.validtaxonid
taxa.taxonid
Restrict delete
fk_contacts_contactstatuses
contacts.contactstatusid
contactstatuses.contactstatusid
Null on delete
fk_sitegeopolitical_geopoliticalunits
sitegeopolitical.geopoliticalid
geopoliticalunits.geopoliticalid
Restrict delete
fk_sitegeopolitical_sites
sitegeopolitical.siteid
sites.siteid
Cascade on delete
fk_events_eventtypes
events.eventtypeid
eventtypes.eventtypeid
Cascade on delete
fk_elementtaxagroupsymmetries_elementtaxagroups
elementtaxagroupsymmetries.elementtaxagroupid
elementtaxagroups.elementtaxagroupid
Cascade on delete
fk_elementtaxagroupsymmetries_elementsymmetries
elementtaxagroupsymmetries.symmetryid
elementsymmetries.symmetryid
Cascade on delete
fk_datasetdatabases_constituentdatabases
datasetdatabases.databaseid
constituentdatabases.databaseid
Cascade on delete
fk_datasetdatabases_datasets
datasetdatabases.datasetid
datasets.datasetid
Cascade on delete
fk_isobiomarkerbands_isobiomarkertypes
isobiomarkerbandtypes.isobiomarkertypeid
isobiomarkertypes.isobiomarkertypeid
Cascade on delete
fk_sampleages_samples
sampleages.sampleid
samples.sampleid
Cascade on delete
fk_sampleages_chronologies
sampleages.chronologyid
chronologies.chronologyid
Cascade on delete
fk_isostandards_datasets
isostandards.datasetid
datasets.datasetid
Cascade on delete
fk_isostandards_variables
isostandards.variableid
variables.variableid
Cascade on delete
fk_isostandards_isostandardtypes
isostandards.isostandardid
isostandardtypes.isostandardtypeid
Cascade on delete
fk_datasettaxagrouptypes_datasettypes
datasettaxagrouptypes.datasettypeid
datasettypes.datasettypeid
Cascade on delete
fk_datasettaxagrouptypes_taxagrouptypes
datasettaxagrouptypes.taxagroupid
taxagrouptypes.taxagroupid
Cascade on delete
fk_publicationtranslators_publications
publicationtranslators.publicationid
publications.publicationid
Cascade on delete
fk_taphonomicsystemsdatasettypes_taphonomicsystemsdatasettypes
taphonomicsystemsdatasettypes.datasettypeid
datasettypes.datasettypeid
Cascade on delete
fk_taphonomicsystemsdatasettypes_taphonomicsystems
taphonomicsystemsdatasettypes.taphonomicsystemid
taphonomicsystems.taphonomicsystemid
Cascade on delete
evc_alu
eventchronology.analysisunitid
analysisunits.analysisunitid
Restrict delete
evc_evt
eventchronology.eventid
events.eventid
Restrict delete
evc_ccid
eventchronology.chroncontrolid
chroncontrols.chroncontrolid
Restrict delete
fk_aggregatechronologies_agetypes
aggregatechronologies.agetypeid
agetypes.agetypeid
Cascade on delete
fk_aggregatechronologies_aggregatedatasets
aggregatechronologies.aggregatedatasetid
aggregatedatasets.aggregatedatasetid
Cascade on delete
fk_relativechronology_relativeages
relativechronology.relativeageid
relativeages.relativeageid
Cascade on delete
rc_ccid
relativechronology.chroncontrolid
chroncontrols.chroncontrolid
Restrict delete
fk_relativechronology_analysisunits
relativechronology.analysisunitid
analysisunits.analysisunitid
Cascade on delete
fk_aggregatedatasets_aggregateordertypes
aggregatedatasets.aggregateordertypeid
aggregateordertypes.aggregateordertypeid
Cascade on delete
fk_collectors_contacts
collectors.contactid
contacts.contactid
Restrict delete
fk_collectors_collectionunits
collectors.collectionunitid
collectionunits.collectionunitid
Cascade on delete
fk_taxaalthierarchy_taxa
taxaalthierarchy.taxonid
taxa.taxonid
Cascade on delete
fk_taxaalthierarchy_taxa1
taxaalthierarchy.highertaxonid
taxa.taxonid
Restrict delete
fk_taxaalthierarchy_taxaalthierarchytypes
taxaalthierarchy.taxaalthierarchytypeid
taxaalthierarchytypes.taxaalthierarchytypeid
Cascade on delete
fk_publicationeditors_publications
publicationeditors.publicationid
publications.publicationid
Cascade on delete
fk_isosrmetadata_datasets
isosrmetadata.datasetid
datasets.datasetid
Cascade on delete
fk_isosrmetadata_variables
isosrmetadata.variableid
variables.variableid
Cascade on delete
fk_specimendatescal_specimendates
specimendatescal.specimendateid
specimendates.specimendateid
Cascade on delete
fk_specimendatescal_calibrationcurves
specimendatescal.calibrationcurveid
calibrationcurves.calibrationcurveid
Cascade on delete
fk_specimendatescal_calibrationprograms
specimendatescal.calibrationprogramid
calibrationprograms.calibrationprogramid
Cascade on delete
fk_calibrationcurves_publications
calibrationcurves.publicationid
publications.publicationid
Cascade on delete
fk_contextsdatasettypes_variablecontexts
contextsdatasettypes.variablecontextid
variablecontexts.variablecontextid
Cascade on delete
fk_contextsdatasettypes_datasettypes
contextsdatasettypes.datasettypeid
datasettypes.datasettypeid
Cascade on delete
fk_datasets_collectionunits
datasets.collectionunitid
collectionunits.collectionunitid
Cascade on delete
fk_datasets_datasettypes
datasets.datasettypeid
datasettypes.datasettypeid
Cascade on delete
fk_datasets_embargo
datasets.embargoid
embargo.embargoid
Cascade on delete
fk_lakeparameters_sites
lakeparameters.siteid
sites.siteid
Cascade on delete
fk_lakeparameters_lakeparametertypes
lakeparameters.lakeparameterid
lakeparametertypes.lakeparameterid
Cascade on delete
fk_data_samples
data.sampleid
samples.sampleid
Cascade on delete
fk_data_variables
data.variableid
variables.variableid
Cascade on delete
fk_geochroncontrols_chroncontrols
geochroncontrols.chroncontrolid
chroncontrols.chroncontrolid
Restrict delete
fk_geochroncontrols_geochronology
geochroncontrols.geochronid
geochronology.geochronid
Restrict delete
fk_publicationauthors_contacts
publicationauthors.contactid
contacts.contactid
Restrict delete
fk_publicationauthors_publications
publicationauthors.publicationid
publications.publicationid
Cascade on delete
fk_specimengenbank_specimens
specimengenbank.specimenid
specimens.specimenid
Cascade on delete
fk_higherchroncontroltypeid
chroncontroltypes.higherchroncontroltypeid
chroncontroltypes.chroncontroltypeid
Restrict delete
fk_analysisunitaltdepths_variableunits
analysisunitaltdepthscales.variableunitsid
variableunits.variableunitsid
Cascade on delete
fk_datasetpublications_datasets
datasetpublications.datasetid
datasets.datasetid
Cascade on delete
fk_datasetpublications_publications
datasetpublications.publicationid
publications.publicationid
Restrict delete
fk_chroncontrolscal14c_calibrationcurves
chroncontrolscal14c.calibrationcurveid
calibrationcurves.calibrationcurveid
Cascade on delete
fk_chroncontrolscal14c_chroncontrols
chroncontrolscal14c.chroncontrolid
chroncontrols.chroncontrolid
Cascade on delete
fk_chroncontrolscal14c_calibrationprograms
chroncontrolscal14c.calibrationprogramid
calibrationprograms.calibrationprogramid
Cascade on delete
fk_depenvthigherid
depenvttypes.depenvthigherid
depenvttypes.depenvtid
Restrict delete
fk_geochronology_agetypes
geochronology.agetypeid
agetypes.agetypeid
Restrict delete
fk_geochronology_geochrontypes
geochronology.geochrontypeid
geochrontypes.geochrontypeid
Cascade on delete
fk_geochronology_samples
geochronology.sampleid
samples.sampleid
Cascade on delete
fk_relativeages_relativeagescales
relativeages.relativeagescaleid
relativeagescales.relativeagescaleid
Cascade on delete
fk_relativeages_relativeageunits
relativeages.relativeageunitid
relativeageunits.relativeageunitid
Cascade on delete
fk_constituentdatabases_contacts
constituentdatabases.contactid
contacts.contactid
Restrict delete
fk_elementtaxagroupportions_elementportions
elementtaxagroupportions.portionid
elementportions.portionid
Cascade on delete
fk_elementtaxagroupportions_elementtaxagroups
elementtaxagroupportions.elementtaxagroupid
elementtaxagroups.elementtaxagroupid
Cascade on delete
fk_ecolgroups_ecolsettypes
ecolgroups.ecolsetid
ecolsettypes.ecolsetid
Cascade on delete
fk_ecolgroups_ecolgrouptypes
ecolgroups.ecolgroupid
ecolgrouptypes.ecolgroupid
Cascade on delete
fk_ecolgroups_taxa
ecolgroups.taxonid
taxa.taxonid
Cascade on delete
fk_elementtaxagrouptypes_elementtypes
elementtaxagroups.elementtypeid
elementtypes.elementtypeid
Cascade on delete
fk_elementtaxagrouptypes_taxagrouptypes
elementtaxagroups.taxagroupid
taxagrouptypes.taxagroupid
Cascade on delete
fk_dataprocessors_contacts
dataprocessors.contactid
contacts.contactid
Restrict delete
fk_dataprocessors_datasets
dataprocessors.datasetid
datasets.datasetid
Cascade on delete
fk_analysisunits_collectionunits
analysisunits.collectionunitid
collectionunits.collectionunitid
Cascade on delete
fk_analysisunits_faciestypes
analysisunits.faciesid
faciestypes.faciesid
Cascade on delete
fk_datasettaxonnotes_datasets
datasettaxonnotes.datasetid
datasets.datasetid
Cascade on delete
fk_datasettaxonnotes_taxa
datasettaxonnotes.taxonid
taxa.taxonid
Cascade on delete
fk_datasettaxonnotes_contacts
datasettaxonnotes.contactid
contacts.contactid
Restrict delete
fk_isospecimendata_data
isospecimendata.dataid
data.dataid
Cascade on delete
fk_isospecimendata_specimens
isospecimendata.specimenid
specimens.specimenid
Restrict delete
evt_cct
eventtypes.chroncontroltypeid
chroncontroltypes.chroncontroltypeid
Restrict delete
fk_variableelements_elementportions
variableelements.portionid
elementportions.portionid
Cascade on delete
fk_variableelements_elementmaturities
variableelements.maturityid
elementmaturities.maturityid
Cascade on delete
fk_variableelements_elementsymmetries
variableelements.symmetryid
elementsymmetries.symmetryid
Cascade on delete
fk_variableelements_elementtypes
variableelements.elementtypeid
elementtypes.elementtypeid
Restrict delete
fk_analysisunitlithostrat_analysisunits
analysisunitlithostrat.analysisunitid
analysisunits.analysisunitid
Cascade on delete
fk_analysisunitlithostrat_lithostrat
analysisunitlithostrat.lithostratid
lithostrat.lithostratid
Cascade on delete
fk_tephras_events
tephras.eventid
events.eventid
Cascade on delete
fk_tephras_analysisunits
tephras.analysisunitid
analysisunits.analysisunitid
Cascade on delete
taxonpaths_taxonid_fkey
taxonpaths.taxonid
taxa.taxonid
Restrict delete
geopaths_geoin_fkey
geopaths.geoin
geopoliticalunits.geopoliticalid
Restrict delete
fk_datasetpis_contacts
datasetpis.contactid
contacts.contactid
Restrict delete
fk_datasetpis_datasets
datasetpis.datasetid
datasets.datasetid
Cascade on delete
fk_externaltaxa_taxa
externaltaxa.taxonid
taxa.taxonid
Cascade on delete
fk_externaltaxa_externaldatabases
externaltaxa.extdatabaseid
externaldatabases.extdatabaseid
Cascade on delete
fk_datasetsubmissions_datasets
datasetsubmissions.datasetid
datasets.datasetid
Cascade on delete
fk_datasetsubmissions_contacts
datasetsubmissions.contactid
contacts.contactid
Restrict delete
fk_datasetsubmissions_datasetsubmissiontypes
datasetsubmissions.submissiontypeid
datasetsubmissiontypes.submissiontypeid
Cascade on delete
fk_datasetsubmissions_constituentdatabases
datasetsubmissions.databaseid
constituentdatabases.databaseid
Cascade on delete
fk_isoinstrumentation_isoinstrumentationtypes
isoinstrumentation.isoinstrumentationtypeid
isoinstrumentationtypes.isoinstrumentationtypeid
Cascade on delete
fk_isoinstrumentation_variables
isoinstrumentation.variableid
variables.variableid
Cascade on delete
fk_isoinstrumentation_datasets
isoinstrumentation.datasetid
datasets.datasetid
Cascade on delete
fk_isoinstrumentation_isosampleintrosystemtypes
isoinstrumentation.isosampleintrosystemtypeid
isosampleintrosystemtypes.isosampleintrosystemtypeid
Cascade on delete
fk_datasettypeid
elementdatasettaxagroups.datasettypeid
datasettypes.datasettypeid
Restrict delete
edt_group
elementdatasettaxagroups.taxagroupid
taxagrouptypes.taxagroupid
Restrict delete
fk_datasetvariables_datasets
datasetvariables.datasetid
datasets.datasetid
Cascade on delete
fk_datasetvariables_variables
datasetvariables.variableid
variables.variableid
Cascade on delete

Check Constraints

Table Constraint Name Constraint