DTW_TR_ACCOUNT_TYPE


Description

Holds the available account types

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_TR_ACC_TYPE_FEATURE.ACCOUNT_TYPE_ID DTW_TR_ACC_T_F_ACC_T_ID_FK C
DTW_TR_ACCOUNT.ACCOUNT_TYPE_ID DTW_TR_ACCOUNT_ACCOUNT_TYPE_FK R

Identifies the given account type
ACCOUNT_TYPE VARCHAR 64 null

The natural id of an account type
ACCOUNT_TYPE_CATEGORY VARCHAR 64 null

The category of an account type
DESCRIPTION VARCHAR 256 null

The description of the given account type
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

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

When the account type was lastly updated

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID

Relationships

Close relationships within degrees of separation