question_numerical_units

0 rows


Description

Optional unit options for numerical questions. This table is also used by the calculated question type.

Columns

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

Foreign key references question.id

multiplier DECIMAL 38,19 1.0000000000000000000

The multiplier for this unit. For example, if the first unit is (1.0, 'cm'), another unit might be (0.1, 'mm') or (100.0, 'm').

unit VARCHAR 50

The unit. For example 'm' or 'kg'.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesnumeunit_que_ix Performance Asc question
quesnumeunit_queuni_uix Must be unique Asc/Asc question + unit

Relationships