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
ruleid BIGINT 19 null
tool_monitor_rules.id toolmonisubs_rul2_fkR
cmid BIGINT 19 null
userid BIGINT 19 null
timecreated BIGINT 19 null
lastnotificationsent BIGINT 19 0
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_rul4_ix Performance Asc ruleid

Relationships

Close relationships within degrees of separation