be10_denude_new.public

260 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

<--DATASETID_from_global_DataSetMaster_fkey

global_datasetpublicationID.DATASETID

global_DataSetMaster.DATASETID

Restrict delete

<--REFDBID_from_global_RefCore_fkey

global_datasetpublicationID.REFDBID

global_RefCore.REFDBID

Restrict delete

<--OBSID1_from_arch_c14_DataCore_fkey

arch_c14_polygons_EPSG3857.OBSID1

arch_c14_DataCore.OBSID1

Restrict delete

<--TAXAGRPID_from_cabah_taxagroupID_table

cabah_taxaID.TAXAGRPID

cabah_taxagroupID.TAXAGRPID

Restrict delete

<--CONTACTID_from_neo_contacts_fkey

cabah_taxaID.NEOVALORID

neo_contacts.CONTACTID

Restrict delete

<--TAXONID_from_cabah_taxaID_fkey

cabah_taxaID.PARENTID

cabah_taxaID.TAXONID

Restrict delete

<--SITECODEID_from_global_SiteCode_fkey

global_SiteMaster.SITECODEID

global_SiteCode.SITECODEID

Restrict delete

<--BIOMEID_from_global_biomeID_fkey

global_SiteMaster.BIOMEID

global_biomeID.BIOMEID

Restrict delete

<--METASITEID_from_global_MetaSite_fkey

global_SiteMaster.METASITEID

global_MetaSite.METASITEID

Restrict delete

<--IBRAID_from_global_ibraID_fkey

global_SiteMaster.IBRAID

global_ibraID.IBRAID

Restrict delete

<--CATCHSZEID_from_cabah_catchmentsizeID_fkey

global_SiteMaster.CATCHSZEID

cabah_catchmentsizeID.CATCHSZEID

Restrict delete

<--FLOWTYPEID_from_cabah_flowtypeID_fkey

global_SiteMaster.FLOWTYPEID

cabah_flowtypeID.FLOWTYPEID

Restrict delete

<--RIVID_from_global_rivID_fkey

global_SiteMaster.RIVID

global_rivID.RIVID

Restrict delete

<--BASINSZEID_from_cabah_basinsizeID_fkey

global_SiteMaster.BASINSZEID

cabah_basinsizeID.BASINSZEID

Restrict delete

<--OBSID1_from_crn_be_DataCore_fkey

crn_v3_basins_EPSG3857.OBSID1

crn_be_DataCore.OBSID1

Restrict delete

<--OBSID1_from_crn_al_DataCore_fkey

crn_v3_basins_EPSG3857.OBSID1

crn_al_DataCore.OBSID1

Restrict delete

<--STUDYID_from_crn_studies_boundingbox_fkey

crn_v3_basins_EPSG3857.STUDYID

crn_studies_boundingbox.STUDYID

Restrict delete

<--VERID_from_global_dbDOI_fkey

arch_c14_DataCore.VERID

global_dbDOI.VERID

Restrict delete

<--C13_VALID_from_c13_valID_fkey

arch_c14_DataCore.C13_VALID

c13_valID.C13_VALID

Restrict delete

pctn<--C_MTDID_from_c_mtdID_fkey

arch_c14_DataCore.PCT_N_MTID

c_mtdID.C_MTDID

Restrict delete

<--CHEMPREPID_from_cabah_chemprepID_fkey

arch_c14_DataCore.CHEMPREPID

cabah_chemprepID.CHEMPREPID

Restrict delete

n15<--C_MTDID_from_c_mtdID_fkey

arch_c14_DataCore.N15_MTDID

c_mtdID.C_MTDID

Restrict delete

<--METHODID_from_cabah_methodID_fkey

arch_c14_DataCore.METHODID

cabah_methodID.METHODID

Restrict delete

<--MATERIA1ID_from_C14_materia1ID_fkey

arch_c14_DataCore.MATERIA1ID

c14_materia1ID.MATERIA1ID

Restrict delete

<--COL_MTDID_from_cabah_col_mtdID_fkey

arch_c14_DataCore.COL_MTDID

cabah_col_mtdID.COL_MTDID

Restrict delete

<--SMPID_from_arch_Sample_fkey

arch_c14_DataCore.SMPID

arch_Sample.SMPID

Restrict delete

<--CONTAMID_from_c14_contamID_fkey

arch_c14_DataCore.CONTAMID

c14_contamID.CONTAMID

Restrict delete

<--C_MTDID_from_c_mtdID_fkey

arch_c14_DataCore.C_MTDID

c_mtdID.C_MTDID

Restrict delete

<--REFDBID(3)_from_global_RefCore_fkey

arch_c14_DataCore.REFDBID3

global_RefCore.REFDBID

Restrict delete

s34<--C_MTDID_from_c_mtdID_fkey

arch_c14_DataCore.S34_MTDID

c_mtdID.C_MTDID

Restrict delete

