DTW_TR_BALANCE_LAYER


Description

Binds a composite balance (parent) to its components (children)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PARENT VARCHAR 64 null
DTW_TR_BALANCE_TYPE.ID DTW_TR_BALANCE_PARENT_FK C

Holds the parent balance
LAYER VARCHAR 64 null
DTW_TR_BALANCE_TYPE.ID DTW_TR_BALANCE_CHILD_FK C

Holds the child balance
SALIENCE TINYINT 3 null

Holds the salience of the child balance within the parent (i.e. orders the children)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc PARENT + LAYER + SALIENCE
DTW_TR_BALANCE_CHILD_IDX Must be unique Asc LAYER
DTW_TR_BALANCE_PARENT_IDX Performance Asc PARENT
DTW_TR_BALANCE_SALIENCE_IDX Must be unique Asc/Asc PARENT + SALIENCE

Relationships

Close relationships within degrees of separation