Constraints

88 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
DSSG_ibfk_1
DSSG.SPEC_ID
SPEC.SPEC_ID
Cascade on delete
OTHF_ibfk_1
OTHF.TEST_ID
TEST.TEST_ID
Cascade on delete
OTHR_ibfk_1
OTHR.SPEC_ID
SPEC.SPEC_ID
Cascade on delete
OTHR_ibfk_2
OTHR.FILE_ID
FILE.FILE_ID
Cascade on delete
GINV_ibfk_1
GINV.TEST_ID
TEST.TEST_ID
Cascade on delete
LAB_PROGRAM_ibfk_1
LAB_PROGRAM.LAB_ID
LAB.LAB_ID
Cascade on delete
PLAS_ibfk_1
PLAS.SPEC_ID
SPEC.SPEC_ID
Cascade on delete
ISPT_ibfk_1
ISPT.SAMP_ID
SAMP.SAMP_ID
Cascade on delete
DSSS_jbfk_1
DSSS.DSSG_ID
DSSG.DSSG_ID
Cascade on delete
DSSD1D_ibfk_1
DSSD1D.DSSS_ID
DSSS.DSSS_ID
Cascade on delete
TEPT_ibfk_1
TEPT.TEST_ID
TEST.TEST_ID
Cascade on delete
GSWD_ibfk_1
GSWD.GSWG_ID
GSWG.GSWG_ID
Cascade on delete
GSWG_ibfk_1
GSWG.TEST_ID
TEST.TEST_ID
Cascade on delete
SPEC_ibfk_1
SPEC.SAMP_ID
SAMP.SAMP_ID
Cascade on delete
SEGM_ibfk_1
SEGM.EVNT_ID
EVNT.EVNT_ID
Cascade on delete
SAMP_TEST_ibfk_2
SAMP_TEST.TEST_ID
TEST.TEST_ID
Cascade on delete
SAMP_TEST_ibfk_1
SAMP_TEST.SAMP_ID
SAMP.SAMP_ID
Cascade on delete
TESF_ibfk_2
TESF.FILE_ID
FILE.FILE_ID
Cascade on delete
TESF_ibfk_1
TESF.TEST_ID
TEST.TEST_ID
Cascade on delete
IM_ibfk_1
IM.EVNT_ID
EVNT.EVNT_ID
Cascade on delete
IM_ibfk_2
IM.STAT_ID
STAT.STAT_ID
Cascade on delete
DETL_ibfk_1
DETL.TEST_ID
TEST.TEST_ID
Cascade on delete
TESC_ibfk_2
TESC.TEST_ID
TEST.TEST_ID
Cascade on delete
TESC_ibfk_1
TESC.USER_ID
USER.USER_ID
Cascade on delete
TESP_ibfk_1
TESP.TEST_ID
TEST.TEST_ID
Cascade on delete
TESP_ibfk_2
TESP.CITATION_ID
CITATION.CITATION_ID
Cascade on delete
GMIM_ibfk_1
GMIM.FLDO_ID
FLDO.FLDO_ID
Cascade on delete
TESM_ibfk_2
TESM.TEST_ID
TEST.TEST_ID
Cascade on delete
TESM_ibfk_1
TESM.USER_ID
USER.USER_ID
Restrict delete
SWVG_ibfk_1
SWVG.GSWG_ID
GSWG.GSWG_ID
Cascade on delete
DSSD2D_ibfk_1
DSSD2D.DSSS_ID
DSSS.DSSS_ID
Cascade on delete
SWVD_ibfk_1
SWVD.SWVG_ID
SWVG.SWVG_ID
Cascade on delete
TEST_ibfk_1
TEST.SITE_ID
SITE.SITE_ID
Cascade on delete
TESR_ibfk_1
TESR.TEST_ID
TEST.TEST_ID
Cascade on delete
TESR_ibfk_2
TESR.USER_ID
USER.USER_ID
Cascade on delete
GIND_ibfk_1
GIND.GINV_ID
GINV.GINV_ID
Cascade on delete
CONG_ibfk_1
CONG.SPEC_ID
SPEC.SPEC_ID
Cascade on delete
COND_ibfk_1
COND.CON_STGE_ID
CON_STGE.CON_STGE_ID
Cascade on delete
LAB_PROGRAM_USER_ibfk_2
LAB_PROGRAM_USER.USER_ID
USER.USER_ID
Cascade on delete
LAB_PROGRAM_USER_ibfk_1
LAB_PROGRAM_USER.LAB_PROGRAM_ID
LAB_PROGRAM.LAB_PROGRAM_ID
Restrict delete
CRET_ibfk_1
CRET.TESM_ID
TESM.TESM_ID
Cascade on delete
SAMF_ibfk_1
SAMF.SAMP_ID
SAMP.SAMP_ID
Cascade on delete
SAMF_ibfk_2
SAMF.FILE_ID
FILE.FILE_ID
Cascade on delete
TXD_ibfk_1
TXD.TXS_ID
TXS.TXS_ID
Cascade on delete
CRES_ibfk_1
CRES.SITM_ID
SITM.SITM_ID
Cascade on delete
TXG_ibfk_1
TXG.SPEC_ID
SPEC.SPEC_ID
Cascade on delete
CREO_ibfk_1
CREO.OBSM_ID
OBSM.OBSM_ID
Cascade on delete
OBSC_ibfk_2
OBSC.FLDO_ID
FLDO.FLDO_ID
Cascade on delete
OBSC_ibfk_1
OBSC.USER_ID
USER.USER_ID
Cascade on delete
OBSM_ibfk_2
OBSM.FLDO_ID
FLDO.FLDO_ID
Cascade on delete
OBSM_ibfk_1
OBSM.USER_ID
USER.USER_ID
Cascade on delete
CON_STGE_ibfk_1
CON_STGE.CONG_ID
CONG.CONG_ID
Cascade on delete
TXS_ibfk_1
TXS.TXG_ID
TXG.TXG_ID
Cascade on delete
PERM_ibfk_1
PERM.USER_ID
USER.USER_ID
Cascade on delete
OBSR_ibfk_2
OBSR.USER_ID
USER.USER_ID
Cascade on delete
OBSR_ibfk_1
OBSR.FLDO_ID
FLDO.FLDO_ID
Cascade on delete
INDX_ibfk_1
INDX.SPEC_ID
SPEC.SPEC_ID
Cascade on delete
BORH_ibfk_1
BORH.TEST_ID
TEST.TEST_ID
Cascade on delete
FILE_EXT_ibfk_1
FILE_EXT.CITATION_ID
CITATION.CITATION_ID
Cascade on delete
WATR_ibfk_1
WATR.TEST_ID
TEST.TEST_ID
Cascade on delete
SCPG_ibfk_1
SCPG.TEST_ID
TEST.TEST_ID
Cascade on delete
LAB_PROGRAMP_ibfk_2
LAB_PROGRAMP.CITATION_ID
CITATION.CITATION_ID
Restrict delete
LAB_PROGRAMP_ibfk_1
LAB_PROGRAMP.LAB_PROGRAM_ID
LAB_PROGRAM.LAB_PROGRAM_ID
Restrict delete
SITC_ibfk_2
SITC.SITE_ID
SITE.SITE_ID
Cascade on delete
SITC_ibfk_1
SITC.USER_ID
USER.USER_ID
Cascade on delete
FLDD_ibfk_1
FLDD.FLDO_ID
FLDO.FLDO_ID
Cascade on delete
FLDF_ibfk_2
FLDF.FILE_ID
FILE.FILE_ID
Cascade on delete
FLDF_ibfk_1
FLDF.FLDO_ID
FLDO.FLDO_ID
Cascade on delete
LAB_PROGRAM_SAMP_ibfk_2
LAB_PROGRAM_SAMP.SAMP_ID
SAMP.SAMP_ID
Cascade on delete
LAB_PROGRAM_SAMP_ibfk_1
LAB_PROGRAM_SAMP.LAB_PROGRAM_ID
LAB_PROGRAM.LAB_PROGRAM_ID
Cascade on delete
SITM_ibfk_1
SITM.USER_ID
USER.USER_ID
Restrict delete
LAB_ibfk_1
LAB.USER_ID
USER.USER_ID
Restrict delete
SITF_ibfk_1
SITF.SITE_ID
SITE.SITE_ID
Cascade on delete
SITF_ibfk_2
SITF.FILE_ID
FILE.FILE_ID
Cascade on delete
FLDM_ibfk_1
FLDM.FLDO_ID
FLDO.FLDO_ID
Cascade on delete
GRAG_ibfk_1
GRAG.SPEC_ID
SPEC.SPEC_ID
Cascade on delete
FLDO_ibfk_2
FLDO.SITE_ID
SITE.SITE_ID
Cascade on delete
FLDO_ibfk_1
FLDO.EVNT_ID
EVNT.EVNT_ID
Cascade on delete
FLDP_ibfk_2
FLDP.CITATION_ID
CITATION.CITATION_ID
Cascade on delete
FLDP_ibfk_1
FLDP.FLDO_ID
FLDO.FLDO_ID
Cascade on delete
SCPT_ibfk_1
SCPT.SCPG_ID
SCPG.SCPG_ID
Cascade on delete
SITR_ibfk_1
SITR.SITE_ID
SITE.SITE_ID
Cascade on delete
SITR_ibfk_2
SITR.USER_ID
USER.USER_ID
Cascade on delete
SITP_ibfk_2
SITP.CITATION_ID
CITATION.CITATION_ID
Cascade on delete
SITP_ibfk_1
SITP.SITE_ID
SITE.SITE_ID
Cascade on delete
STRA_ibfk_1
STRA.TEST_ID
TEST.TEST_ID
Cascade on delete
RDEN_ibfk_1
RDEN.SPEC_ID
SPEC.SPEC_ID
Cascade on delete
GRAT_ibfk_1
GRAT.GRAG_ID
GRAG.GRAG_ID
Cascade on delete

Check Constraints

Table Constraint Name Constraint