Columns
| Column | Type | Size | Nulls | Auto | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|
| analysis_numerical_value_id | int8 | 19 | √ |
|
|
Primary key (automatically incremented). |
||||
| analysis_value_id | int8 | 19 |
|
|
Identifies the specific analysis value associated with this data. |
|||||
| qualifier | text | 2147483647 | √ |
|
|
Additional information qualifying the value. |
||||
| value | numeric(20,10) | 20,10 | √ |
|
|
The analysed value interpretated as a numerical (decimal) value. |
||||
| is_variant | bool | 1 | √ |
|
|
Indicates if value is an alternative interpretation of analysed value. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_analysis_numerical_values_pkey | Primary key | Asc | analysis_numerical_value_id |

