Event Table Schema (event)


For everything with a time associated to it

event table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
name longtext 2147483647 null
description longtext 2147483647 null
format smallint 4 0
courseid bigint 10 0
course.id Implied Constraint R
groupid bigint 10 0
userid bigint 10 0
user.id Implied Constraint R
repeatid bigint 10 0
modulename varchar 20
instance bigint 10 0
type smallint 4 0
eventtype varchar 20
timestart bigint 10 0
timeduration bigint 10 0
timesort bigint 10 null
visible smallint 4 1
uuid varchar 255
sequence bigint 10 1
timemodified bigint 10 0
subscriptionid bigint 10 null

The event_subscription id this event is associated with.

priority bigint 10 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.

Table contained -1 rows

event table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
even_cou_ix Performance Asc courseid
even_grocouvisuse_ix Performance Asc/Asc/Asc/Asc groupid + courseid + visible + userid
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

event table relationships