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