tool_monitor_subscriptions

0 rows


Description

Table to store user subscriptions to various rules

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
tool_monitor_history.sid toolmonihist_sid2_fkR
courseid BIGINT 19 null
course.id Implied ConstraintR

Course id of the subscription

ruleid BIGINT 19 null
tool_monitor_rules.id toolmonisubs_rul2_fkR

Rule id

cmid BIGINT 19 null

Course module id

userid BIGINT 19 null
user.id Implied ConstraintR

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

Indexes

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

Relationships