question_set_references

0 rows


Description

Records where groups of questions are used.

Columns

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

Context where question is used.

component VARCHAR 100 null

Component (e.g. mod_quiz)

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.

questionscontextid BIGINT 19 0
context.id quessetrefe_que2_fkR

Context questions come from.

filtercondition LONGTEXT 2147483647 null

Filter expression in json format

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quessetrefe_que2_ix Performance Asc questionscontextid
quessetrefe_usi2_ix Performance Asc usingcontextid
quessetrefe_usicomqueite2_uix Must be unique Asc/Asc/Asc/Asc usingcontextid + component + questionarea + itemid

Relationships