question_usages

0 rows


Description

This table’s main purpose it to assign a unique id to each attempt at a set of questions by some part of Moodle. A question usage is made up of a number of question_attempts.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
question_attempts.questionusageid quesatte_que4_fkR
quiz_attempts.uniqueid quizatte_uni_fkR
contextid BIGINT 19 null
context.id quesusag_con2_fkR

Every question usage must be associated with some context.

component VARCHAR 255

The plugin this attempt belongs to, e.g. ‘mod_quiz’, ‘block_questionoftheday’, ‘filter_embedquestion’.

preferredbehaviour VARCHAR 32

The archetypal behaviour that should be used for question attempts in this usage.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesusag_con_ix Performance Asc contextid

Relationships