DTW_REG_HISTORY_CODE


Description

Holds the History Code

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_REG_HISTORY_CODE.REVERSAL_ID DTW_REG_HST_CODE_REVERSAL_FK N
DTW_REG_HISTORY_CODE_FEAT.HISTORY_CODE_ID DTW_REG_HST_FEATURE_HST_ID_FK C

Identifies the history code
HISTORY_CODE_KEY VARCHAR 64 null

The natural id of an history code key
HISTORY_CODE_TYPE VARCHAR 64 null

The entry type (CREDIT, DEBIT OR BALANCE)
DESCRIPTION VARCHAR 255 null

A String description to an History Type
REVERSAL_ID CHAR 36 √ null
DTW_REG_HISTORY_CODE.ID DTW_REG_HST_CODE_REVERSAL_FK N

Identifies the reversal history 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_HISTORY_CODE_NID_IDX Must be unique Asc HISTORY_CODE_KEY
DTW_REG_HST_CODE_REVERSAL_FK Performance Asc REVERSAL_ID

Relationships

Close relationships within degrees of separation