# 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 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_couuse_ix | Performance | Asc/Asc | courseid + userid
toolmonisubs_rul_ix | Performance | Asc | ruleid

### Relationships