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 |