o18<--C_MTDID_from_c_mtdID_fkey

arch_c14_DataCore.O18_MTDID

c_mtdID.C_MTDID

Restrict delete

<--REFDBID(1)_from_global_RefCore_fkey

arch_c14_DataCore.REFDBID1

global_RefCore.REFDBID

Restrict delete

<--MATERIA2ID_from_C14_materia2ID_fkey

arch_c14_DataCore.MATERIA2ID

c14_materia2ID.MATERIA2ID

Restrict delete

<--HUM_MODID_from_c14_hum_modID_fkey

arch_c14_DataCore.HUM_MODID

c14_hum_modID.HUM_MODID

Restrict delete

<--LAB_ORIGID_from_cabah_LabCodes_fkey

arch_c14_DataCore.LAB_ORIGID

cabah_LabCodes.LAB_ORIGID

Restrict delete

c13<--C_MTDID_from_c_mtdID_fkey

arch_c14_DataCore.C13_MTDID

c_mtdID.C_MTDID

Restrict delete

cn<--C_MTDID_from_c_mtdID_fkey

arch_c14_DataCore.CN_MTDID

c_mtdID.C_MTDID

Restrict delete

pctc<--C_MTDID_from_c_mtdID_fkey

arch_c14_DataCore.PCT_C_MTID

c_mtdID.C_MTDID

Restrict delete

<--SOLVENT2ID_from_solvent2ID_fkey

arch_c14_DataCore.SOLVENT2ID

c14_solvent2ID.SOLVENT2ID

Restrict delete

<--REFDBID(2)_from_global_RefCore_fkey

arch_c14_DataCore.REFDBID2

global_RefCore.REFDBID

Restrict delete

<--REFDBID(4)_from_global_RefCore_fkey

arch_c14_DataCore.REFDBID4

global_RefCore.REFDBID

Restrict delete

<--SITEID_from_global_SiteMaster_fkey

fos_Sample.SITEID

global_SiteMaster.SITEID

Restrict delete

<--SAMPLEID_from_ippd_Sample_fkey

ippd_DataCore.SAMPLEID

ippd_Sample.SAMPLEID

Restrict delete

<--VARIABLEID_from_ippd_variables_fkey

ippd_DataCore.VARIABLEID

ippd_variables.VARIABLEID

Restrict delete

<--DEPOSITID_from_cabah_depositID_fkey

cabah_depositID.PARENTID

cabah_depositID.DEPOSITID

Restrict delete

<--DATASETID_from_global_DataSetMaster_fkey

ippd_Sample.DATASETID

global_DataSetMaster.DATASETID

Restrict delete

<--ANLYSUNTID_from_cabah_AnalysisUnit_fkey

ippd_Sample.ANLYSUNTID

cabah_AnalysisUnit.ANLYSUNTID

Restrict delete

<--TAXONID_from_cabah_taxaID_fkey

ippd_Sample.TAXONID

cabah_taxaID.TAXONID

Restrict delete

<--NEODSETID_from_global_DataSetMaster_fkey

ippd_Sample.NEODSETID

global_DataSetMaster.NEODSETID

Restrict delete

<--FEATDATEID_from_arch_featdatedID_fkey

arch_Sample.FEATDATEID

arch_featdatedID.FEATDATEID

Restrict delete

<--SITEID_from_global_SiteMaster_fkey

arch_Sample.SITEID

global_SiteMaster.SITEID

Restrict delete

<--SAMPLEID_from_ippd_Sample_fkey

ippd_samplekeywords.SAMPLEID

ippd_Sample.SAMPLEID

Restrict delete

<--KEYWORDID_from_neo_keywords_fkey

ippd_samplekeywords.KEYWORDID

neo_keywords.KEYWORDID

Restrict delete

<--UNITID_from_global_UnitMaster_fkey

neo_chronologies.UNITID

global_UnitMaster.UNITID

Restrict delete

<--CONTACTID_from_neo_contacts_fkey

neo_chronologies.CONTACTID

neo_contacts.CONTACTID

Restrict delete

<--AGETYPEID_from_cabah_agetypeID_fkey

neo_chronologies.AGETYPEID

cabah_agetypeID.AGETYPEID

Restrict delete

<--GRNSIZEID_from_global_GrainSize_fkey

expage_Sample.MATERIALID

global_GrainSize.GRNSIZEID

Restrict delete

<--SITEID_from_global_SiteMaster_fkey

expage_Sample.SITEID

global_SiteMaster.SITEID

Restrict delete

<--FACIESID_from_cabah_faciesID_fkey

sed_faciesID.PARENTID

sed_faciesID.FACIESID

Restrict delete

cabah_col_mtdid_fk

cabah_col_mtdID.PARENTID

cabah_col_mtdID.COL_MTDID

Restrict delete

<--SAMPLEID_from_ippd_Sample_fkey

ippd_sampleages.SAMPLEID

