DTW_CTR_BUNDLE


Description

Store bundle information and all entries related to it

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_CTR_COMPENSATING_BUNDLE.BUNDLE_ID DTW_CTR_COMPENSAT_BUNDLE_E_FK C
DTW_CTR_COMPENSATING_BUNDLE_ENTRY.BUNDLE_ID DTW_CTR_COMPENSATING_BUNDLE_ENTRY_B_FK C
DTW_CTR_INTENT_BUNDLE_REL.BUNDLE_ID DTW_CTR_INTENT_BDL_REL_BDL_FK C
DTW_CTR_MONITORING_RELEASE_BDL.BUNDLE_ID DTW_CTR_MON_RELEASE_BDL_B_FK C

The Bundle id
TYPE VARCHAR 32 null

Holds the underlying bundle type
ORIGINATOR VARCHAR 64 null

What system has originally created this entry batch
CORRELATION_ID VARCHAR 128 √ null
STATE VARCHAR 36 null

The state of the bundle
ACCOUNTS JSON 1073741824 null

Holds a json object storing the underlying entries
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the bundle was created
UPDATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the bundle was lastly updated
VERSION CHAR 36 00000000-0000-0000-0000-000000000000

The version of the given bundle (upon each update, it changes)
PHASE VARCHAR 36 √ UNKNOWN

The bundle phase was processed
COMPENSATION_KEY CHAR 36 √ 00000000-0000-0000-0000-000000000000

The compensation key of the given bundle

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_CTR_BUNDLE_CORR_ID_IDX Must be unique Asc/Asc ORIGINATOR + CORRELATION_ID

Relationships

Close relationships within degrees of separation