DTW_REG_LIMIT_TYPE


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_REG_ACCOUNT_LIMIT.LIMIT_TYPE_ID DTW_REG_ACC_LIMIT_TYPE_FK C
DTW_REG_ACCOUNT_TYPE_LIMIT.LIMIT_TYPE_ID DTW_REG_ACC_TYPE_LIMIT_TYPE_FK C
DTW_REG_SYS_LIMIT.LIMIT_TYPE_ID DTW_REG_SYS_REG_LIMIT_TYPE_FK C

Unique identifier to a limit type
LIMIT_TYPE VARCHAR 64 null

The natural id of a limit type
DESCRIPTION VARCHAR 255 null

A String that holds a limit type description
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_LIMIT_TYPE_NID_IDX Must be unique Asc LIMIT_TYPE

Relationships

Close relationships within degrees of separation