ippd_Sample.SAMPLEID

Restrict delete

<--CHRONLGYID_from_neo_chronologies_fkey

ippd_sampleages.CHRONLGYID

neo_chronologies.CHRONLGYID

Restrict delete

<--OBSID1_from_expage_DataCore_fkey

expage_points_EPSG3857.OBSID1

expage_DataCore.OBSID1

Restrict delete

<--DEPOSITID_from_cabah_depositID_fkey

global_UnitMaster.DEPOSITID

cabah_depositID.DEPOSITID

Restrict delete

<--COL_MTDID_from_cabah_col_mtdID_fkey

global_UnitMaster.COLLECTID

cabah_col_mtdID.COL_MTDID

Restrict delete

<--UNITTYPEID_from_cabah_unittypeID_fkey

global_UnitMaster.UNITTYPEID

cabah_unittypeID.UNITTYPEID

Restrict delete

<--REFDBID_from_global_RefCore_fkey

global_UnitMaster.UNIT_REF

global_RefCore.REFDBID

Restrict delete

<--SITEID_from_global_SiteMaster_fkey

global_UnitMaster.SITEID

global_SiteMaster.SITEID

Restrict delete

<--OBSID1_from_arch_tl_DataCore_fkey

arch_tl_polygons_EPSG3857.OBSID1

arch_tl_DataCore.OBSID1

Restrict delete

<--OBSID1_from_sed-osl_DataCore_fkey

sed-osl_points_EPSG3857.OBSID1

sed-osl_DataCore.OBSID1

Restrict delete

<--OBSID1_from_crn_be_DataCore_fkey

crn_v3_outlets_EPSG3857.OBSID1

crn_be_DataCore.OBSID1

Restrict delete

<--OBSID1_from_crn_al_DataCore_fkey

crn_v3_outlets_EPSG3857.OBSID1

crn_al_DataCore.OBSID1

Restrict delete

<--STUDYID_from_crn_studies_boundingbox_fkey

crn_v3_outlets_EPSG3857.STUDYID

crn_studies_boundingbox.STUDYID

Restrict delete

<--VERID_from_global_dbDOI_fkey

sed-tl_DataCore.VERID

global_dbDOI.VERID

Restrict delete

<--METHODID_from_cabah_methodID_fkey

sed-tl_DataCore.METHODID

cabah_methodID.METHODID

Restrict delete

GMMA_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-tl_DataCore.GMMA_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--COL_MTDID_from_cabah_col_mtdID_fkey

sed-tl_DataCore.COL_MTDID

cabah_col_mtdID.COL_MTDID

Restrict delete

<--REFDBID(3)_from_global_RefCore_fkey

sed-tl_DataCore.REFDBID3

global_RefCore.REFDBID

Restrict delete

<--ED_PROCID_from_osl-tl_ed_procID_fkey

sed-tl_DataCore.ED_PROCID

osl-tl_ed_procID.ED_PROCID

Restrict delete

<--MINERALID_from_osl-tl_mineralID_fkey

sed-tl_DataCore.MINERALID

osl-tl_mineralID.MINERALID

Restrict delete

K_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-tl_DataCore.K_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--REFDBID(1)_from_global_RefCore_fkey

sed-tl_DataCore.REFDBID1

global_RefCore.REFDBID

Restrict delete

ALPH_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-tl_DataCore.ALPH_MTDID

osl-tl_mtdID.MTDID

Restrict delete

TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-tl_DataCore.TH_MTDID

osl-tl_mtdID.MTDID

Restrict delete

U_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-tl_DataCore.U_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--LAB_ORIGID_from_cabah_LabCodes_fkey

sed-tl_DataCore.LAB_ORIGID

cabah_LabCodes.LAB_ORIGID

Cascade on delete

BETA_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-tl_DataCore.BETA_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--LUM_MATID_from_osl-tl_lum_matID_fkey

sed-tl_DataCore.LUM_MATID

osl-tl_lum_matID.LUM_MATID

Restrict delete

U_TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-tl_DataCore.U_TH_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--REFDBID(2)_from_global_RefCore_fkey

sed-tl_DataCore.REFDBID2

global_RefCore.REFDBID

Restrict delete

<--REFDBID(4)_from_global_RefCore_fkey

sed-tl_DataCore.REFDBID4

global_RefCore.REFDBID

Restrict delete

<--AGEMODELID_from_osl-tl_agemodelID_fkey

sed-tl_DataCore.AGEMODELID

osl-tl_agemodelID.AGEMODELID

Restrict delete

<--SMPID_from_sed_Sample_fkey

sed-tl_DataCore.SMPID

sed_Sample.SMPID

Restrict delete

<--VERID_from_global_dbDOI_fkey

arch_tl_DataCore.VERID

global_dbDOI.VERID

Restrict delete

<--METHODID_from_cabah_methodID_fkey

arch_tl_DataCore.METHODID

cabah_methodID.METHODID

