Qtype Match Options Table Schema (qtype_match_options)


Defines the question-type specific options for matching questions

qtype_match_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 link to question.id.

shuffleanswers SMALLINT 5 1
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_match_options table indexes

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

qtype_match_options table relationships