DTW_REG_GENERIC_DOMAIN_FT


Description

Holds the generic domain code features

Columns

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

The feature ID

DOMAIN_ID CHAR 36 null
DTW_REG_GENERIC_DOMAIN.ID DTW_REG_GENERIC_DM_FT_ID_FK C

The domain 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

CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

The feature creation time

UPDATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

The feature updated time

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_REG_GENERIC_DM_FT_ID_IDX Performance Asc DOMAIN_ID
DTW_REG_GENERIC_DM_FT_NID_IDX Performance Asc/Asc DOMAIN_ID + NAME

Relationships