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 |