DTW_REG_SYS_LIMIT


Columns

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

A unique identifier to Registry System Limit
LIMIT_TYPE_ID CHAR 36 null
DTW_REG_LIMIT_TYPE.ID DTW_REG_SYS_REG_LIMIT_TYPE_FK C

The id of the type associated with the limit
REG_SYS_ID CHAR 36 null
DTW_REG_SYS.ID DTW_REG_SYS_LIMIT_FK C

A unique identifier to foreign key to Registry System
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_SYS_LIMIT_IDX Performance Asc REG_SYS_ID
DTW_REG_SYS_LIMIT_TYPE_IDX Performance Asc LIMIT_TYPE_ID
DTW_REG_SYS_TYPE_LIMIT_SYS_IDX Must be unique Asc/Asc REG_SYS_ID + LIMIT_TYPE_ID

Relationships

Close relationships within degrees of separation