# 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