| 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. |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| quesatte_beh_ix | Performance | Asc | behaviour |
| quesatte_que2_ix | Performance | Asc | questionusageid |
| quesatte_que_ix | Performance | Asc | questionid |
| quesatte_queslo_uix | Must be unique | Asc/Asc | questionusageid + slot |