# event

0 rows

### Description

For everything with a time associated to it

### 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 |  |
course_categories.id | even_cat2_fkR
courseid | BIGINT | 19 |  |  | 0 |  |
course.id | Implied ConstraintR
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 |  |
event_subscriptions.id | even_sub2_fkR
| 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_cat_ix | Performance | Asc | categoryid
even_comeveins_ix | Performance | Asc/Asc/Asc | component + eventtype + instance
even_cou_ix | Performance | Asc | courseid
even_eve_ix | Performance | Asc | eventtype
even_grocoucatvisuse_ix | Performance | Asc/Asc/Asc/Asc/Asc | groupid + courseid + categoryid + visible + userid
even_modinseve_ix | Performance | Asc/Asc/Asc | modulename + instance + eventtype
even_sub_ix | Performance | Asc | subscriptionid
even_tim2_ix | Performance | Asc | timeduration
even_tim_ix | Performance | Asc | timestart
even_typtim_ix | Performance | Asc/Asc | type + timesort
even_use_ix | Performance | Asc | userid
even_uui_ix | Performance | Asc | uuid

### Relationships