Restrict delete

GMMA_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_tl_DataCore.GMMA_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--COL_MTDID_from_cabah_col_mtdID_fkey

arch_tl_DataCore.COL_MTDID

cabah_col_mtdID.COL_MTDID

Restrict delete

<--SMPID_from_arch_Sample_fkey

arch_tl_DataCore.SMPID

arch_Sample.SMPID

Restrict delete

<--REFDBID(3)_from_global_RefCore_fkey

arch_tl_DataCore.REFDBID3

global_RefCore.REFDBID

Restrict delete

<--ED_PROCID_from_osl-tl_ed_procID_fkey

arch_tl_DataCore.ED_PROCID

osl-tl_ed_procID.ED_PROCID

Restrict delete

<--MINERALID_from_osl-tl_mineralID_fkey

arch_tl_DataCore.MINERALID

osl-tl_mineralID.MINERALID

Restrict delete

K_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_tl_DataCore.K_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--REFDBID(1)_from_global_RefCore_fkey

arch_tl_DataCore.REFDBID1

global_RefCore.REFDBID

Restrict delete

ALPH_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_tl_DataCore.ALPH_MTDID

osl-tl_mtdID.MTDID

Restrict delete

TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_tl_DataCore.TH_MTDID

osl-tl_mtdID.MTDID

Restrict delete

U_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_tl_DataCore.U_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--LAB_ORIGID_from_cabah_LabCodes_fkey

arch_tl_DataCore.LAB_ORIGID

cabah_LabCodes.LAB_ORIGID

Restrict delete

BETA_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_tl_DataCore.BETA_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--LUM_MATID_from_osl-tl_lum_matID_fkey

arch_tl_DataCore.LUM_MATID

osl-tl_lum_matID.LUM_MATID

Restrict delete

U_TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_tl_DataCore.U_TH_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--REFDBID(2)_from_global_RefCore_fkey

arch_tl_DataCore.REFDBID2

global_RefCore.REFDBID

Restrict delete

<--REFDBID(4)_from_global_RefCore_fkey

arch_tl_DataCore.REFDBID4

global_RefCore.REFDBID

Restrict delete

<--AGEMODELID_from_osl-tl_agemodelID_fkey

arch_tl_DataCore.AGEMODELID

osl-tl_agemodelID.AGEMODELID

Restrict delete

<--OBSID1_from_arch_osl_DataCore_fkey

arch_osl_polygons_EPSG3857.OBSID1

arch_osl_DataCore.OBSID1

Restrict delete

<--VERID_from_global_dbDOI_fkey

expage_DataCore.VERID

global_dbDOI.VERID

Restrict delete

<--REFDBID(1)_from_global_RefCore_fkey

expage_DataCore.REFDBID1

global_RefCore.REFDBID

Restrict delete

<--ALSTNDID_from_crn_alstndID_fkey

expage_DataCore.ALSTNDID

crn_alstndID.ALSTNDID

Restrict delete

<--SMPID_from_expage_Sample_fkey

expage_DataCore.SMPID

expage_Sample.SMPID

Restrict delete

<--BESTNDID_from_crn_bestndID_fkey

expage_DataCore.BESTNDID

crn_bestndID.BESTNDID

Restrict delete

<--REFDBID(2)_from_global_RefCore_fkey

expage_DataCore.REFDBID2

global_RefCore.REFDBID

Restrict delete

<--REFDBID(4)_from_global_RefCore_fkey

expage_DataCore.REFDBID4

global_RefCore.REFDBID

Restrict delete

<--REFDBID(3)_from_global_RefCore_fkey

expage_DataCore.REFDBID3

global_RefCore.REFDBID

Restrict delete

<--UNITID_from_global_UnitMaster_fkey

char_Sample.UNITID

global_UnitMaster.UNITID

Restrict delete

<--SMPID_from_crn_Sample_fkey

crn_be_DataCore.SMPID

crn_Sample.SMPID

Restrict delete

<--VERID_from_global_dbDOI_fkey

crn_be_DataCore.VERID

global_dbDOI.VERID

Restrict delete

<--REFDBID(1)_from_global_RefCore_fkey

crn_be_DataCore.REFDBID1

global_RefCore.REFDBID

Restrict delete

<--AMSID_from_crn_amsID_fkey

crn_be_DataCore.BEAMSID

crn_amsID.AMSID

Restrict delete

<--BESTNDID_from_crn_bestndID_fkey

crn_be_DataCore.BESTNDID

crn_bestndID.BESTNDID

Restrict delete

<--MATURITYID_from_neo_elementmaturities_fkey

neo_variableelements.MATURITYID

neo_elementmaturities.MATURITYID

Restrict delete

<--SYMMETRYID_from_neo_elementsymmetries_fkey

neo_variableelements.SYMMETRYID

neo_elementsymmetries.SYMMETRYID

Restrict delete

