# tool_monitor_rules

0 rows

### Description

Table to store rules

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
tool_monitor_subscriptions.ruleid | toolmonisubs_rul2_fkR
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 |  |  | Id of user who created the rule
courseid | BIGINT | 19 |  |  | null |  |
course.id | Implied ConstraintR
| 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

### 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

### Relationships