DTW_TRS_SCHEDULE_LIMIT


Description

Schedule limit events

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_TRS_SCHEDULE_LIMIT_TIME.SCHEDULE_LIMIT_ID SCHEDULE_LIMIT_ID_FK R

Identifies the given schedule limite
BALANCE_TYPE VARCHAR 64 null
DTW_TR_BALANCE_TYPE.ID DTW_TR_BALANCE_TYPE_FK R

Identifies which kind of balance the underlying record holds
BALANCE_HOLDER_TYPE VARCHAR 32 null

Holds the type of the balance account holder of the given balance (possible values: ACCOUNT)
BALANCE_HOLDER_ID CHAR 36 null

Identifiers the balance account holder of the given balance
PARTITION_NUMBER SMALLINT 5 null

Partition number

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TRS_SCHEDULE_LIMIT_BALANCE_TYPE_HOLDER_IDX Must be unique Asc/Asc/Asc BALANCE_TYPE + BALANCE_HOLDER_TYPE + BALANCE_HOLDER_ID
DTW_TRS_SCHEDULE_LIMIT_PARTITION_NUMBER_IDX Performance Asc PARTITION_NUMBER

Relationships

Close relationships within degrees of separation