Question Truefalse Table Schema (question_truefalse)


Description

Options for True-False questions

question_truefalse table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
question BIGINT 19 0
question.id questrue_que2_fk R

Foreign key references question.id.

trueanswer BIGINT 19 0

Foreign key references question_answers.id. The 'True' choice.

falseanswer BIGINT 19 0

Foreign key references question_answers.id. The 'False' choice.

Table contained -1 rows

question_truefalse table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
questrue_que_ix Performance Asc question

question_truefalse table relationships