Constraints

68 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
DTW_TR_INTENT_ENTRY_REL_INT_FK
DTW_TR_INTENT_ENTRY_REL.INTENT_ID
DTW_TR_INTENT.ID
Cascade on delete
DTW_TR_INTENT_ENTRY_REL_ENT_FK
DTW_TR_INTENT_ENTRY_REL.ENTRY_ID
DTW_TR_ENTRY.ID
Cascade on delete
JOB_EXEC_PARAMS_FK
DTW_TRS_BATCH_JOB_EXECUTION_PARAMS.JOB_EXECUTION_ID
DTW_TRS_BATCH_JOB_EXECUTION.JOB_EXECUTION_ID
Restrict delete
DTW_TR_ENTRY_BATCH_GROUP_FK
DTW_TR_ENTRY_BATCH.ENTRY_BATCH_GROUP_ID
DTW_TR_ENTRY_BATCH_GROUP.ID
Cascade on delete
DTW_TR_MON_REL_MON_INT_FK
DTW_TR_MONITORING_PROCESS_REL.MONITORING_ID
DTW_TR_INTENT.ID
Restrict delete
DTW_TR_EVENT_ROUTING_DATA_FK
DTW_TR_EVENT_ROUTING_DATA.EVENT_ROUTING_ID
DTW_TR_EVENT_ROUTING.ID
Cascade on delete
DTW_TR_HOLD_REASON_FT_ID_FK
DTW_TR_HOLD_REASON_FEATURE.HOLD_REASON_ID
DTW_TR_HOLD_REASON.ID
Cascade on delete
DTW_TR_HIST_CODE_REVERSAL_FK
DTW_TR_HISTORY_CODE.REVERSAL_HISTORY_CODE_ID
DTW_TR_HISTORY_CODE.ID
Null on delete
DTW_TR_BALANCE_TYPE_FEATURE_FK
DTW_TR_BALANCE_TYPE_FEATURE.BALANCE_TYPE_ID
DTW_TR_BALANCE_TYPE.ID
Cascade on delete
DTW_TR_ACC_T_F_ACC_T_ID_FK
DTW_TR_ACC_TYPE_FEATURE.ACCOUNT_TYPE_ID
DTW_TR_ACCOUNT_TYPE.ID
Cascade on delete
DTW_TR_ENTRY_ENTRY_BATCH_FK
DTW_TR_ENTRY.ENTRY_BATCH_ID
DTW_TR_ENTRY_BATCH.ID
Cascade on delete
DTW_TR_HISTORY_CODE_FK
DTW_TR_ENTRY.HISTORY_CODE_ID
DTW_TR_HISTORY_CODE.ID
Restrict delete
DTW_TR_HST_FEATURE_HST_ID_FK
DTW_TR_HISTORY_CODE_FEAT.HISTORY_CODE_ID
DTW_TR_HISTORY_CODE.ID
Cascade on delete
DTW_TR_VALIDATION_R_BP_RUL_FK
DTW_TR_VALIDATION_R_BLUEPRINT.RULE_ID
DTW_TR_PATTERN_BASED_RULE.ID
Cascade on delete
DTW_TR_VALIDATION_R_BP_PAT_FK
DTW_TR_VALIDATION_R_BLUEPRINT.PATTERN_ID
DTW_TR_RULE_PATTERN.ID
Cascade on delete
DTW_TR_BALANCE_TYPE_FK
DTW_TRS_SCHEDULE_LIMIT.BALANCE_TYPE
DTW_TR_BALANCE_TYPE.ID
Restrict delete
DTW_TR_ACCOUNT_ACCOUNT_TYPE_FK
DTW_TR_ACCOUNT.ACCOUNT_TYPE_ID
DTW_TR_ACCOUNT_TYPE.ID
Restrict delete
DTW_TR_ACC_FEATURE_ACC_FK
DTW_TR_ACCOUNT_FEATURE.ACCOUNT_ID
DTW_TR_ACCOUNT.ID
Cascade on delete
DTW_TR_ENTRY_FLMNT_FLM_FK
DTW_TR_ENTRY_FULFILLMENT.FULFILLED_ENTRY_ID
DTW_TR_ENTRY.ID
Cascade on delete
DTW_TR_ENTRY_FLMNT_PRM_FK
DTW_TR_ENTRY_FULFILLMENT.PENDING_ENTRY_ID
DTW_TR_ENTRY.ID
Restrict delete
JOB_EXEC_CTX_FK
DTW_TRS_BATCH_JOB_EXECUTION_CONTEXT.JOB_EXECUTION_ID
DTW_TRS_BATCH_JOB_EXECUTION.JOB_EXECUTION_ID
Restrict delete
JOB_EXEC_STEP_FK
DTW_TRS_BATCH_STEP_EXECUTION.JOB_EXECUTION_ID
DTW_TRS_BATCH_JOB_EXECUTION.JOB_EXECUTION_ID
Restrict delete
DTW_TR_INTENT_EXCLUSION_I_FK
DTW_TR_INTENT_EXCLUSION.INTENT_ID
DTW_TR_INTENT.ID
Cascade on delete
DTW_TR_SYS_FEAT_SYS_FK
DTW_TR_SYS_FEAT.SYSTEM_ID
DTW_TR_SYS.ID
Cascade on delete
DTW_TR_BALANCE_SNAPSHOT_T_FK
DTW_TR_SNAPSHOT_BALANCE.BALANCE_TYPE_ID
DTW_TR_BALANCE_TYPE.ID
Restrict delete
DTW_TR_BALANCE_SNAPSHOT_FK
DTW_TR_SNAPSHOT_BALANCE.SNAPSHOT_ID
DTW_TR_SNAPSHOT.ID
Cascade on delete
DTW_TR_MON_REL_MONITORING_FK
DTW_TR_MONITORING_RELEASE.MONITORING_ID
DTW_TR_INTENT.ID
Restrict delete
JOB_INST_EXEC_FK
DTW_TRS_BATCH_JOB_EXECUTION.JOB_INSTANCE_ID
DTW_TRS_BATCH_JOB_INSTANCE.JOB_INSTANCE_ID
Restrict delete
DTW_TR_RULE_PATTERN_RULE_FK
DTW_TR_RULE_PATTERN.PATTERN_BASED_RULE_ID
DTW_TR_PATTERN_BASED_RULE.ID
Cascade on delete
DTW_TR_PTTRN_RULE_BLC_BLC_FK
DTW_TR_PATTERN_RULE_BALANCE.BALANCE_TYPE_ID
DTW_TR_BALANCE_TYPE.ID
Cascade on delete
DTW_TR_PTTRN_RULE_BLC_PTN_FK
DTW_TR_PATTERN_RULE_BALANCE.PATTERN_ID
DTW_TR_RULE_PATTERN.ID
Cascade on delete
DTW_TR_PTTRN_RULE_BLC_RULE_FK
DTW_TR_PATTERN_RULE_BALANCE.RULE_ID
DTW_TR_PATTERN_BASED_RULE.ID
Cascade on delete
DTW_TR_PHYSICAL_BLC_TYPE_FK
DTW_TR_PHYSICAL_BALANCE.BALANCE_TYPE
DTW_TR_BALANCE_TYPE.ID
Restrict delete
DTW_TR_BALANCE_PARENT_FK
DTW_TR_BALANCE_LAYER.PARENT
DTW_TR_BALANCE_TYPE.ID
Cascade on delete
DTW_TR_BALANCE_CHILD_FK
DTW_TR_BALANCE_LAYER.LAYER
DTW_TR_BALANCE_TYPE.ID
Cascade on delete
DTW_TR_ACC_GRP_MSHIP_GRP_FK
DTW_TR_ACC_GROUP_MEMBERSHIP.ACCOUNT_GROUP_ID
DTW_TR_ACCOUNT_GROUP.ID
Cascade on delete
DTW_TR_ACC_GRP_MSHIP_ACC_FK
DTW_TR_ACC_GROUP_MEMBERSHIP.ACCOUNT_ID
DTW_TR_ACCOUNT.ID
Cascade on delete
DTW_TR_BLOCKING_REL_ENT_ENT_FK
DTW_TR_BLOCKING_RELATED_ENTRY.ENTRY_ID
DTW_TR_ENTRY.ID
Cascade on delete
DTW_TR_BLOCKING_REL_ENT_TRG_FK
DTW_TR_BLOCKING_RELATED_ENTRY.TARGET_ID
DTW_TR_ENTRY.ID
Restrict delete
DTW_TR_BLOCKING_REL_ENT_HID_FK
DTW_TR_BLOCKING_RELATED_ENTRY.HOLD_REASON_ID
DTW_TR_HOLD_REASON.ID
Cascade on delete
DTW_TR_ACTIVE_MONITORING_FK
DTW_TR_ACTIVE_MONITORING.MONITORING_ID
DTW_TR_INTENT.ID
Cascade on delete
DTW_TR_INTENT_BLUEPRINT_INT_FK
DTW_TR_INTENT_BLUEPRINT.INTENT_ID
DTW_TR_INTENT.ID
Cascade on delete
DTW_TR_ACC_GRP_BLNC_TP_BLNC_FK
DTW_TR_ACC_GROUP_BALANCE_TYPE.BALANCE_TYPE_ID
DTW_TR_BALANCE_TYPE.ID
Cascade on delete
DTW_TR_ACC_GRP_FEATURE_ACC_FK
DTW_TR_ACCOUNT_GROUP_FEATURE.ACCOUNT_GROUP_ID
DTW_TR_ACCOUNT_GROUP.ID
Cascade on delete
DTW_TR_INTENT_TRIGGER_INT_FK
DTW_TR_INTENT_ENTRY_TRIGGER.INTENT_ID
DTW_TR_INTENT.ID
Cascade on delete
DTW_TR_ENTRY_BATCH_GRP_ACC_FK
DTW_TR_ENTRY_BATCH_GROUP.ACCOUNT_ID
DTW_TR_ACCOUNT.ID
Restrict delete
DTW_TR_ENTRY_ID_FK
DTW_TR_MONITORING_RELEASE_ENTRIES.ENTRY_ID
DTW_TR_ENTRY.ID
Restrict delete
DTW_TR_MONITORING_RELEASE_ID_FK
DTW_TR_MONITORING_RELEASE_ENTRIES.MONITORING_RELEASE_ID
DTW_TR_MONITORING_RELEASE.ID
Restrict delete
DTW_TR_MON_BALANCES_REL_MON_FK
DTW_TR_MONITORING_BALANCE_REL.MONITORING_ID
DTW_TR_INTENT.ID
Cascade on delete
DTW_TR_MON_BALANCES_REL_BAL_FK
DTW_TR_MONITORING_BALANCE_REL.BALANCE_TYPE_ID
DTW_TR_BALANCE_TYPE.ID
Cascade on delete
DTW_TR_BALANCE_PATTERN_CTG_FK
DTW_TR_BALANCE_PATTERN_BKP.CATEGORY_ID
DTW_TR_AFFECTED_BLC_CTG_BPK.ID
Cascade on delete
DTW_TR_BALANCE_CRITERIA_FK
DTW_TR_BALANCE_CRITERION_BKP.BALANCE_PATTERN_ID
DTW_TR_BALANCE_PATTERN_BKP.ID
Cascade on delete
STEP_EXEC_CTX_FK
DTW_TRS_BATCH_STEP_EXECUTION_CONTEXT.STEP_EXECUTION_ID
DTW_TRS_BATCH_STEP_EXECUTION.STEP_EXECUTION_ID
Restrict delete
DTW_TR_COMPENSATING_ENTRY_E_FK
DTW_TR_COMPENSATING_ENTRY.ENTRY_ID
DTW_TR_ENTRY.ID
Cascade on delete
DTW_TR_ENTRY_ID_REL_FK
DTW_TR_MONITORING_PROCESS_REL_ENTRIES.ENTRY_ID
DTW_TR_ENTRY.ID
Restrict delete
DTW_TR_MONITORING_PROCESS_REL_ID_FK
DTW_TR_MONITORING_PROCESS_REL_ENTRIES.MONITORING_PROCESS_ID
DTW_TR_MONITORING_PROCESS_REL.ID
Restrict delete
DTW_TR_ACC_SS_STE_ACC_FK
DTW_TR_ACCOUNT_SNAPSHOT_STATE.ACCOUNT_ID
DTW_TR_ACCOUNT.ID
Restrict delete
DTW_TR_ACC_SS_STE_LS_FK
DTW_TR_ACCOUNT_SNAPSHOT_STATE.LAST_SNAPSHOT_ID
DTW_TR_SNAPSHOT.ID
Cascade on delete
SCHEDULE_LIMIT_ID_FK
DTW_TRS_SCHEDULE_LIMIT_TIME.SCHEDULE_LIMIT_ID
DTW_TRS_SCHEDULE_LIMIT.ID
Restrict delete
DTW_TR_INTENT_ACC_REL_INT_FK
DTW_TR_ACCOUNT_BASED_INTENT.INTENT_ID
DTW_TR_INTENT.ID
Cascade on delete
DTW_TR_BALANCE_PATTERN_TYP_FK
DTW_TR_BALANCE_PATTERN_BLC_BKP.BALANCE_TYPE_ID
DTW_TR_BALANCE_TYPE.ID
Cascade on delete
DTW_TR_BALANCE_PATTERN_PID_FK
DTW_TR_BALANCE_PATTERN_BLC_BKP.BALANCE_PATTERN_ID
DTW_TR_BALANCE_PATTERN_BKP.ID
Cascade on delete
DTW_TR_BLC_CHANGE_ENTRY_FK
DTW_TR_ENTRY_BALANCE_CHANGE.ENTRY_ID
DTW_TR_ENTRY.ID
Cascade on delete
DTW_TR_BLC_CHANGE_TYPE_FK
DTW_TR_ENTRY_BALANCE_CHANGE.BALANCE_TYPE_ID
DTW_TR_BALANCE_TYPE.ID
Restrict delete
DTW_TR_INTENT_METADATA_INT_FK
DTW_TR_INTENT_METADATA.INTENT_ID
DTW_TR_INTENT.ID
Cascade on delete
DTW_TR_SNAPSHOT_GROUP_FK
DTW_TR_SNAPSHOT.ENTRY_BATCH_GROUP_ID
DTW_TR_ENTRY_BATCH_GROUP.ID
Cascade on delete
DTW_TR_SNAPSHOT_ACCOUNT_FK
DTW_TR_SNAPSHOT.ACCOUNT_ID
DTW_TR_ACCOUNT.ID
Cascade on delete
DTW_TR_CRITERION_PATTERN_FK
DTW_TR_CRITERION.RULE_PATTERN_ID
DTW_TR_RULE_PATTERN.ID
Cascade on delete

Check Constraints

Table Constraint Name Constraint