DTW_TR_INTENT


Description

Holds assorted intents

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_TR_ACCOUNT_BASED_INTENT.INTENT_ID DTW_TR_INTENT_ACC_REL_INT_FK C
DTW_TR_ACTIVE_MONITORING.MONITORING_ID DTW_TR_ACTIVE_MONITORING_FK C
DTW_TR_INTENT_BLUEPRINT.INTENT_ID DTW_TR_INTENT_BLUEPRINT_INT_FK C
DTW_TR_INTENT_ENTRY_REL.INTENT_ID DTW_TR_INTENT_ENTRY_REL_INT_FK C
DTW_TR_INTENT_ENTRY_TRIGGER.INTENT_ID DTW_TR_INTENT_TRIGGER_INT_FK C
DTW_TR_INTENT_EXCLUSION.INTENT_ID DTW_TR_INTENT_EXCLUSION_I_FK C
DTW_TR_INTENT_METADATA.INTENT_ID DTW_TR_INTENT_METADATA_INT_FK C
DTW_TR_MONITORING_BALANCE_REL.MONITORING_ID DTW_TR_MON_BALANCES_REL_MON_FK C
DTW_TR_MONITORING_PROCESS_REL.MONITORING_ID DTW_TR_MON_REL_MON_INT_FK R
DTW_TR_MONITORING_RELEASE.MONITORING_ID DTW_TR_MON_REL_MONITORING_FK R

Identifies the intent
TYPE VARCHAR 32 null

Holds the type of the intent (possible values: ENTRY_EXCLUSION)
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

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

When the intent was lastly updated
DUE_AT DATETIME 26 null

When the intent was will be due
ORIGINATOR VARCHAR 64 null

By whom the intent was created
STATUS VARCHAR 36 null

The intent status
VERSION INT 10 √ 0

Holds the version of the given intent
CHANNEL VARCHAR 36 UNDEFINED

The intent input application channel

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TR_INTENT_CREATED_AT_IDX Performance Asc CREATED_AT
DTW_TR_INTENT_DUE_AT_IDX Performance Asc DUE_AT
DTW_TR_INTENT_STATUS_IDX Performance Asc STATUS
DTW_TR_INTENT_STATUS_TYPE_IDX Performance Asc/Asc STATUS + TYPE
DTW_TR_INTENT_TYPE_IDX Performance Asc TYPE

Relationships

Close relationships within degrees of separation