DTW_TR_ENTRY_FULFILLMENT


Description

Holds the relationship between a pending entry and its fulfillment

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PENDING_ENTRY_ID CHAR 36 null
DTW_TR_ENTRY.ID DTW_TR_ENTRY_FLMNT_PRM_FK R

The id of the pending entry
FULFILLED_ENTRY_ID CHAR 36 null
DTW_TR_ENTRY.ID DTW_TR_ENTRY_FLMNT_FLM_FK C

The entry that fulfilled the associated entry promise
ACTIVE BIT 1 √ null

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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc PENDING_ENTRY_ID
DTW_TR_ENTRY_FLMNT_FID_IDX Must be unique Asc FULFILLED_ENTRY_ID
DTW_TR_ENTRY_FLMNT_NID_IDX Must be unique Asc/Asc PENDING_ENTRY_ID + ACTIVE

Relationships

Close relationships within degrees of separation