<--PORTIONID_from_neo_elementportions_fkey

neo_variableelements.PORTIONID

neo_elementportions.PORTIONID

Restrict delete

<--ELEMTYPEID_from_neo_elementtypes_fkey

neo_variableelements.ELEMTYPEID

neo_elementtypes.ELEMTYPEID

Restrict delete

sed_laketypeid_fk

sed_laketypeID.PARENTID

sed_laketypeID.LAKETYPEID

Restrict delete

<--GRAINSIZEID_from_global_GrainSize_fkey

sed_Sample.SED_MATID

global_GrainSize.GRNSIZEID

Restrict delete

<--LAKETYPEID_from_sed_laketypeID_fkey

sed_Sample.LAKETYPEID

sed_laketypeID.LAKETYPEID

Restrict delete

<--DEPCONID_from_sed_depconID_fkey

sed_Sample.DEPCONID

sed_depconID.DEPCONID

Restrict delete

<--MORPHID_from_sed_morpID_fkey

sed_Sample.MORPHID

sed_morphID.MORPHID

Restrict delete

<--GEOTYPEID_from_sed_geotypeID_fkey

sed_Sample.GEOTYPEID

sed_geotypeID.GEOTYPEID

Restrict delete

<--SITEID_from_global_SiteMaster_fkey

sed_Sample.SITEID

global_SiteMaster.SITEID

Restrict delete

<--GEOMMODID_from_sed_geommodID_fkey

sed_Sample.GEOMMODID

sed_geommodID.GEOMMODID

Restrict delete

<--SITETYPEID_from_sed_sitetypeID_fkey

sed_Sample.SITETYPEID

sed_sitetypeID.SITETYPEID

Restrict delete

<--FACIESID_from_sed_faciesID_fkey

sed_Sample.FACIESID

sed_faciesID.FACIESID

Restrict delete

<--VARCONTXID_from_neo_variablecontexts_fkey

ippd_variables.VARCONTXID

neo_variablecontexts.VARCONTXID

Restrict delete

<--VARUNITID_from_neo_variableunits_fkey

ippd_variables.VARUNITID

neo_variableunits.VARUNITID

Restrict delete

<--VARELEMTID_from_ippd_variable_fkey

ippd_variables.VARELEMTID

neo_variableelements.VARELEMTID

Restrict delete

<--TAXONID_from_cabah_taxaID_fkey

ippd_variables.TAXONID

cabah_taxaID.TAXONID

Restrict delete

<--CHEMPREPID_from_cabah_chemprepID_fkey

fos_DataCore.CHEMPREPID

cabah_chemprepID.CHEMPREPID

Restrict delete

<--CLASSID_from_fos_TaxRank1_fkey

fos_DataCore.CLASSID

fos_TaxRank1_classID.CLASSID

Restrict delete

<--METHODID_from_CABAH_methodID_fkey

fos_DataCore.FOS_MTDID

cabah_methodID.METHODID

Restrict delete

VERID_from_global_dbDOI_fkey

fos_DataCore.VERID

global_dbDOI.VERID

Restrict delete

<--FAMILYID_from_fos_TaxRank4_fkey

fos_DataCore.FAMILYID

fos_TaxRank4_familyID.FAMILYID

Restrict delete

<--FOSMAT1ID_from_fos_fosmat1ID_fkey

fos_DataCore.FOSMAT1ID

fos_fosmat1ID.FOSMAT1ID

Restrict delete

<--GENUSID_from_fos_TaxRank5_fkey

fos_DataCore.GENUSID

fos_TaxRank5_genusID.GENUSID

Restrict delete

<--SPECIESID_from_fos_TaxRank6_fkey

fos_DataCore.SPECIESID

fos_TaxRank6_speciesID.SPECIESID

Restrict delete

<--ORDRID_from_fos_TaxRank3_fkey

fos_DataCore.ORDRID

fos_TaxRank3_ordrID.ORDRID

Restrict delete

<--REFDBID(3)_from_global_RefCore_fkey

fos_DataCore.REFDBID3

global_RefCore.REFDBID

Restrict delete

<--CHEMTYPEID_from_fos_chemtypeID_fkey

fos_DataCore.CHEMTYPEID

fos_chemtypeID.CHEMTYPEID

Restrict delete

<--MTDSID_from_fos_mtdsID_fkey

fos_DataCore.FOS_MTDSID

fos_mtdsID.FOS_MTDSID

Restrict delete

<--REFDBID(1)_from_global_RefCore_fkey

fos_DataCore.REFDBID1

global_RefCore.REFDBID

Restrict delete

<--INFRACLAID_from_fos_TaxRank2_fkey

fos_DataCore.INFRACLAID

fos_TaxRank2_infraclaID.INFRACLAID

Restrict delete

<--SMPID_from_fos_Sample_fkey

fos_DataCore.SMPID

fos_Sample.SMPID

Restrict delete

