Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| queuedeventid | BIGINT | 19 | null |
|
|
foreign key id corresponding to the id of the event_queues table |
||||
| handlerid | BIGINT | 19 | null |
|
|
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 |