Question Numerical Options Table Schema (question_numerical_options)


Options for questions of type numerical This table is also used by the calculated question type

question_numerical_options table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
question BIGINT 19 0 quesnumeopti_que2_fk R
showunits SMALLINT 5 0

How units are handled: 3) Not used at all, 0) Optional, or 1) must be right or penalty applied.

unitsleft SMALLINT 5 0

display the unit at left as in $1.00

unitgradingtype SMALLINT 5 0

0 no penalty, 1 fraction response grade, 2 fraction total grade

unitpenalty DECIMAL 12,7 0.1000000

Penalty for getting the unit wrong, when they are being graded.

Table contained -1 rows

question_numerical_options table indexes

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

question_numerical_options table relationships