<--LAB_ORIGID_from_cabah_LabCodes_fkey

fos_DataCore.LAB_ORIGID

cabah_LabCodes.LAB_ORIGID

Restrict delete

<--FOSMAT2ID_from_fos_fosmat2ID_fkey

fos_DataCore.FOSMAT2ID

fos_fosmat2ID.FOSMAT2ID

Restrict delete

<--REFDBID(2)_from_global_RefCore_fkey

fos_DataCore.REFDBID2

global_RefCore.REFDBID

Restrict delete

<--REFDBID(4)_from_global_RefCore_fkey

fos_DataCore.REFDBID4

global_RefCore.REFDBID

Restrict delete

<--METHODID_from_cabah_methodID_fkey

cabah_chroncontroltypeID.METHODID

cabah_methodID.METHODID

Restrict delete

<--CCONTRLID_from_cabah_chroncontroltypeID_fkey

cabah_chroncontroltypeID.PARENTID

cabah_chroncontroltypeID.CCONTRLID

Restrict delete

<--CSTATUSID_from_global_contactstatusID_fkey

neo_contacts.CSTATUSID

global_contactstatusID.CSTATUSID

Restrict delete

<--CONTACTID_from_neo_contacts_fkey

neo_contacts.ALIASID

neo_contacts.CONTACTID

Restrict delete

<--OAID_from_global_Author_fkey

neo_contacts.OAID

global_Author.OAID

Restrict delete

<--SMPID_from_char_Sample_fkey

char_DataCore.SMPID

char_Sample.SMPID

Restrict delete

<--CHARMTDID_from_c14_charmethodID_fkey

char_DataCore.CHARMTDID

cabah_charmethodID.CHARMTDID

Restrict delete

<--V_UNITID_for_CHARMEASID_from_global_varunitID_fkey

char_DataCore.CHARMEASID

global_varunitID.V_UNITID

Restrict delete

<--V_UNITID_for_WHATAMI_from_global_varunitID_fkey

char_DataCore.WHATAMI

global_varunitID.V_UNITID

Restrict delete

<--METHODID_from_cabah_methodID_fkey

char_DataCore.METHODID

cabah_methodID.METHODID

Restrict delete

<--CALCURVEID_from_c14_calcurve_fkey

char_DataCore.CALCURVEID

c14_calcurve.CALCURVEID

Restrict delete

<--REFDBID_for_REF3_from_global_RefCore_fkey

char_DataCore.REFDBID3

global_RefCore.REFDBID

Restrict delete

<--AGETYPEID_from_cabah_agetypeID_fkey

char_DataCore.AGETYPEID

cabah_agetypeID.AGETYPEID

Restrict delete

<--MATERIA2ID_from_c14_materia2ID_fkey

char_DataCore.MATERIA2ID

c14_materia2ID.MATERIA2ID

Restrict delete

<--REFDBID_for_REF1_from_global_RefCore_fkey

char_DataCore.REFDBID1

global_RefCore.REFDBID

Restrict delete

<--LAB_ORIGID_from_cabah_LabCodes_fkey

char_DataCore.LAB_ORIGID

cabah_LabCodes.LAB_ORIGID

Restrict delete

<--CALPROGID_from_c14_calprogram_fkey

char_DataCore.CALPROGID

c14_calprogram.CALPROGID

Restrict delete

<--V_UNITID_for_CHARSIZEID_from_global_varunitID_fkey

char_DataCore.CHARSIZEID

global_varunitID.V_UNITID

Restrict delete

<--REFDBID_for_REF2_from_global_RefCore_fkey

char_DataCore.REFDBID2

global_RefCore.REFDBID

Restrict delete

<--DATASRCID_from_cabah_datasourceID_fkey

char_DataCore.DATASRCID

cabah_datasourceID.DATASRCID

Restrict delete

<--GRNSIZEID_from_global_GrainSize_fkey

crn_Sample.MATERIAL

global_GrainSize.GRNSIZEID

Restrict delete

<--PROJEPSGID_from_crn_projepsgID_fkey

crn_Sample.PROJEPSGID

crn_projepsgID.PROJEPSGID

Restrict delete

<--SITEID_from_global_SiteMaster_fkey

crn_Sample.SITEID

global_SiteMaster.SITEID

Restrict delete

<--DATASRCID_from_cabah_datasourceID_fkey

neo_elementtypes.DATASRCID

cabah_datasourceID.DATASRCID

Restrict delete

<--VERID_from_global_dbDOI_fkey

sed-osl_DataCore.VERID

global_dbDOI.VERID

Restrict delete

<--METHODID_from_cabah_methodID_fkey

sed-osl_DataCore.METHODID

cabah_methodID.METHODID

Restrict delete

GMMA_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-osl_DataCore.GMMA_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--COL_MTDID_from_cabah_col_mtdID_fkey

sed-osl_DataCore.COL_MTDID

cabah_col_mtdID.COL_MTDID

