Event Subscriptions Table Schema (event_subscriptions)


Description

Tracks subscriptions to remote calendars.

event_subscriptions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
event.subscriptionid even_sub2_fk R
url VARCHAR 255
categoryid BIGINT 19 0
courseid BIGINT 19 0
course.id Implied Constraint R
groupid BIGINT 19 0
userid BIGINT 19 0
user.id Implied Constraint R
eventtype VARCHAR 20

The type of the event
pollinterval BIGINT 19 0

Frequency of checks for new/changed events
lastupdated BIGINT 19 √ 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

Close relationships within degrees of separation