DTW_TR_HOLD_REASON


Description

Holds the available hold reason codes for entry

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID VARCHAR 64 null
DTW_TR_BLOCKING_RELATED_ENTRY.HOLD_REASON_ID DTW_TR_BLOCKING_REL_ENT_HID_FK C
DTW_TR_HOLD_REASON_FEATURE.HOLD_REASON_ID DTW_TR_HOLD_REASON_FT_ID_FK C

Unique Identifier for hold reason
DESCRIPTION VARCHAR 256 null

Represents the hold reason description
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the hold reason was created within the digital twin
UPDATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the hold reason was lastly updated
PRIORITY TINYINT 3 null

The priority of the given hold reason

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TR_HOLD_REASON_PRI_IDX Performance Asc PRIORITY

Relationships

Close relationships within degrees of separation