0 rows


Records where a specific question is used.


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
usingcontextid BIGINT 19 0 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 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 ready version.


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