question_attempts

0 rows


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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
question_attempt_steps.questionattemptid quesattestep_que2_fkR
questionusageid BIGINT 19 null
quiz_overview_regrades.questionusageid quizoverregr_queslo2_fkR
question_usages.id quesatte_que4_fkR

Foreign key, references question_usages.id

slot BIGINT 19 null
quiz_overview_regrades.slot quizoverregr_queslo2_fkR

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_fkR

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_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

Relationships