# 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