qtype_match_options

0 rows


Description

Defines the question-type specific options for matching questions

Columns

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

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.

Indexes

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

Relationships