DTW_TR_BALANCE_PATTERN_BKP


Description

Holds a balance pattern

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_TR_BALANCE_CRITERION_BKP.BALANCE_PATTERN_ID DTW_TR_BALANCE_CRITERIA_FK C
DTW_TR_BALANCE_PATTERN_BLC_BKP.BALANCE_PATTERN_ID DTW_TR_BALANCE_PATTERN_PID_FK C

Identifies the balance pattern
DESCRIPTION VARCHAR 256 null

Describes the underlying balance pattern
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the intent was created
UPDATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the intent was lastly updated
SALIENCE DECIMAL 5 null

Specifies the salience (order) of the given pattern. Patterns with lower saliencies are checked first
CATEGORY_ID VARCHAR 64 null
DTW_TR_AFFECTED_BLC_CTG_BPK.ID DTW_TR_BALANCE_PATTERN_CTG_FK C

Identifies the associatted pattern category

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TR_BALANCE_PATTERN_CTG_IDX Performance Asc CATEGORY_ID
DTW_TR_BALANCE_PATTERN_S_IDX Performance Asc/Asc CATEGORY_ID + SALIENCE

Relationships

Close relationships within degrees of separation