Question Numerical Units Table Schema (question_numerical_units)


Description

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

question_numerical_units table columns

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

Foreign key references question.id
multiplier DECIMAL 40,20 1.00000000000000000000

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'.

Table contained -1 rows

question_numerical_units table 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

question_numerical_units table relationships

Close relationships within degrees of separation