Tool Monitor Rules Table Schema (tool_monitor_rules)


Description

Table to store rules

tool_monitor_rules table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_monitor_subscriptions.ruleid toolmonisubs_rul2_fk R
description LONGTEXT 2147483647 √ null

Description of the rule
descriptionformat BIT 1 null

Description format
name VARCHAR 254

Name of the rule
userid BIGINT 19 null
user.id Implied Constraint R

Id of user who created the rule
courseid BIGINT 19 null
course.id Implied Constraint R

Id of course to which this rule belongs.
plugin VARCHAR 254

Frankenstlye name of the plguin
eventname VARCHAR 254

Fully qualified name of the event
template LONGTEXT 2147483647 null

Message template
templateformat BIT 1 null

Template format
frequency SMALLINT 5 null

Frequency
timewindow MEDIUMINT 7 null

Time window in seconds
timemodified BIGINT 19 null

Timestamp when this rule was last modified
timecreated BIGINT 19 null

Time stamp of when this rule was created

Table contained -1 rows

tool_monitor_rules table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolmonirule_couuse_ix Performance Asc/Asc courseid + userid
toolmonirule_eve_ix Performance Asc eventname

tool_monitor_rules table relationships

Close relationships within degrees of separation