DTW_BST_DIM_ACCOUNT


Description

Account status dimension definition table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACCOUNT_ID CHAR 36 null
DTW_BST_ACCOUNT_FEATURE.ACCOUNT_ID DTW_BST_ACC_FEATURE_ACC_FK C
DTW_BST_ACCOUNT_MEMBERSHIP.ACCOUNT_ID FK_BST_MEMBERSHIP_ACCOUNT_ID R
DTW_BST_BALANCE.ACCOUNT_ID DTW_BST_FK_BALANCE_ACCOUNT R
DTW_BST_FACT_BALANCE.ACCOUNT_ID DTW_BST_FK_FACT_BALANCE_AC R
DTW_BST_FACT_ENTRY.ACCOUNT_ID DTW_BST_FK_FACT_ENTRY_ACCOUNT R
DTW_BST_SNAPSHOT.ACCOUNT_ID DTW_BST_SNAPSHOT_ACCOUNT_FK R

Account unique ID.
ACCOUNT_TYPE_ID CHAR 36 null
DTW_BST_DIM_ACCOUNT_TYPE.ACCOUNT_TYPE_ID DTW_BST_FK_ACCOUNT_TYPE R

Account unique type ID.
ACCOUNT_STATUS VARCHAR 20 ACTIVE

Account status (ACTIVE, INACTIVE OR DELETED).
BRANCH INT 10 null
ACCOUNT BIGINT 19 null

Account number.
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

Timestamp value to register a record creation time.
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 ACCOUNT_ID
DTW_BST_DIM_ACCOUNT_BR_ACC_IDX Must be unique Asc/Asc BRANCH + ACCOUNT
DTW_BST_FK_ACCOUNT_TYPE Performance Asc ACCOUNT_TYPE_ID

Relationships

Close relationships within degrees of separation