Tool Monitor Subscriptions Table Schema (tool_monitor_subscriptions)


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 Implied Constraint R

Course id of the subscription

ruleid BIGINT 19 null toolmonisubs_rul2_fk R

Rule id

cmid BIGINT 19 null

Course module id

userid BIGINT 19 null 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