DTW_REG_ACCOUNT_LIMIT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_REG_ACCOUNT_LIMIT_FEATURE.ACCOUNT_LIMIT_ID DTW_REG_ACCOUNT_LIMIT_FEATURE_ACCOUNT_LIMIT_ID_FK C

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

The id of the type associated with the limit
ACCOUNT_ID CHAR 36 null
DTW_REG_ACCOUNT.ID DTW_REG_ACCOUNT_FK C

A unique identifier to foreign key to Account
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.
VERSION DECIMAL 10 √ null

Limit data version

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_REG_ACC_LIMIT_ACC_TYPE_IDX Must be unique Asc/Asc ACCOUNT_ID + LIMIT_TYPE_ID
DTW_REG_ACC_LIMIT_ACCOUNT_IDX Performance Asc ACCOUNT_ID
DTW_REG_ACC_LIMIT_TYPE_IDX Performance Asc LIMIT_TYPE_ID

Relationships

Close relationships within degrees of separation