DTW_TR_ACCOUNT


Description

Holds an account

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_TR_ACC_GROUP_MEMBERSHIP.ACCOUNT_ID DTW_TR_ACC_GRP_MSHIP_ACC_FK C
DTW_TR_ACCOUNT_FEATURE.ACCOUNT_ID DTW_TR_ACC_FEATURE_ACC_FK C
DTW_TR_ACCOUNT_SNAPSHOT_STATE.ACCOUNT_ID DTW_TR_ACC_SS_STE_ACC_FK R
DTW_TR_ENTRY_BATCH_GROUP.ACCOUNT_ID DTW_TR_ENTRY_BATCH_GRP_ACC_FK R
DTW_TR_SNAPSHOT.ACCOUNT_ID DTW_TR_SNAPSHOT_ACCOUNT_FK C

Identifies the account
BRANCH INT 10 null

The owner branch of the account
ACCOUNT BIGINT 19 null

The account number
TIME_ZONE VARCHAR 30 null

The timezone of the account (on the tz database name format)
STATUS VARCHAR 36 null

The status of the account (possible values : ACTIVE, INACTIVE)
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the account was created within the digital twin
UPDATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the account was lastly updated (does not take balances in account)
ACCOUNT_TYPE_ID CHAR 36 null
DTW_TR_ACCOUNT_TYPE.ID DTW_TR_ACCOUNT_ACCOUNT_TYPE_FK R

The type of the given account

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TR_ACCOUNT_NATURAL_ID Must be unique Asc/Asc BRANCH + ACCOUNT
DTW_TR_ACCOUNT_TYPE_ID Performance Asc ACCOUNT_TYPE_ID

Relationships

Close relationships within degrees of separation