Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| slotid | BIGINT | 19 | √ | null |
|
|
The quiz slot that this tag belong to |
|||
| tagid | BIGINT | 19 | √ | null |
|
|
||||
| tagname | VARCHAR | 255 | √ | null |
|
|
The tag name is to be stored as well, so we won’t lose data if the tag is removed from Moodle (A tag with the same name might be added in future). |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| quizslottags_slo2_ix | Performance | Asc | slotid |
| quizslottags_tag2_ix | Performance | Asc | tagid |
Relationships
Close relationships within degrees of separation
