Question Attempts Table Schema (question_attempts)


Description

Each row here corresponds to an attempt at one question, as part of a question_usage. A question_attempt will have some question_attempt_steps

question_attempts table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
question_attempt_steps.questionattemptid quesattestep_que2_fk R
questionusageid BIGINT 19 null
question_usages.id quesatte_que4_fk R

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
question.id quesatte_que3_fk R

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.

Table contained -1 rows

question_attempts table indexes

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

question_attempts table relationships

Close relationships within degrees of separation