Question Hints Table Schema (question_hints)


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

question_hints table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
questionid BIGINT 19 null queshint_que2_fk R
hint LONGTEXT 2147483647 null

The text of the feedback to be given.

hintformat SMALLINT 5 0

The format of the hint.

shownumcorrect BIT 0 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 0 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.

Table contained -1 rows

question_hints table indexes

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

question_hints table relationships