DTW_TR_PATTERN_RULE_BALANCE


Columns

Column Type Size Nulls Auto Default Children Parents Comments
RULE_ID VARCHAR 64 null
DTW_TR_PATTERN_BASED_RULE.ID DTW_TR_PTTRN_RULE_BLC_RULE_FK C

Identifies the underlying balance pattern rule
PATTERN_ID CHAR 36 null
DTW_TR_RULE_PATTERN.ID DTW_TR_PTTRN_RULE_BLC_PTN_FK C

Identifies the underlying pattern
BALANCE_TYPE_ID VARCHAR 64 null
DTW_TR_BALANCE_TYPE.ID DTW_TR_PTTRN_RULE_BLC_BLC_FK C

Identifies the underlying balance type

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc RULE_ID + PATTERN_ID + BALANCE_TYPE_ID
DTW_TR_PTTRN_RULE_BLC_BLC_FK Performance Asc BALANCE_TYPE_ID
DTW_TR_PTTRN_RULE_BLC_PTN_FK Performance Asc PATTERN_ID
DTW_TR_PTTRN_RULE_BLC_RULE_IDX Performance Asc RULE_ID

Relationships

Close relationships within degrees of separation