Qtype Randomsamatch Options Table Schema (qtype_randomsamatch_options)


Info about a random short-answer matching question

qtype_randomsamatch_options table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
questionid BIGINT 19 0
question.id Implied Constraint R

Foreign key references question.id.

choose BIGINT 19 4

Number of subquestions to randomly generate.

subcats TINYINT 3 1

Whether to include or not the subcategories.

correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

correctfeedbackformat TINYINT 3 0
partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

partiallycorrectfeedbackformat TINYINT 3 0
incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

incorrectfeedbackformat TINYINT 3 0
shownumcorrect TINYINT 3 0

If true, then when the user gets the question partially correct, tell them how many choices they got correct alongside the feedback.

Table contained -1 rows

qtype_randomsamatch_options table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
qtyprandopti_que_uix Must be unique Asc questionid

qtype_randomsamatch_options table relationships