DTW_REG_ACCOUNT_TYPE


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_REG_ACC_TYPE_FEATURE.ACCOUNT_TYPE_ID DTW_REG_ACC_T_F_ACC_T_ID_FK C
DTW_REG_ACCOUNT.ACCOUNT_TYPE_ID DTW_REG_ACCOUNT_TYPE_ID_FK C
DTW_REG_ACCOUNT_TYPE_LIMIT.ACCOUNT_TYPE_ID DTW_REG_ACC_TYPE_FK C

Unique identifier to an 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 255 null

A String description to an Account Type
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 ID
DTW_REG_ACCOUNT_TYPE_NID_IDX Must be unique Asc ACCOUNT_TYPE

Relationships

Close relationships within degrees of separation