Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| quizid | BIGINT | 19 | 0 |
|
|
Foreign key references quiz.id. |
||||
| feedbacktext | LONGTEXT | 2147483647 | null |
|
|
The feedback to show for a attempt where mingrade <= attempt grade < maxgrade. See function quiz_feedback_for_grade in mod/quiz/locallib.php. |
||||
| feedbacktextformat | TINYINT | 3 | 0 |
|
|
|||||
| mingrade | DECIMAL | 10,5 | 0.00000 |
|
|
The lower limit of this grade band. Inclusive. |
||||
| maxgrade | DECIMAL | 10,5 | 0.00000 |
|
|
The upper limit of this grade band. Exclusive. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| quizfeed_qui_ix | Performance | Asc | quizid |