question_numerical_options

0 rows


Description

Options for questions of type numerical This table is also u

Columns

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

Indexes

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

Relationships