Tool Monitor Rules Table Schema (tool_monitor_rules)


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

Id of user who created the rule

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


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