DTW_CTR_COMPENSATING_BUNDLE


Description

Holds the compensating bundle (e.g., regular, removal, and etc)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
BUNDLE_ID CHAR 36 null
DTW_CTR_BUNDLE.ID DTW_CTR_COMPENSAT_BUNDLE_E_FK C

The associated bundle ID
COMPENSATING_BUNDLE_ID CHAR 36 null

The compensating bundle reference ID
ACTIVE TINYINT 3 √ null

Marks if a given compensating reference is active (if not active, null is stored)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc BUNDLE_ID
DTW_CTR_COMPENSATING_REF_E_IDX Must be unique Asc/Asc COMPENSATING_BUNDLE_ID + ACTIVE

Relationships

Close relationships within degrees of separation