Events Queue Handlers Table Schema (events_queue_handlers)


Description

This is the list of queued handlers for processing. The event object is retrieved from the events_queue table. When no further reference is made to the event_queues table, the corresponding entry in the events_queue table should be deleted. Entry should get deleted after a successful event processing by the specified handler.

events_queue_handlers table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
queuedeventid BIGINT 19 null
events_queue.id evenqueuhand_que2_fk R

foreign key id corresponding to the id of the event_queues table
handlerid BIGINT 19 null
events_handlers.id evenqueuhand_han2_fk R

foreign key id corresponding to the id of the event_handlers table
status BIGINT 19 √ null

number of failed attempts to process this handler
errormessage LONGTEXT 2147483647 √ null

if an error happened last time we tried to process this event, record it here.
timemodified BIGINT 19 null

time stamp of the last attempt to run this from the queue

Table contained -1 rows

events_queue_handlers table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
evenqueuhand_han_ix Performance Asc handlerid
evenqueuhand_que_ix Performance Asc queuedeventid

events_queue_handlers table relationships

Close relationships within degrees of separation