DTW_BST_BALANCE


Description

Holds the daily checking account balance

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null

Identifiers the daily checking account
ACCOUNT_ID CHAR 36 null
DTW_BST_DIM_ACCOUNT.ACCOUNT_ID DTW_BST_FK_BALANCE_ACCOUNT R

Account unique ID.
DATE DATE 10 null

Date of Balance
BALANCE_TYPE_ID CHAR 36 null
DTW_BST_DIM_BALANCE_TYPE.BALANCE_TYPE_ID DTW_BST_BALANCE_BALANCETYPE_FK R

Checking account balance type Unique ID.
CURRENCY CHAR 3 null

Holds the currency of the value associated with the given value
AMOUNT DECIMAL 19 null

Holds the given value
PREVIOUS_AMOUNT DECIMAL 19 null

Holds the previous amount value for this balance
SEQUENCE INT 10 null

Sequence (year+month+day) for the given balance, MaxValue 99999999 Represent last balance for account.
CREATED_AT DATETIME 26 √ CURRENT_TIMESTAMP(6)

When the account membership feature was created within the balance statement
UPDATED_AT DATETIME 26 √ CURRENT_TIMESTAMP(6)

Timestamp value to register a record update time.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_BST_BALANCE_ACC_DT_BT_CUR Must be unique Asc/Asc/Asc/Asc ACCOUNT_ID + DATE + BALANCE_TYPE_ID + CURRENCY
DTW_BST_BALANCE_ACC_SEQ_BT_CUR Must be unique Asc/Asc/Asc/Asc ACCOUNT_ID + SEQUENCE + BALANCE_TYPE_ID + CURRENCY
DTW_BST_BALANCE_BALANCETYPE_FK Performance Asc BALANCE_TYPE_ID

Relationships

Close relationships within degrees of separation