Event Subscriptions Table Schema (event_subscriptions)


Tracks subscriptions to remote calendars.

event_subscriptions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
url varchar 255
courseid bigint 10 0
course.id Implied Constraint R
groupid bigint 10 0
userid bigint 10 0
user.id Implied Constraint R
eventtype varchar 20

The type of the event

pollinterval bigint 10 0

Frequency of checks for new/changed events

lastupdated bigint 10 null
name varchar 255

Table contained -1 rows

event_subscriptions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

event_subscriptions table relationships