DTW_TR_EVENT_ROUTING


Description

Holds event routing

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_TR_EVENT_ROUTING_DATA.EVENT_ROUTING_ID DTW_TR_EVENT_ROUTING_DATA_FK C

The event routing entry id

EVENT_ID CHAR 36 null

The id of the event was routed

EVENT_SOURCE VARCHAR 64 null

The source of the event that was routed

EVENT_KIND VARCHAR 64 null

The kind of the event that was routed

CREATED_AT DATETIME 26 null

When the event routing entry was created

AGGREGATE_TYPE VARCHAR 32 null

The aggregate type associated with the event that was routed

AGGREGATE_KEY VARCHAR 64 null

The aggregate key associated with the event that was routed

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TR_EVENT_ROUTING_AGG_IDX Performance Asc/Asc AGGREGATE_TYPE + AGGREGATE_KEY
DTW_TR_EVENT_ROUTING_EVT_IDX Must be unique Asc/Asc EVENT_ID + EVENT_SOURCE
DTW_TR_EVENT_ROUTING_KDN_IDX Performance Asc EVENT_KIND

Relationships