DTW_TR_MONITORING_PROCESS_REL


Description

Holds the monitoring related process

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_TR_MONITORING_PROCESS_REL_ENTRIES.MONITORING_PROCESS_ID DTW_TR_MONITORING_PROCESS_REL_ID_FK R

Identifies the monitoring related process
MONITORING_ID CHAR 36 null
DTW_TR_INTENT.ID DTW_TR_MON_REL_MON_INT_FK R

Identifies the intent associated with this monitoring
CURRENCY CHAR 3 null

The currency on which the amount of the underlying monitoring related process is expressed
AMOUNT DECIMAL 19 null

The value of the monitoring related process
TYPE VARCHAR 32 null
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the monitoring related process was created
UPDATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the monitoring related process was lastly updated

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TR_MON_PROC_REL_MID_IDX Performance Asc MONITORING_ID
DTW_TR_MON_PROC_REL_MID_TYPE_IDX Performance Asc/Asc MONITORING_ID + TYPE

Relationships

Close relationships within degrees of separation