Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| name | LONGTEXT | 2147483647 | null |
|
|
|||||
| description | LONGTEXT | 2147483647 | null |
|
|
|||||
| format | SMALLINT | 5 | 0 |
|
|
|||||
| categoryid | BIGINT | 19 | 0 |
|
|
|||||
| courseid | BIGINT | 19 | 0 |
|
|
|||||
| groupid | BIGINT | 19 | 0 |
|
|
|||||
| userid | BIGINT | 19 | 0 |
|
|
|||||
| repeatid | BIGINT | 19 | 0 |
|
|
|||||
| component | VARCHAR | 100 | √ | null |
|
|
Component that created this event, if specified, only component itself can edit and delete it |
|||
| modulename | VARCHAR | 20 |
|
|
||||||
| instance | BIGINT | 19 | 0 |
|
|
|||||
| type | SMALLINT | 5 | 0 |
|
|
|||||
| eventtype | VARCHAR | 20 |
|
|
||||||
| timestart | BIGINT | 19 | 0 |
|
|
|||||
| timeduration | BIGINT | 19 | 0 |
|
|
|||||
| timesort | BIGINT | 19 | √ | null |
|
|
||||
| visible | SMALLINT | 5 | 1 |
|
|
|||||
| uuid | VARCHAR | 255 |
|
|
||||||
| sequence | BIGINT | 19 | 1 |
|
|
|||||
| timemodified | BIGINT | 19 | 0 |
|
|
|||||
| subscriptionid | BIGINT | 19 | √ | null |
|
|
The event_subscription id this event is associated with. |
|||
| priority | BIGINT | 19 | √ | null |
|
|
The event's display priority. For multiple events with the same module name, instance and eventtype (e.g. for group overrides), the one with the higher priority will be displayed. |
|||
| location | LONGTEXT | 2147483647 | √ | null |
|
|
Event Location |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| even_cat4_ix | Performance | Asc | categoryid |
| even_comeveins2_ix | Performance | Asc/Asc/Asc | component + eventtype + instance |
| even_cou2_ix | Performance | Asc | courseid |
| even_eve2_ix | Performance | Asc | eventtype |
| even_grocoucatvisuse2_ix | Performance | Asc/Asc/Asc/Asc/Asc | groupid + courseid + categoryid + visible + userid |
| even_modinseve2_ix | Performance | Asc/Asc/Asc | modulename + instance + eventtype |
| even_sub4_ix | Performance | Asc | subscriptionid |
| even_tim3_ix | Performance | Asc | timestart |
| even_tim4_ix | Performance | Asc | timeduration |
| even_typtim2_ix | Performance | Asc/Asc | type + timesort |
| even_use2_ix | Performance | Asc | userid |
| even_uui2_ix | Performance | Asc | uuid |
Relationships
Close relationships within degrees of separation
