DTW_BST_ACCOUNT_MEMBERSHIP


Description

Holds the bound to a account holder

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_BST_ACC_MEMBERSHIP_FEAT.ACCOUNT_MEMBERSHIP_ID FK_BST_MEMBERSHIP_ACC_FEAT_ID R

Identifiers the account holder
ACCOUNT_ID CHAR 36 null
DTW_BST_DIM_ACCOUNT.ACCOUNT_ID FK_BST_MEMBERSHIP_ACCOUNT_ID R

Checking account unique ID
ACCOUNT_HOLDER_ID CHAR 36 null

Identifiers the account holder ID
CREATED_AT DATETIME 26 √ CURRENT_TIMESTAMP(6)

When the account membership was created within the balance statement

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_BST_ACC_MEM_HOLDER_ID_IDX Performance Asc ACCOUNT_HOLDER_ID
DTW_BST_ACCOUNT_MEM_NAT_ID Must be unique Asc/Asc ACCOUNT_ID + ACCOUNT_HOLDER_ID

Relationships

Close relationships within degrees of separation