Question Numerical Table Schema (question_numerical)


Description

Options for numerical questions.

question_numerical table columns

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

Redundant, because of the answer field. Foreign key references question.id.

answer BIGINT 19 0

Foreign key references question_answers.id.

tolerance VARCHAR 255 0.0

Allowed error when matching a response to this answer. I don't know why this is stored as a string.

Table contained -1 rows

question_numerical table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesnume_ans_ix Performance Asc answer
quesnume_que_ix Performance Asc question

question_numerical table relationships