DTW_REG_ACCOUNT_TYPE_LIMIT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null

A unique identifier to Account Type Limit
LIMIT_TYPE_ID CHAR 36 null
DTW_REG_LIMIT_TYPE.ID DTW_REG_ACC_TYPE_LIMIT_TYPE_FK C

The id of the type associated with the limit
ACCOUNT_TYPE_ID CHAR 36 null
DTW_REG_ACCOUNT_TYPE.ID DTW_REG_ACC_TYPE_FK C

A unique identifier to foreign key to Account Type
CURRENCY CHAR 3 null

Identifies the currency on which the limit value
MINIMUM_AMOUNT DECIMAL 19 null

Identifies the minimum amount permitted by the given limit
MAXIMUM_AMOUNT DECIMAL 19 null

Identifies the maximum amount permitted by the given limit
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_ACC_TP_LIMIT_ACCTP_IDX Must be unique Asc/Asc ACCOUNT_TYPE_ID + LIMIT_TYPE_ID
DTW_REG_ACC_TP_LIMIT_TP_IDX Performance Asc LIMIT_TYPE_ID
DTW_REG_ACC_TP_LIMIT_TYPE_IDX Performance Asc ACCOUNT_TYPE_ID

Relationships

Close relationships within degrees of separation