question_numerical

0 rows


Description

Options for numerical questions.

Columns

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

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.

Indexes

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

Relationships