# question_hints

0 rows

### Description

Stores the the part of the question definition that gives different feedback after each try in interactive and similar behaviours.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
questionid | BIGINT | 19 |  |  | null |  |
question.id | queshint_que2_fkR
hint | LONGTEXT | 2147483647 |  |  | null |  |  | The text of the feedback to be given.
hintformat | SMALLINT | 5 |  |  | 0 |  |  | The format of the hint.
shownumcorrect | BIT | 1 | √ |  | null |  |  | Whether the feedback should include a message about how many things the student got right. This is only applicable to certain question types (for example matching or multiple choice multiple-response).
clearwrong | BIT | 1 | √ |  | null |  |  | Whether any wrong choices should be cleared before the next try. Whether this is applicable, and what it means, depends on the question type, as with the shownumright option.
options | VARCHAR | 255 | √ |  | null |  |  | A space for any other question-type specific options.

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
queshint_que_ix | Performance | Asc | questionid

### Relationships