question_references

0 rows


Description

Records where a specific question is used.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
usingcontextid BIGINT 19 0
context.id quesrefe_usi2_fkR

Context where question is used.

component VARCHAR 100 null

Component (e.g. mod_quiz or core_question)

questionarea VARCHAR 50 null

Depending on the component, which area the question is used in (e.g. slot for quiz).

itemid BIGINT 19 null

Plugin specific id (e.g. slotid for quiz) where its used.

questionbankentryid BIGINT 19 0
question_bank_entries.id quesrefe_que2_fkR

ID of the question bank entry this question is part of.

version BIGINT 19 null

Version number for the question where NULL means use the latest non-draft version.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesrefe_que_ix Performance Asc questionbankentryid
quesrefe_usi_ix Performance Asc usingcontextid
quesrefe_usicomqueite_uix Must be unique Asc/Asc/Asc/Asc usingcontextid + component + questionarea + itemid

Relationships