Restrict delete

<--REFDBID(3)_from_global_RefCore_fkey

sed-osl_DataCore.REFDBID3

global_RefCore.REFDBID

Restrict delete

<--ED_PROCID_from_osl-tl_ed_procID_fkey

sed-osl_DataCore.ED_PROCID

osl-tl_ed_procID.ED_PROCID

Restrict delete

<--OSL_TYPEID_from_osl_typeID_fkey

sed-osl_DataCore.OSL_TYPEID

osl_typeID.OSL_TYPEID

Restrict delete

<--MINERALID_from_osl-tl_mineralID_fkey

sed-osl_DataCore.MINERALID

osl-tl_mineralID.MINERALID

Restrict delete

K_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-osl_DataCore.K_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--REFDBID(1)_from_global_RefCore_fkey

sed-osl_DataCore.REFDBID1

global_RefCore.REFDBID

Restrict delete

ALPH_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-osl_DataCore.ALPH_MTDID

osl-tl_mtdID.MTDID

Restrict delete

TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-osl_DataCore.TH_MTDID

osl-tl_mtdID.MTDID

Restrict delete

U_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-osl_DataCore.U_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--LAB_ORIGID_from_cabah_LabCodes_fkey

sed-osl_DataCore.LAB_ORIGID

cabah_LabCodes.LAB_ORIGID

Restrict delete

BETA_MTDID<--MTDID_from_osl-tl_mtdID_fkey

sed-osl_DataCore.BETA_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--LUM_MATID_from_osl-tl_lum_matID_fkey

sed-osl_DataCore.LUM_MATID

osl-tl_lum_matID.LUM_MATID

Restrict delete

<--REFDBID(2)_from_global_RefCore_fkey

sed-osl_DataCore.REFDBID2

global_RefCore.REFDBID

Restrict delete

<--REFDBID(4)_from_global_RefCore_fkey

sed-osl_DataCore.REFDBID4

global_RefCore.REFDBID

Restrict delete

<--AGEMODELID_from_osl-tl_agemodelID_fkey

sed-osl_DataCore.AGEMODELID

osl-tl_agemodelID.AGEMODELID

Restrict delete

<--SMPID_from_sed_Sample_fkey

sed-osl_DataCore.SMPID

sed_Sample.SMPID

Restrict delete

<--DATASRCID_from_cabah_datasourceID_fkey

cabah_taxagroupID.TXAGRPSRC

cabah_datasourceID.DATASRCID

Restrict delete

<--DATASRCID_from_cabah_datasourceID_fkey

cabah_ecolgroupID.ECOGRPSRC

cabah_datasourceID.DATASRCID

Restrict delete

c14_materia2id_fk

c14_materia2ID.PARENTID

c14_materia2ID.MATERIA2ID

Restrict delete

OBSOLETES_selfref_fkey

global_dbDOI.OBSOLETES

global_dbDOI.VERID

Restrict delete

OBSOLTD_BY_selfref_fkey

global_dbDOI.OBSOLTD_BY

global_dbDOI.VERID

Restrict delete

<--SMPID_from_crn_Sample_fkey

crn_al_DataCore.SMPID

crn_Sample.SMPID

Restrict delete

<--VERID_from_global_dbDOI_fkey

crn_al_DataCore.VERID

global_dbDOI.VERID

Restrict delete

<--REFDBID(1)_from_global_RefCore_fkey

crn_al_DataCore.REFDBID1

global_RefCore.REFDBID

Restrict delete

<--ALSTNDID_from_crn_alstndID_fkey

crn_al_DataCore.ALSTNDID

crn_alstndID.ALSTNDID

Restrict delete

<--AMSID_from_crn_amsID_fkey

crn_al_DataCore.ALAMSID

crn_amsID.AMSID

Restrict delete

global_varunitid_fk

global_varunitID.PARENTID

global_varunitID.V_UNITID

Restrict delete

cabah_methodid_fk

cabah_methodID.PARENTID

cabah_methodID.METHODID

Restrict delete

<--VERID_from_global_dbDOI_fkey

arch_osl_DataCore.VERID

global_dbDOI.VERID

Restrict delete

<--METHODID_from_cabah_methodID_fkey

arch_osl_DataCore.METHODID

cabah_methodID.METHODID

Restrict delete

GMMA_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_osl_DataCore.GMMA_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--COL_MTDID_from_cabah_col_mtdID_fkey

arch_osl_DataCore.COL_MTDID

cabah_col_mtdID.COL_MTDID

Restrict delete

<--SMPID_from_arch_Sample_fkey

arch_osl_DataCore.SMPID

arch_Sample.SMPID

Restrict delete

<--REFDBID(3)_from_global_RefCore_fkey

arch_osl_DataCore.REFDBID3

global_RefCore.REFDBID

Restrict delete

<--ED_PROCID_from_osl-tl_ed_procID_fkey

