DTW_REG_HISTORY_CODE_FEAT_AUD


Description

Holds the history code features auditing information

Columns

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

The feature ID

HISTORY_CODE_ID CHAR 36 null

The history code ID associated with this feature

NAME VARCHAR 64 null

The feature name

TYPE VARCHAR 32 null

The feature type

VALUE VARCHAR 1024 null

The feature value

REVISION_ID DECIMAL 32 null
REVISION_TYPE DECIMAL 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc ID + REVISION_ID
DTW_REG_HST_FEATURE_AUD_HC_IDX Performance Asc HISTORY_CODE_ID
DTW_REG_HST_FEATURE_AUD_NI_IDX Must be unique Asc/Asc/Asc REVISION_ID + HISTORY_CODE_ID + NAME

Relationships