DTW_TR_BLOCKING_RELATED_ENTRY


Description

Links an intent to its entries

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ENTRY_ID CHAR 36 null
DTW_TR_ENTRY.ID DTW_TR_BLOCKING_REL_ENT_ENT_FK C

Identifies the associated entry.
HOLD_REASON_ID VARCHAR 64 √ null
DTW_TR_HOLD_REASON.ID DTW_TR_BLOCKING_REL_ENT_HID_FK C

Holds an optional generic domain id, such as blocking reason, of the underlying entry
TARGET_ID CHAR 36 √ null
DTW_TR_ENTRY.ID DTW_TR_BLOCKING_REL_ENT_TRG_FK R

Identifies the target entry (may be null if the underlying blocking is balance-based)
ACTIVE BIT 1 √ null

Marks if a given compensating reference is active (if not active, null is stored)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ENTRY_ID
DTW_TR_BLOCKING_REL_ENT_E_IDX Must be unique Asc/Asc TARGET_ID + ACTIVE
DTW_TR_BLOCKING_REL_ENT_HID_FK Performance Asc HOLD_REASON_ID

Relationships

Close relationships within degrees of separation