Event Table Schema (event)


Description

For everything with a time associated to it

event table 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_fk R
courseid BIGINT 19 0
course.id Implied Constraint R
groupid BIGINT 19 0
userid BIGINT 19 0
user.id Implied Constraint R
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_fk R

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

Table contained -1 rows

event table 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_modins_ix Performance Asc/Asc modulename + instance
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

event table relationships

Close relationships within degrees of separation