arch_osl_DataCore.ED_PROCID

osl-tl_ed_procID.ED_PROCID

Restrict delete

<--OSL_TYPEID_from_osl_typeID_fkey

arch_osl_DataCore.OSL_TYPEID

osl_typeID.OSL_TYPEID

Restrict delete

<--MINERALID_from_osl-tl_mineralID_fkey

arch_osl_DataCore.MINERALID

osl-tl_mineralID.MINERALID

Restrict delete

K_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_osl_DataCore.K_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--REFDBID(1)_from_global_RefCore_fkey

arch_osl_DataCore.REFDBID1

global_RefCore.REFDBID

Restrict delete

ALPH_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_osl_DataCore.ALPH_MTDID

osl-tl_mtdID.MTDID

Restrict delete

TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_osl_DataCore.TH_MTDID

osl-tl_mtdID.MTDID

Restrict delete

U_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_osl_DataCore.U_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--LAB_ORIGID_from_cabah_LabCodes_fkey

arch_osl_DataCore.LAB_ORIGID

cabah_LabCodes.LAB_ORIGID

Restrict delete

BETA_MTDID<--MTDID_from_osl-tl_mtdID_fkey

arch_osl_DataCore.BETA_MTDID

osl-tl_mtdID.MTDID

Restrict delete

<--LUM_MATID_from_osl-tl_lum_matID_fkey

arch_osl_DataCore.LUM_MATID

osl-tl_lum_matID.LUM_MATID

Restrict delete

<--REFDBID(2)_from_global_RefCore_fkey

arch_osl_DataCore.REFDBID2

global_RefCore.REFDBID

Restrict delete

<--REFDBID(4)_from_global_RefCore_fkey

arch_osl_DataCore.REFDBID4

global_RefCore.REFDBID

Restrict delete

<--AGEMODELID_from_osl-tl_agemodelID_fkey

arch_osl_DataCore.AGEMODELID

osl-tl_agemodelID.AGEMODELID

Restrict delete

<--DEPOSITID_from_cabah_depositID_fkey

cabah_AnalysisUnit.FACIESID

cabah_depositID.DEPOSITID

Restrict delete

<--NEO_UNITID_from_global_UnitMaster_fkey

cabah_AnalysisUnit.NEO_UNITID

global_UnitMaster.NEO_UNITID

Restrict delete

global_sitecode_fk

global_SiteCode.PARENTID

global_SiteCode.SITECODEID

Restrict delete

c14_calprogram_fk

c14_calprogram.PARENTID

c14_calprogram.CALPROGID

Restrict delete

<--REFDBID_from_global_RefCore_fkey

c14_calprogram.CALPROGREF

global_RefCore.REFDBID

Restrict delete

<--REFDBID_from_global_RefKeyword_fkey

global_RefCore.REFDBID

global_RefKeyword.REFDBID

Restrict delete

<--OAID_from_global_Author_fkey

global_RefCore.OAID

global_Author.OAID

Restrict delete

<--JOURNALID_from_global_Journal_fkey

global_RefCore.JOURNALID

global_Journal.JOURNALID

Restrict delete

<--PUBTYPEID_from_global_PubType_fkey

global_RefCore.PUBTYPEID

global_PubType.PUBTYPEID

Restrict delete

<--REFDBID_from_global_RefAbstract_fkey

global_RefCore.REFDBID

global_RefAbstract.REFDBID

Restrict delete

<-- REFDBID_from_global_RefCore_fkey

c14_calcurve.CALCURVREF

global_RefCore.REFDBID

Restrict delete

global_biomeid_fk

global_biomeID.PARENTID

global_biomeID.BIOMEID

Restrict delete

<--SITECODEID_from_global_SiteCode_fkey

global_MetaSite.FEATURETYP

global_SiteCode.SITECODEID

Restrict delete

<--DATASRCID_from_cabah_datasourceID_fkey

global_MetaSite.FEATURESRC

cabah_datasourceID.DATASRCID

Restrict delete

<--OBSID1_from_sed-tl_DataCore_fkey

sed-tl_points_EPSG3857.OBSID1

sed-tl_DataCore.OBSID1

Restrict delete

<--OBSID1_from_fos_DataCore_fkey

fos_polygons_EPSG3857.OBSID1

fos_DataCore.OBSID1

Restrict delete

<--DSETTYPEID_from_global_datasettypeID_fkey

global_DataSetMaster.DSETTYPEID

global_datasettypeID.DSETTYPEID

Restrict delete

<--UNITID_from_global_UnitMaster_fkey

global_DataSetMaster.UNITID

global_UnitMaster.UNITID

Restrict delete

<--DATASRCID_from_cabah_datasourceID_fkey

global_DataSetMaster.DSETSOURCE

cabah_datasourceID.DATASRCID

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
spatial_ref_sys	spatial_ref_sys_srid_check	(((srid > 0) AND (srid <= 998999)))