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
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_cat4_ix Performance Asc categoryid
even_cou2_ix Performance Asc courseid
even_grocoucatvisuse2_ix Performance Asc/Asc/Asc/Asc/Asc groupid + courseid + categoryid + visible + userid
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