Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||||
| questionusageid | BIGINT | 19 | null |
|
|
Foreign key, references question_usages.id |
||||||
| slot | BIGINT | 19 | null |
|
|
Used to number the questions in one attempt sequentially. |
||||||
| behaviour | VARCHAR | 32 |
|
|
The name of the question behaviour that is managing this question attempt. |
|||||||
| questionid | BIGINT | 19 | null |
|
|
The id of the question being attempted. Foreign key references question.id. |
||||||
| variant | BIGINT | 19 | 1 |
|
|
The variant of the qusetion being used. |
||||||
| maxmark | DECIMAL | 12,7 | null |
|
|
The grade this question is marked out of in this attempt. |
||||||
| minfraction | DECIMAL | 12,7 | null |
|
|
Some questions can award negative marks. This indicates the most negative mark that can be awarded, on the faction scale where the maximum positive mark is 1. |
||||||
| maxfraction | DECIMAL | 12,7 | 1.0000000 |
|
|
Some questions can give fractions greater than 1. This indicates the greatest fraction that can be awarded. |
||||||
| flagged | BIT | 1 | 0 |
|
|
Whether this question has been flagged within the attempt. |
||||||
| questionsummary | LONGTEXT | 2147483647 | √ | null |
|
|
If this question uses randomisation, it should set this field to summarise what random version the student actually saw. This is a human-readable textual summary of the student’s response which might, for example, be used in a report. |
|||||
| rightanswer | LONGTEXT | 2147483647 | √ | null |
|
|
This is a human-readable textual summary of the right answer to this question. Might be used, for example on the quiz preview, to help people who are testing the question. Or might be used in reports. |
|||||
| responsesummary | LONGTEXT | 2147483647 | √ | null |
|
|
This is a textual summary of the student’s response (basically what you would expect to in the Quiz responses report). |
|||||
| timemodified | BIGINT | 19 | null |
|
|
The time this record was last changed. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| quesatte_beh2_ix | Performance | Asc | behaviour |
| quesatte_que3_ix | Performance | Asc | questionid |
| quesatte_que4_ix | Performance | Asc | questionusageid |
| quesatte_queslo2_uix | Must be unique | Asc/Asc | questionusageid + slot |
Relationships
Close relationships within degrees of separation
