events_queue_handlers

0 rows


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.

Columns

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

foreign key id corresponding to the id of the event_queues table

handlerid BIGINT 19 null
events_handlers.id evenqueuhand_han2_fkR

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

Indexes

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

Relationships