Tool Monitor Subscriptions Table Schema (tool_monitor_subscriptions)


Description

Table to store user subscriptions to various rules

tool_monitor_subscriptions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_monitor_history.sid toolmonihist_sid2_fk R
courseid BIGINT 19 null
course.id Implied Constraint R

Course id of the subscription
ruleid BIGINT 19 null
tool_monitor_rules.id toolmonisubs_rul2_fk R

Rule id
cmid BIGINT 19 null

Course module id
userid BIGINT 19 null
user.id Implied Constraint R

User id of the subscriber
timecreated BIGINT 19 null

Timestamp of when this subscription was created
lastnotificationsent BIGINT 19 0

Timestamp of the time when a notification was last sent for this subscription.
inactivedate BIGINT 19 0

Table contained -1 rows

tool_monitor_subscriptions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolmonisubs_couuse_ix Performance Asc/Asc courseid + userid
toolmonisubs_rul_ix Performance Asc ruleid

tool_monitor_subscriptions table relationships

Close relationships within degrees of separation