DTW_REG_GENERIC_DOMAIN


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_REG_GENERIC_DOMAIN_FT.DOMAIN_ID DTW_REG_GENERIC_DM_FT_ID_FK C

A unique identifier to registry generic domain
DOMAIN_TYPE VARCHAR 255 null

The id of the type associated with the limit
DOMAIN_ID VARCHAR 255 null

A unique identifier to foreign key to Registry System
DOMAIN_DESCRIPTION VARCHAR 255 null

A unique identifier to foreign key to Registry System
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_GENERIC_TYPE_ID_IDX Must be unique Asc/Asc DOMAIN_TYPE + DOMAIN_ID
DTW_REG_GENERIC_TYPE_IDX Performance Asc DOMAIN_TYPE

Relationships

Close relationships within degrees of separation