492 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||
|---|---|---|---|---|---|---|---|
| FK_KIT_SPECIMENS_SPECIMEN_ID |
|
|
Restrict delete | ||||
| FK_KIT_SPECIMENS_KIT_ID |
|
|
Restrict delete | ||||
| FK_CART_FOLDER_OWNER |
|
|
Restrict delete | ||||
| FK_CFG_SETTINGS_PROP_ID |
|
|
Restrict delete | ||||
| FK_CFG_SETTINGS_ACTIVATED_BY |
|
|
Restrict delete | ||||
| FK_DPR_SPECIMEN_TYPE |
|
|
Restrict delete | ||||
| FK_DPR_ANATOMIC_SITE |
|
|
Restrict delete | ||||
| FK_DPR_CLINICAL_DIAGNOSIS |
|
|
Restrict delete | ||||
| FK_OS_DP_REQ_DP_ID |
|
|
Restrict delete | ||||
| FK_SPEC_PROCEDURE_EVENT |
|
|
Restrict delete | ||||
| FK_USER_PROC_EVENT |
|
|
Restrict delete | ||||
| FK_LBL_PRN_JITEMS_JID |
|
|
Restrict delete | ||||
| FK_OS_SPMN_DEPS_LIST |
|
|
Restrict delete | ||||
| FK_OS_SPMN_DEPS_CP |
|
|
Restrict delete | ||||
| FK84DE7ECC2ABD7347 |
|
|
Restrict delete | ||||
| FK84DE7ECC4502E901 |
|
|
Restrict delete | ||||
| FK84DE7ECCCAF26781 |
|
|
Restrict delete | ||||
| FK84DE7ECCB0ACF1C7 |
|
|
Restrict delete | ||||
| FK_OS_SR_DP_ID |
|
|
Restrict delete | ||||
| FK_SPMN_REQS_SCREENER |
|
|
Restrict delete | ||||
| FK_OS_SPMN_REQS_CP_ID |
|
|
Restrict delete | ||||
| FK_OS_SPMN_REQS_REQUESTOR |
|
|
Restrict delete | ||||
| FK_OS_SPMN_REQS_PROCESSOR |
|
|
Restrict delete | ||||
| FK_SPMN_RECV_QUALITY |
|
|
Restrict delete | ||||
| FK_USER_REC_EVENT |
|
|
Restrict delete | ||||
| FK_OS_STORE_CONT_CDPS_DP_ID |
|
|
Restrict delete | ||||
| FK_OS_STORE_CONT_CDPS_CONT_ID |
|
|
Restrict delete | ||||
| FK_DB_PARAMS_DASH_ID |
|
|
Restrict delete | ||||
| FK_SPMN_COLL_PROC |
|
|
Restrict delete | ||||
| FK_SPMN_COLL_CONT |
|
|
Restrict delete | ||||
| FK_USER_COLL_EVENT |
|
|
Restrict delete | ||||
| SPECIMEN_TYPE_ST_ID_FK |
|
|
Restrict delete | ||||
| OS_FK_SHIP_RECEIVER_ID |
|
|
Restrict delete | ||||
| OS_FK_SHIP_RECV_SITE_ID |
|
|
Restrict delete | ||||
| OS_FK_SHIP_SENDER_ID |
|
|
Restrict delete | ||||
| FK_OS_SHIPMENTS_REQ_ID |
|
|
Restrict delete | ||||
| OS_FK_SHIP_SENDING_SITE_ID |
|
|
Restrict delete | ||||
| FK_UNHANDLED_EXCEPTION_USER_ID |
|
|
Restrict delete | ||||
| FK703B9021B3DFB11D |
|
|
Restrict delete | ||||
| catissue_specimen_hierarchy_ibfk_2 |
|
|
Restrict delete | ||||
| catissue_specimen_hierarchy_ibfk_1 |
|
|
Restrict delete | ||||
| FK_OS_UOTP_USER_ID |
|
|
Restrict delete | ||||
| FK_OS_CONT_HIERARCHY_AID |
|
|
Restrict delete | ||||
| FK_OS_CONT_HIERARCHY_DID |
|
|
Restrict delete | ||||
| FK_RECEIVER_CP_REQ_SPECIMEN |
|
|
Restrict delete | ||||
| FK_PARENT_CP_REQ_SPECIMEN |
|
|
Restrict delete | ||||
| FK_SPMN_REQ_LATERALITY |
|
|
Restrict delete | ||||
| FK_POOLED_SPMN_REQ |
|
|
Restrict delete | ||||
| FK111110456906F39 |
|
|
Restrict delete | ||||
| FK_SPMN_REQ_PATH_STATUS |
|
|
Restrict delete | ||||
| FK_SPMN_REQ_COLL_PROC |
|
|
Restrict delete | ||||
| FK_SPMN_REQ_CLASS |
|
|
Restrict delete | ||||
| FK_SPMN_REQ_ANATOMIC_SITE |
|
|
Restrict delete | ||||
| FK_COLLECTOR_CP_REQ_SPECIMEN |
|
|
Restrict delete | ||||
| FK_SPMN_REQ_TYPE |
|
|
Restrict delete | ||||
| FK_SPMN_REQ_COLL_CONT |
|
|
Restrict delete | ||||
| FK_DEPS_PARENT_QUERY |
|
|
Restrict delete | ||||
| FK_DEPS_CHILD_QUERY |
|
|
Restrict delete | ||||
| FK_PUBLISHED_EVENT_CP_ID |
|
|
Restrict delete | ||||
| FK_PUBLISHED_EVENT_VERSION |
|
|
Restrict delete | ||||
| FK_PUBLISHED_EVENT_USER |
|
|
Restrict delete | ||||
| FK_SPE_FROZEN_METHOD |
|
|
Restrict delete | ||||
| FK_USER_FROZEN_EVENT |
|
|
Restrict delete | ||||
| FK_SPEC_FROZEN_EVENT |
|
|
Restrict delete | ||||
| FK_CART_FOLDER_UG_FOLDER |
|
|
Restrict delete | ||||
| FK_CART_FOLDER_UG_GROUP |
|
|
Restrict delete | ||||
| FK_EXPORT_JOBS_USER |
|
|
Restrict delete | ||||
| FK3C12AE3B3EEC14E3 |
|
|
Restrict delete | ||||
| FK3C12AE3B2206F20F |
|
|
Restrict delete | ||||
| FK_SPEC_CELL_REV_EVENT |
|
|
Restrict delete | ||||
| FK_USER_CELL_EVENT |
|
|
Restrict delete | ||||
| FK_OS_PARENT_ROLE |
|
|
Restrict delete | ||||
| FK_TISSUE_REQ_SPECIMEN |
|
|
Restrict delete | ||||
| FK_API_CALL_LOG_AUDIT_LOG_ID |
|
|
Restrict delete | ||||
| FK_OS_USER_API_LOG_USER_ID |
|
|
Restrict delete | ||||
| FK_CALL_LOG_IMP_USER_ID |
|
|
Restrict delete | ||||
| FK1483BCB56B1F36E7 |
|
|
Restrict delete | ||||
| FK1483BCB548304401 |
|
|
Restrict delete | ||||
| FK_h1dxr1mk3lbojld9cpgcjos2e |
|
|
Restrict delete | ||||
| FK_itwt8wch7fujeieknvgju804w |
|
|
Restrict delete | ||||
| FK_CAT_CSR_CPID_CAT_CP_ID |
|
|
Restrict delete | ||||
| FK_CAT_CSR_SITEID_CAT_SITE_ID |
|
|
Restrict delete | ||||
| FK_CPG_FORM_NOTIF_FORM |
|
|
Restrict delete | ||||
| FK_CPG_FORM_NOTIF_USER_GROUP |
|
|
Restrict delete | ||||
| FK_dyoqily0s2m061bxvxik0wou5 |
|
|
Restrict delete | ||||
| FK_EXPORT_JOBS_PARAMS_JOB_ID |
|
|
Restrict delete | ||||
| FK_PERM_OPERATION_ID |
|
|
Restrict delete | ||||
| FK_PERM_RESOURCE_ID |
|
|
Restrict delete | ||||
| FK_SHARED_SPECLIST_USER_ID |
|
|
Restrict delete | ||||
| FK_SHARESPECIMENLIST_USER_ID |
|
|
Restrict delete | ||||
| FK_SPEC_BIOHAZARD_AUD_REV |
|
|
Restrict delete | ||||
| FK_8qr9yjmig276s5njj5q9s5kvm |
|
|
Restrict delete | ||||
| FK_STORE_LIST_USER_ID |
|
|
Restrict delete | ||||
| FK_STORE_LIST_CONTAINER_ID |
|
|
Restrict delete | ||||
| OS_FK_CP_ALLOWED_DPS_CP_ID |
|
|
Restrict delete | ||||
| OS_FK_CP_ALLOWED_DPS_DP_ID |
|
|
Restrict delete | ||||
| CAT_QF_OWNER_CAT_USR_ID |
|
|
Restrict delete | ||||
| FK_CFG_PROP_ALLOWED_VALS_PID |
|
|
Restrict delete | ||||
| CAT_QFSS_FOLDER_ID_CAT_QF_ID |
|
|
Restrict delete | ||||
| CAT_QFSS_USER_ID_CAT_USR_ID |
|
|
Restrict delete | ||||
| FK_OS_DIST_INVOICES_ORD_ID |
|
|
Restrict delete | ||||
| FK_STORE_LIST_ITEM_STORE_LIST |
|
|
Restrict delete | ||||
| FK_STORE_LIST_ITEM_SPMN_ID |
|
|
Restrict delete | ||||
| FK_ctda38ykfjtwuljy7pb6y753d |
|
|
Restrict delete | ||||
| FK4597C9F1BC7298A9 |
|
|
Restrict delete | ||||
| FK4597C9F191092806 |
|
|
Restrict delete | ||||
| FK_NOTIF_USERS_USER_ID |
|
|
Restrict delete | ||||
| FK_NOTIF_USERS_NOTIF_ID |
|
|
Restrict delete | ||||
| FK_PDE_NOTIF_USER_ID |
|
|
Restrict delete | ||||
| FK_PDE_NOTIF_CPR_ID |
|
|
Restrict delete | ||||
| FK_OS_STG_PMIS_PID |
|
|
Restrict delete | ||||
| FK_AUTH_TOKENS_LA_LOG_ID |
|
|
Restrict delete | ||||
| FK_AUTH_TOKENS_USER_ID |
|
|
Restrict delete | ||||
| FK51725303E36A4B4F |
|
|
Restrict delete | ||||
| FK_CP_CONSENT_TIERS_CONSENT_ID |
|
|
Restrict delete | ||||
| FK_DOMAIN_PROVIDER_FK |
|
|
Restrict delete | ||||
| FK_9xhryw88q1uv2s2oxcn53rsdh |
|
|
Restrict delete | ||||
| FK_isb8mltbk8qaa3q4epkoy9ell |
|
|
Restrict delete | ||||
| FK_OS_CP_WORKFLOWS_CP_ID |
|
|
Restrict delete | ||||
| FK_DPR_PATH_STATUS |
|
|
Restrict delete | ||||
| OS_FK_DPR_PATH_DPR_ID |
|
|
Restrict delete | ||||
| FK_SPECLIST_USER_ID |
|
|
Restrict delete | ||||
| FK_PRINT_RULE_INST_ID |
|
|
Restrict delete | ||||
| FK_PRINT_RULE_UPDATED_BY |
|
|
Restrict delete | ||||
| FK_FC_CNTR_ID_DC_IDENTIFIER |
|
|
Restrict delete | ||||
| FK_USER_GROUP_INSTITUTE |
|
|
Restrict delete | ||||
| FK_PASSWORD_UPDATED_BY |
|
|
Restrict delete | ||||
| FKDE1F38972206F20F |
|
|
Restrict delete | ||||
| FK_OS_CORE_RECS_SLIDE_EVENT |
|
|
Restrict delete | ||||
| FK_REV_ENTITY |
|
|
Restrict delete | ||||
| FK_USER_SPUN_EVENT |
|
|
Restrict delete | ||||
| FK_SPEC_SPUN_EVENT |
|
|
Restrict delete | ||||
| FK753F33AD8CA560D1 |
|
|
Restrict delete | ||||
| FK753F33AD2206F20F |
|
|
Restrict delete | ||||
| FK_STG_PART_RACE_ID |
|
|
Restrict delete | ||||
| FK_OS_STG_RACES_PID |
|
|
Restrict delete | ||||
| FK_OS_STORE_CONT_DPS_AUD_REV |
|
|
Restrict delete | ||||
| FK2 |
|
|
Restrict delete | ||||
| FK1 |
|
|
Restrict delete | ||||
| FK_FDE_TOKENS_FORM_CTXT_ID |
|
|
Restrict delete | ||||
| FK_FDE_TK_CREATOR |
|
|
Restrict delete | ||||
| FK_USER_DISTRI_EVENT |
|
|
Restrict delete | ||||
| FK_SPEC_DISTRI_EVENT |
|
|
Restrict delete | ||||
| fk_distribution_protocol |
|
|
Restrict delete | ||||
| FK_NOTIFICATION_CREATED_BY |
|
|
Restrict delete | ||||
| FK_JOB_PARAMS_JOB_ID |
|
|
Restrict delete | ||||
| FK_EXT_IDS_SPMN_ID |
|
|
Restrict delete | ||||
| FKCDD0DF7BBC7298A9 |
|
|
Restrict delete | ||||
| FKCDD0DF7B91741663 |
|
|
Restrict delete | ||||
| FK_SPMN_BIOHAZARD |
|
|
Restrict delete | ||||
| FK_OS_BIOHZ_SPECIMEN_ID |
|
|
Restrict delete | ||||
| FK_CD_COLPROT |
|
|
Restrict delete | ||||
| OS_DEVICE_USER_ID |
|
|
Restrict delete | ||||
| FK_FORM_NOTIF_USER_GRP |
|
|
Restrict delete | ||||
| FK_FORM_NOTIF_CTXT |
|
|
Restrict delete | ||||
| FK_PDE_NOTIF_LINKS_NOTIF_ID |
|
|
Restrict delete | ||||
| FK_SHARED_QUERY_USER_ID |
|
|
Restrict delete | ||||
| FK_SHAREQUERY_USER_ID |
|
|
Restrict delete | ||||
| CAT_QFQ_FOLDER_ID_CAT_QF_ID |
|
|
Restrict delete | ||||
| CAT_QFQ_QUERY_ID_CAT_SQ_ID |
|
|
Restrict delete | ||||
| FK_FG_TOKENS_USER_ID |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_CSC_CONT_ID |
|
|
Restrict delete | ||||
| FK_CONT_COMP_SPMN_CLASS |
|
|
Restrict delete | ||||
| FK_CART_FOLDER_CARTS_CART |
|
|
Restrict delete | ||||
| FK_CART_FOLDER_CARTS_FOLDER |
|
|
Restrict delete | ||||
| FK_SPEC_THAW_EVENT |
|
|
Restrict delete | ||||
| FK_USER_THAW_EVENT |
|
|
Restrict delete | ||||
| FK_4rwywid6his5vawygbbok91h7 |
|
|
Restrict delete | ||||
| FK_SITE_CP_SITE_ID |
|
|
Restrict delete | ||||
| FK_SITE_CP_COLL_PROT_ID |
|
|
Restrict delete | ||||
| FK_cx3wxvecf9prg0ulwaw3bwb2s |
|
|
Restrict delete | ||||
| FK_w3jps5e5byvocjpg18nuyffy |
|
|
Restrict delete | ||||
| FK5CF2FA2160773DB2 |
|
|
Restrict delete | ||||
| FK_VISIT_CLINICAL_DIAGNOSIS |
|
|
Restrict delete | ||||
| FK_OS_VISIT_CDS_VISIT_ID |
|
|
Restrict delete | ||||
| FK_RE_UPDATED_BY_USERS_ID |
|
|
Restrict delete | ||||
| FK_RE_CTXT_ID_FC_IDENTIFIER |
|
|
Restrict delete | ||||
| FK_PART_VITAL_STATUS |
|
|
Restrict delete | ||||
| FK_PART_GENDER |
|
|
Restrict delete | ||||
| FK_QFOLDER_SHR_GRP_GRP_ID |
|
|
Restrict delete | ||||
| FK_QFOLDER_SHR_GRP_FOLDER_ID |
|
|
Restrict delete | ||||
| FK_OS_ACL_RESOURCE |
|
|
Restrict delete | ||||
| FK_OS_ACL_ROLE |
|
|
Restrict delete | ||||
| FK_DATA_BACKUP_USER_ID |
|
|
Restrict delete | ||||
| FK_CONT_TRAF_EVT_FROM_SITE |
|
|
Restrict delete | ||||
| FK_CONT_TRAF_EVT_USER |
|
|
Restrict delete | ||||
| FK_CONT_TRAF_EVT_FROM_CONT |
|
|
Restrict delete | ||||
| FK_CONT_TRAF_EVT_TO_SITE |
|
|
Restrict delete | ||||
| FK_CONT_TRAF_EVT_CONTAINER |
|
|
Restrict delete | ||||
| FK_CONT_TRAF_EVT_TO_CONT |
|
|
Restrict delete | ||||
| FKFB1995FD4AD77FCB |
|
|
Restrict delete | ||||
| FK_CONSENT_RESP |
|
|
Restrict delete | ||||
| FKFB1995FD17B9953 |
|
|
Restrict delete | ||||
| FK_OS_ACLO_ACL |
|
|
Restrict delete | ||||
| FK_OS_ACLO_OPERATION |
|
|
Restrict delete | ||||
| FK_r51pe9nboapngjjh34hbm3i2s |
|
|
Restrict delete | ||||
| FK_CATALOGS_REQ_FORM_ID |
|
|
Restrict delete | ||||
| FK_CATALOGS_UPDATED_USR_ID |
|
|
Restrict delete | ||||
| FK_CATALOGS_REQ_QUERY_ID |
|
|
Restrict delete | ||||
| FK_CATALOGS_QUERY_ID |
|
|
Restrict delete | ||||
| FK_PART_RACE_ID |
|
|
Restrict delete | ||||
| FKB0242ECD87E5ADC7 |
|
|
Restrict delete | ||||
| FK_GRP_FORMS_FORM_ID |
|
|
Restrict delete | ||||
| FK_GRP_FORMS_GROUP_ID |
|
|
Restrict delete | ||||
| FK_8bytnb90kr6dd9hr194p9ei57 |
|
|
Restrict delete | ||||
| FK_PUBLISHED_CP_EVENT |
|
|
Restrict delete | ||||
| FK_PUBLISHED_CP_REVIEWER |
|
|
Restrict delete | ||||
| FK_AP_PROPS_AP_ID |
|
|
Restrict delete | ||||
| FK_OS_SCHEDULED_JOB_SU_JOB |
|
|
Restrict delete | ||||
| FK_OS_SCHEDULED_JOB_SU_USR |
|
|
Restrict delete | ||||
| FK_CP_GROUP_CP_ID |
|
|
Restrict delete | ||||
| FK_CP_GROUP_ID |
|
|
Restrict delete | ||||
| FK_CP_RPT_RCPTS_RPT_ID |
|
|
Restrict delete | ||||
| FK_CP_RPT_RCPTS_USR_ID |
|
|
Restrict delete | ||||
| FK_CAT_CC_CPID_CAT_CP_ID |
|
|
Restrict delete | ||||
| FK_STAGED_VISITS_DIAG |
|
|
Restrict delete | ||||
| FK_LBL_PRN_JOBS_SUBM_ID |
|
|
Restrict delete | ||||
| FK_QAUDIT_LOG_QID_QUERIES_ID |
|
|
Restrict delete | ||||
| FK_QAUDIT_LOG_RUN_BY_USERS_ID |
|
|
Restrict delete | ||||
| FK_SCHED_RUN_USER_ID |
|
|
Restrict delete | ||||
| FK_OS_SCHEDULED_JOB_CREATED_BY |
|
|
Restrict delete | ||||
| FK_SCHED_QUERY_ID |
|
|
Restrict delete | ||||
| FK6A2246DC91741663 |
|
|
Restrict delete | ||||
| FK6A2246DC752DD177 |
|
|
Restrict delete | ||||
| FK6A2246DCBC7298A9 |
|
|
Restrict delete | ||||
| FK_OS_DEPT_INSTITUTE_ID |
|
|
Restrict delete | ||||
| FK_7crokk0uhxa3aqqh626nasp9q |
|
|
Restrict delete | ||||
| FK7A3F5539F398D480 |
|
|
Restrict delete | ||||
| FK7A3F553960773DB2 |
|
|
Restrict delete | ||||
| FK_fhlbe4ciavool7n6hrydsxm0a |
|
|
Restrict delete | ||||
| FK_TAGITEM_TAG_ID |
|
|
Restrict delete | ||||
| FK_DP_SITES_INSTITUTE_ID |
|
|
Restrict delete | ||||
| FK_DP_SITES_DP_ID |
|
|
Restrict delete | ||||
| FK_DP_SITES_SITE_ID |
|
|
Restrict delete | ||||
| FK_SPMN_KIT_RECEIVING_SITE_ID |
|
|
Restrict delete | ||||
| FK_SPMN_KIT_SENDING_SITE_ID |
|
|
Restrict delete | ||||
| FK_SPMN_KIT_CP_ID |
|
|
Restrict delete | ||||
| FK_SPMN_KIT_SENDER_ID |
|
|
Restrict delete | ||||
| FK_CONT_SPMN_CLASS |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_SC_CONT_ID |
|
|
Restrict delete | ||||
| FK_PDE_AUDIT_LOG_USER |
|
|
Restrict delete | ||||
| FK_CONT_SPMN_TYPE |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_ST_CONT_ID |
|
|
Restrict delete | ||||
| FK_CHILD_SPMN_EVENTS_USER_ID |
|
|
Restrict delete | ||||
| FK_CHILD_SPMN_EVENTS_SPMN_ID |
|
|
Restrict delete | ||||
| FK_CATALOG_USER_GROUP_ID |
|
|
Restrict delete | ||||
| FK_USER_GROUPS_CATALOG_ID |
|
|
Restrict delete | ||||
| FK_SCHED_CONT_ACT_USER_ID |
|
|
Restrict delete | ||||
| FK_SCHED_CONT_ACT_USERS_ACT_ID |
|
|
Restrict delete | ||||
| FK_SPEC_DISPOSAL_EVENT |
|
|
Restrict delete | ||||
| FK_USER_DISP_EVENT |
|
|
Restrict delete | ||||
| FK_OS_SPMN_ARRAY_CORES_ARRAY |
|
|
Restrict delete | ||||
| FK_OS_SPMN_ARRAY_CORES_SPMN |
|
|
Restrict delete | ||||
| FK_OCCUPIED_CONTAINER |
|
|
Restrict delete | ||||
| FK_CONTAINER_POSITION |
|
|
Restrict delete | ||||
| FK_CONTAINER |
|
|
Restrict delete | ||||
| FK_7nmb9yn4uq0fojtbh2nl7stv2 |
|
|
Restrict delete | ||||
| FK_OS_DIST_INV_ITEMS_INV_ID |
|
|
Restrict delete | ||||
| FK_OS_DIST_INV_ITEMS_SVC_ID |
|
|
Restrict delete | ||||
| OS_FK_SHIP_NOTIFY_SHIP_ID |
|
|
Restrict delete | ||||
| OS_FK_SHIP_NOTIFY_USER_ID |
|
|
Restrict delete | ||||
| FK_DB_CMD_SESSION |
|
|
Restrict delete | ||||
| FK_pkjkhvgsgjkgpwjrg65viug05 |
|
|
Restrict delete | ||||
| FK_OS_SPMN_ARR_EVENT_USER |
|
|
Restrict delete | ||||
| FK_OS_SPMN_ARR_EVENT_FORM_CTX |
|
|
Restrict delete | ||||
| FK_OS_SPMN_ARR_EVENT_CREATOR |
|
|
Restrict delete | ||||
| FK_OS_SPMN_ARR_EVENT_ARR_ID |
|
|
Restrict delete | ||||
| FK_OS_CP_CAT_SETTINGS_CREATOR |
|
|
Restrict delete | ||||
| FK_OS_CP_CAT_SETTINGS_UPDATER |
|
|
Restrict delete | ||||
| FK_OS_CP_CAT_SETTINGS_QUERY |
|
|
Restrict delete | ||||
| FK_OS_CP_CAT_SETTINGS_CP_ID |
|
|
Restrict delete | ||||
| FK_ARRAY_QUALITY_CTRL |
|
|
Restrict delete | ||||
| FK_OS_SPMN_ARRAY_VERIFIER |
|
|
Restrict delete | ||||
| FK_OS_SPMN_ARRAY_CREATOR |
|
|
Restrict delete | ||||
| FK_DP_CONSENT_STMTS_DP_ID |
|
|
Restrict delete | ||||
| FK_DP_CONSENT_TIERS_CONSENT_ID |
|
|
Restrict delete | ||||
| FK_OS_PART_ETHNICITY_PART_ID |
|
|
Restrict delete | ||||
| FK_PART_ETHNICITY_ID |
|
|
Restrict delete | ||||
| FK_CP_RPT_SETTINGS_QUERY_ID |
|
|
Restrict delete | ||||
| FK_CP_RPT_SETTINGS_CP_ID |
|
|
Restrict delete | ||||
| FK_SITE_ID_BY_CAT_SITE_ID |
|
|
Restrict delete | ||||
| FK_USER_ID_BY_CAT_USER_ID |
|
|
Restrict delete | ||||
| FK_UI_STATE_USER |
|
|
Restrict delete | ||||
| FK_LOGIN_AUDIT_LOGS_USER_ID |
|
|
Restrict delete | ||||
| FK_hmdofymkui8jf2mhk2a4ub8qm |
|
|
Restrict delete | ||||
| FKE7F5E8C2B3DFB11D |
|
|
Restrict delete | ||||
| FK_OS_SPMN_SLD_EVENT_FORM_CTX |
|
|
Restrict delete | ||||
| FK_OS_SPMN_SLD_EVENT_SLD_ID |
|
|
Restrict delete | ||||
| FK_OS_SPMN_SLD_EVENT_USER |
|
|
Restrict delete | ||||
| FK_OS_SPMN_SLD_EVENT_CREATOR |
|
|
Restrict delete | ||||
| FK_OS_DASHBOARD_USER_ID |
|
|
Restrict delete | ||||
| FK_STG_PART_ETHNICITY_ID |
|
|
Restrict delete | ||||
| FK_OS_STG_ETHNICITIES_PID |
|
|
Restrict delete | ||||
| FK_OS_STORE_CONT_DP_DP_ID |
|
|
Restrict delete | ||||
| FK_OS_STORE_CONT_DP_CONT_ID |
|
|
Restrict delete | ||||
| FK32DC439DBC7298B9 |
|
|
Restrict delete | ||||
| FK_OS_SPMN_SLIDE_CORES_CID |
|
|
Restrict delete | ||||
| FK_OS_SPMN_SLIDE_CORES_SID |
|
|
Restrict delete | ||||
| FK28429D01A7F77D13 |
|
|
Restrict delete | ||||
| FK28429D01BC7298A9 |
|
|
Restrict delete | ||||
| FK_POOLED_EVENT_USER |
|
|
Restrict delete | ||||
| FK_POOLED_EVENT_SPMN_ID |
|
|
Restrict delete | ||||
| FK_OS_CORE_RECS_ARRAY_EVENT |
|
|
Restrict delete | ||||
| FK_SPMN_EXT_IDS_AUD_REV |
|
|
Restrict delete | ||||
| FK_OS_POS_ST_CONTS_OCPID |
|
|
Restrict delete | ||||
| FK_OS_POS_ST_CONTS_CONT_ID |
|
|
Restrict delete | ||||
| FK_OS_POS_ST_CONTS_OSPID |
|
|
Restrict delete | ||||
| FK_REQ_MGRS_CATALOG_ID |
|
|
Restrict delete | ||||
| FK_REQ_MGRS_USER_ID |
|
|
Restrict delete | ||||
| FK_STG_PART_GENDER |
|
|
Restrict delete | ||||
| FK_STG_PART_VITAL_STATUS |
|
|
Restrict delete | ||||
| FK_DELETE_EVENT_USER_ID |
|
|
Restrict delete | ||||
| FK_DELETE_EVENT_SPMN_ID |
|
|
Restrict delete | ||||
| FK_SHIP_CONT_RECV_QLTY |
|
|
Restrict delete | ||||
| OS_SHIP_CONT_SHIP_FK |
|
|
Restrict delete | ||||
| OS_SHIP_CONT_CONT_FK |
|
|
Restrict delete | ||||
| FK214246228CA560D1 |
|
|
Restrict delete | ||||
| FK_SPEC_TISSUE_REV_EVENT |
|
|
Restrict delete | ||||
| FK_USER_TISSUE_EVENT |
|
|
Restrict delete | ||||
| FK_SPE_HIST_QUALITY |
|
|
Restrict delete | ||||
| FK_CAT_US_SITEID_CAT_SITE_ID |
|
|
Restrict delete | ||||
| FK_CAT_US_USERID_CAT_USER_ID |
|
|
Restrict delete | ||||
| FK_DB_SESSION_USER |
|
|
Restrict delete | ||||
| FK349E77F987E5ADC7 |
|
|
Restrict delete | ||||
| FK349E77F9A7F77D13 |
|
|
Restrict delete | ||||
| FK_CT_SITE_INSTITUTE_ID |
|
|
Restrict delete | ||||
| FKB024C3432206F20F |
|
|
Restrict delete | ||||
| FK_SITE_TYPE |
|
|
Restrict delete | ||||
| FK_SITE_CONT_ID |
|
|
Restrict delete | ||||
| FK3AE9FCA7B3DFB11D |
|
|
Restrict delete | ||||
| FK3AE9FCA748304401 |
|
|
Restrict delete | ||||
| FK_CONT_TRAF_SPMN_ID |
|
|
Restrict delete | ||||
| FK_CONT_TRAF_SPMN_EVT_ID |
|
|
Restrict delete | ||||
| FK_PART_ANON_EVENT_CPR_ID |
|
|
Restrict delete | ||||
| FK_PART_ANON_EVENT_USER_ID |
|
|
Restrict delete | ||||
| FK_GRP_USERS_GRP_ID |
|
|
Restrict delete | ||||
| FK_GRP_USERS_USR_ID |
|
|
Restrict delete | ||||
| FK_SPMN_ANATOMIC_SITE |
|
|
Restrict delete | ||||
| FK_SPECIMEN_POOLED_EVENT_ID |
|
|
Restrict delete | ||||
| FK1674810433BF33C5 |
|
|
Restrict delete | ||||
| FK_REQ_SPECIMEN_ID |
|
|
Restrict delete | ||||
| FK_PARENT_SPMN_EVENT_ID |
|
|
Restrict delete | ||||
| FK_SPMN_CLASS |
|
|
Restrict delete | ||||
| FK_POOLED_SPECIMEN_ID |
|
|
Restrict delete | ||||
| FK_PARENT_SPECIMEN |
|
|
Restrict delete | ||||
| FK_SPEC_CP_ID |
|
|
Restrict delete | ||||
| FK_SPMN_LATERALITY |
|
|
Restrict delete | ||||
| FK_SPMN_PATH_STATUS |
|
|
Restrict delete | ||||
| FK_SPMN_RESERVE_EVENT_ID |
|
|
Restrict delete | ||||
| FK_SPMN_TYPE |
|
|
Restrict delete | ||||
| FK_USER_FLUID_EVENT |
|
|
Restrict delete | ||||
| FK_SPEC_FLUID_REV_EVENT |
|
|
Restrict delete | ||||
| FK_USER_EMB_EVENT |
|
|
Restrict delete | ||||
| FK_SPE_EMBEDDING_MEDIUM |
|
|
Restrict delete | ||||
| FK_SPEC_EMBEDDED_EVENT |
|
|
Restrict delete | ||||
| FK_OS_CP_SPMN_PRINT_SETTINGS |
|
|
Restrict delete | ||||
| FK_SAVED_QUERIES_UPDATED_BY |
|
|
Restrict delete | ||||
| FK_SAVED_QUERY_CP |
|
|
Restrict delete | ||||
| FK_SAVED_QUERIES_CP_GRP_ID |
|
|
Restrict delete | ||||
| FK_SAVED_QUERIES_CREATED_BY |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_CPS_CP_ID |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_CPS_CONT_ID |
|
|
Restrict delete | ||||
| FK_PRINT_FILE_JOB_ID |
|
|
Restrict delete | ||||
| FK_PRINT_FILE_USER_ID |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_TYPE_ID |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_PARENT_CONT |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_SITE_ID |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_CREATED_BY |
|
|
Restrict delete | ||||
| FK_STOR_CONT_AUTO_PROVIDER_ID |
|
|
Restrict delete | ||||
| FK_RESERVED_FOR_DP_ID |
|
|
Restrict delete | ||||
| FK_RESERVED_SPMN_ID |
|
|
Restrict delete | ||||
| FK_CANCELLED_RESERVE_EVENT_ID |
|
|
Restrict delete | ||||
| FK_OS_DASHLET_CFG_ID |
|
|
Restrict delete | ||||
| FK_OS_DASHLET_DB_ID |
|
|
Restrict delete | ||||
| FK_USER_FIXED_EVENT |
|
|
Restrict delete | ||||
| FK_SPE_FIXATION_TYPE |
|
|
Restrict delete | ||||
| FK_SPEC_FIXED_EVENT |
|
|
Restrict delete | ||||
| OS_FK_SHIP_ITEMS_SPEC_ID |
|
|
Restrict delete | ||||
| OS_FK_SHIP_ITEMS_SHIP_ID |
|
|
Restrict delete | ||||
| FK_SHIP_SPMN_CONT_ID |
|
|
Restrict delete | ||||
| FK_SHIP_SPMN_RECV_QLTY |
|
|
Restrict delete | ||||
| FK_POOLED_EVENT_ID |
|
|
Restrict delete | ||||
| FK_POOLED_ITEM_SPECIMEN_ID |
|
|
Restrict delete | ||||
| FK_PV_PARENT_ID |
|
|
Restrict delete | ||||
| FK57DDCE1FC56C2B1 |
|
|
Restrict delete | ||||
| FK_SPECLIST_TAGITEM_TAG_ID |
|
|
Restrict delete | ||||
| FK_SPECLIST_OBJ_ID |
|
|
Restrict delete | ||||
| FK_lguqtanqxx49uiynh9ihcbjhc |
|
|
Restrict delete | ||||
| FK5EB25F1348304401 |
|
|
Restrict delete | ||||
| FK5EB25F1387E5ADC7 |
|
|
Restrict delete | ||||
| FK_CPR_SITE_ID |
|
|
Restrict delete | ||||
| FK5EB25F13A0FF79D4 |
|
|
Restrict delete | ||||
| FK_OS_DO_SPMN_LIST_ID |
|
|
Restrict delete | ||||
| FK_DO_CLEAR_LIST_ID |
|
|
Restrict delete | ||||
| FK_OS_DO_DP_ID |
|
|
Restrict delete | ||||
| FK_OS_DO_DISTRIBUTER_ID |
|
|
Restrict delete | ||||
| FK_OS_ORDERS_REQ_ID |
|
|
Restrict delete | ||||
| FK_OS_DO_SITE_ID |
|
|
Restrict delete | ||||
| FK_OS_DO_REQUESTER_ID |
|
|
Restrict delete | ||||
| FK_OS_OI_RETURNED_BY |
|
|
Restrict delete | ||||
| FK_OS_OI_RETURNING_CONT |
|
|
Restrict delete | ||||
| FK_OS_OI_DO_ID |
|
|
Restrict delete | ||||
| FK_OS_OI_SPECIMEN_ID |
|
|
Restrict delete | ||||
| FK_CONT_ACT_LOG_CONT_ID |
|
|
Restrict delete | ||||
| FK_CONT_ACT_LOG_TASK_ID |
|
|
Restrict delete | ||||
| FK_CONT_ACT_LOG_USER_ID |
|
|
Restrict delete | ||||
| FK_CONT_ACT_LOG_ACT_ID |
|
|
Restrict delete | ||||
| FKE490E33A48304401 |
|
|
Restrict delete | ||||
| FKE490E33A2206F20F |
|
|
Restrict delete | ||||
| FK_SPMN_LIST_SHR_GRP_LIST_ID |
|
|
Restrict delete | ||||
| FK_SPMN_LIST_SHR_GRP_GRP_ID |
|
|
Restrict delete | ||||
| FK_OS_REQ_SPMNS_SPMN_ID |
|
|
Restrict delete | ||||
| FK_OS_REQ_SPMNS_DIST_ID |
|
|
Restrict delete | ||||
| FK_OS_REQ_SPMNS_REQ_ID |
|
|
Restrict delete | ||||
| FK_OS_REQ_SPMNS_SHIP_ID |
|
|
Restrict delete | ||||
| FK_SPMN_GEL_SITE_ID |
|
|
Restrict delete | ||||
| FKD74882FD91092806 |
|
|
Restrict delete | ||||
| FKD74882FDBC7298A9 |
|
|
Restrict delete | ||||
| FK_SPEC_IN_OUT_EVENT |
|
|
Restrict delete | ||||
| FK_USER_INOUT_EVENT |
|
|
Restrict delete | ||||
| FK_hs8crr2d3nwca17qqfli82ym |
|
|
Restrict delete | ||||
| FK7AE7715948304401 |
|
|
Restrict delete | ||||
| FK_CPE_CLINICAL_DIAGNOSIS |
|
|
Restrict delete | ||||
| FK_CPE_CLINICAL_STATUS |
|
|
Restrict delete | ||||
| FK_SITE_ID_CPE |
|
|
Restrict delete | ||||
| FK904EC9F040DCD7BF |
|
|
Restrict delete | ||||
| FK_c4n30y077ycht0hl58ri6fko7 |
|
|
Restrict delete | ||||
| FK_CFG_PROPS_MODULE_ID |
|
|
Restrict delete | ||||
| FK6 |
|
|
Restrict delete | ||||
| FK5 |
|
|
Restrict delete | ||||
| FK_qaypykblepjftrcv2xe056rvh |
|
|
Restrict delete | ||||
| FK_RS_CATALOG_ID |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_CST_CONT_ID |
|
|
Restrict delete | ||||
| FK_CONT_COMP_SPMN_TYPE |
|
|
Restrict delete | ||||
| FK_SCHED_ACTIVITIES_CONT_ID |
|
|
Restrict delete | ||||
| FK_SCHED_ACTIVITIES_TASK_ID |
|
|
Restrict delete | ||||
| FK_SPECIMEN_POSITION |
|
|
Restrict delete | ||||
| FK_SPECIMEN |
|
|
Restrict delete | ||||
| FK_STORAGE_CONTAINER |
|
|
Restrict delete | ||||
| FK_DIST_SERVICE_TYPE |
|
|
Restrict delete | ||||
| FK_OS_DIST_SERVICES_DP_ID |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_CCPS_CP_ID |
|
|
Restrict delete | ||||
| FK_OS_ST_CONT_CCPS_CONT_ID |
|
|
Restrict delete | ||||
| FK_OS_BLK_IMP_JOBS_CREATED_BY |
|
|
Restrict delete | ||||
| FK_AUDIT_LOGS_USER_ID |
|
|
Restrict delete | ||||
| FK_DP_COORD_DP_ID |
|
|
Restrict delete | ||||
| FK_DP_COORD_USER_ID |
|
|
Restrict delete | ||||
| FK5311FFF691092806 |
|
|
Restrict delete | ||||
| FK5311FFF62206F20F |
|
|
Restrict delete | ||||
| FK_EXT_APP_PROPS_ID |
|
|
Restrict delete | ||||
| FK_t69kea3hasj6uc6ddn5ck5r9y |
|
|
Restrict delete | ||||
| FK_USER_EVENT_MAPPING |
|
|
Restrict delete | ||||
| FK_VISIT_COHORT |
|
|
Restrict delete | ||||
| FK_VISIT_MISSED_REASON |
|
|
Restrict delete | ||||
| FKDEBAF1677E07C4AC |
|
|
Restrict delete | ||||
| FK_SITE_ID_SCG |
|
|
Restrict delete | ||||
| FKDEBAF16753B01F66 |
|
|
Restrict delete | ||||
| FK_VISIT_CLINICAL_STATUS |
|
|
Restrict delete | ||||
| FK_RECEIVER_ID_SCG |
|
|
Restrict delete | ||||
| FK_m9slxw75ecrvrk31nwwamd7ng |
|
|
Restrict delete | ||||
| FK_OS_CONT_TYPE_CAN_HOLD |
|
|
Restrict delete | ||||
| FK_SPMN_GEL_ITEM_GEL_ID |
|
|
Restrict delete | ||||
| FK_SPMN_GEL_ITEM_SPECIMEN_ID |
|
|
Restrict delete | ||||
| FK_OS_SUB_ROLES_TO_CP |
|
|
Restrict delete | ||||
| FK_OS_SUB_ROLES_TO_SITE |
|
|
Restrict delete | ||||
| FK_OS_SUB_ID_USER_ID |
|
|
Restrict delete | ||||
| FK_OS_SUB_ROLES_TO_ROLES |
|
|
Restrict delete | ||||
| FKF74E94AE17B9953 |
|
|
Restrict delete | ||||
| FK_USER_DOMAIN_ID |
|
|
Restrict delete | ||||
| FK_USER_INSTITUTE_ID |
|
|
Restrict delete | ||||
| FK_USER_PRINTER |
|
|
Restrict delete | ||||
| FK_USER_PRIMARY_SITE_ID |
|
|
Restrict delete | ||||
| FK_USER_MOL_EVENT |
|
|
Restrict delete | ||||
| FK_SPEC_MOL_REV_EVENT |
|
|
Restrict delete | ||||
| FK_SPEC_TRANSFER_EVENT |
|
|
Restrict delete | ||||
| FK_USER_TRANSFER_EVENT |
|
|
Restrict delete | ||||
| FK_i34f99d4j0u2hcato9dww1mxw |
|
|
Restrict delete | ||||
| FK_PV_HIERARCHY_DESCENDANT |
|
|
Restrict delete | ||||
| FK_PV_HIERARCHY_ANCESTOR |
|
|
Restrict delete | ||||
| FK_ORDER_EXTN_FORM_ID |
|
|
Restrict delete | ||||
| FK_DP_REPORT_ID |
|
|
Restrict delete | ||||
| FK_CAT_DP_INSTITUTE_ID |
|
|
Restrict delete | ||||
| FK_DP_DEF_REC_SITE_ID |
|
|
Restrict delete | ||||
| FK_STAGED_VISITS_PARTICIPANT |
|
|
Restrict delete | ||||
| OS_FK_AUTO_PROV_PROPS_PROV_ID |
|
|
Restrict delete | ||||
| FK_MOBILE_UPLOADS_CREATOR_ID |
|
|
Restrict delete | ||||
| FK_MOBILE_UPLOADS_CP_ID |
|
|
Restrict delete | ||||
| FK_OS_SCHEDULED_JOB_RECIPIENTS |
|
|
Restrict delete | ||||
| FK_OS_SCHLD_JOB_RECPT_USERS |
|
|
Restrict delete | ||||
| FK_QUERYTAG_USER_ID |
|
|
Restrict delete | ||||
| FK_PV_PROPS_PV_ID |
|
|
Restrict delete | ||||
| FK_OS_SCHEDULED_RUN_JOB_ID |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|