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