Constraints

25 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
DTW_BST_ACC_FEATURE_ACC_FK
DTW_BST_ACCOUNT_FEATURE.ACCOUNT_ID
DTW_BST_DIM_ACCOUNT.ACCOUNT_ID
Cascade on delete
DTW_BST_FK_FACT_ENTRY
DTW_BST_ENTRY_DETAILS.ENTRY_ID
DTW_BST_FACT_ENTRY.ID
Cascade on delete
DTW_BST_BALANCE_SNAPSHOT_FK
DTW_BST_SNAPSHOT_BALANCE.SNAPSHOT_ID
DTW_BST_SNAPSHOT.ID
Cascade on delete
DTW_BST_EVENT_ROUTING_DATA_FK
DTW_BST_EVENT_ROUTING_DATA.EVENT_ROUTING_ID
DTW_BST_EVENT_ROUTING.ID
Cascade on delete
DTW_BST_SNAPSHOT_ACCOUNT_FK
DTW_BST_SNAPSHOT.ACCOUNT_ID
DTW_BST_DIM_ACCOUNT.ACCOUNT_ID
Restrict delete
FK_BST_MEMBERSHIP_ACCOUNT_ID
DTW_BST_ACCOUNT_MEMBERSHIP.ACCOUNT_ID
DTW_BST_DIM_ACCOUNT.ACCOUNT_ID
Restrict delete
DTW_BST_FK_FACT_EVENT_TIME
DTW_BST_FACT_ENTRY.EVENT_TIME_ID
DTW_BST_DIM_TIME.TIME_ID
Restrict delete
DTW_BST_FK_FACT_EVENT_DATE
DTW_BST_FACT_ENTRY.EVENT_DATE_ID
DTW_BST_DIM_DATE.DATE_ID
Restrict delete
DTW_BST_FK_FACT_ENTRY_KIND
DTW_BST_FACT_ENTRY.ENTRY_KIND_ID
DTW_BST_DIM_ENTRY_KIND.ENTRY_KIND_ID
Restrict delete
DTW_BST_FK_FACT_ENTRY_ACCOUNT
DTW_BST_FACT_ENTRY.ACCOUNT_ID
DTW_BST_DIM_ACCOUNT.ACCOUNT_ID
Restrict delete
DTW_BST_FK_FACT_ENTRY_DATE
DTW_BST_FACT_ENTRY.ENTRY_DATE_ID
DTW_BST_DIM_DATE.DATE_ID
Restrict delete
DTW_BST_FK_FACT_HISTORY_CODE
DTW_BST_FACT_ENTRY.HISTORY_CODE_ID
DTW_BST_DIM_HISTORY.HISTORY_CODE_ID
Restrict delete
DTW_BST_FK_FACT_BALANCE_TYPE
DTW_BST_FACT_BALANCE.BALANCE_TYPE_ID
DTW_BST_DIM_BALANCE_TYPE.BALANCE_TYPE_ID
Restrict delete
DTW_BST_FK_FACT_BALANCE_DATE
DTW_BST_FACT_BALANCE.ENTRY_DATE_ID
DTW_BST_DIM_DATE.DATE_ID
Restrict delete
DTW_BST_FK_FACT_BALANCE_AC
DTW_BST_FACT_BALANCE.ACCOUNT_ID
DTW_BST_DIM_ACCOUNT.ACCOUNT_ID
Restrict delete
DTW_BST_ENTRY_FEATURE_ENTRY_FK
DTW_BST_ENTRY_FEATURE.ENTRY_ID
DTW_BST_FACT_ENTRY.ID
Cascade on delete
DTW_BST_COMPENSATED_ENTRY_ID_FK
DTW_BST_COMPENSATING_ENTRY.COMPENSATED_ENTRY_ID
DTW_BST_FACT_ENTRY.ID
Restrict delete
DTW_BST_COMPENSATING_ENTRY_ID_FK
DTW_BST_COMPENSATING_ENTRY.ENTRY_ID
DTW_BST_FACT_ENTRY.ID
Restrict delete
DTW_BST_FK_ACCOUNT_TYPE
DTW_BST_DIM_ACCOUNT.ACCOUNT_TYPE_ID
DTW_BST_DIM_ACCOUNT_TYPE.ACCOUNT_TYPE_ID
Restrict delete
DTW_BST_BALANCE_BALANCETYPE_FK
DTW_BST_BALANCE.BALANCE_TYPE_ID
DTW_BST_DIM_BALANCE_TYPE.BALANCE_TYPE_ID
Restrict delete
DTW_BST_FK_BALANCE_ACCOUNT
DTW_BST_BALANCE.ACCOUNT_ID
DTW_BST_DIM_ACCOUNT.ACCOUNT_ID
Restrict delete
FK_PEND_BALANCE_TYPE_ID
DTW_BST_PENDING_BALANCE.BALANCE_TYPE_ID
DTW_BST_DIM_BALANCE_TYPE.BALANCE_TYPE_ID
Restrict delete
FK_BST_MEMBERSHIP_ACC_FEAT_ID
DTW_BST_ACC_MEMBERSHIP_FEAT.ACCOUNT_MEMBERSHIP_ID
DTW_BST_ACCOUNT_MEMBERSHIP.ID
Restrict delete
DTW_BST_FK_DOCUMENT_CATEGORY
DTW_BST_DIM_DOCUMENT_TYPE.ENTRY_CATEGORY_ID
DTW_BST_DIM_ENTRY_CATEGORY.ENTRY_CATEGORY_ID
Restrict delete
DTW_BST_FK_DOCUMENT_HISTORY
DTW_BST_DIM_DOCUMENT_TYPE.HISTORY_CODE_ID
DTW_BST_DIM_HISTORY.HISTORY_CODE_ID
Restrict delete

Check Constraints

Table Constraint Name Constraint