Question Ddwtos Table Schema (question_ddwtos)


Description

Defines drag and drop (words into sentences) questions

question_ddwtos table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
questionid BIGINT 19 0
question.id quesddwt_que2_fk R
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

Table contained -1 rows

question_ddwtos table indexes

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

question_ddwtos table relationships