| analyte_det_id |
serial |
10 |
|
√ |
nextval('analyte_determination_analyte_det_id_seq'::regclass) |
|
|
PK. Unique ID for each analytical result. Generated by database. |
| determination_unit |
varchar |
10 |
√ |
|
null |
|
|
The unit of the measured result e.g. wtpct, ppm, permil. |
| batch_id |
int4 |
10 |
|
|
null |
|
| batch_sample.batch_id |
batch_sample_analyte_determination_fkR |
|
FK. ID for a batch. Links to the batch_sample table. |
| limit_id |
int4 |
10 |
√ |
|
null |
|
|
FK. ID for analyte_code and determination upper and lower limits. Links to the analyte_determination_limits table. |
| abundance |
numeric |
17,9 |
√ |
|
null |
|
|
Measured result |
| result_notes |
varchar |
4000 |
√ |
|
null |
|
|
Notes about the result |
| sample_id |
int4 |
10 |
|
|
null |
|
| batch_sample.sample_id |
batch_sample_analyte_determination_fkR |
|
FK. ID of the sample. Links to the batch_sample table. |
| timestamp_created |
timestamptz |
35,6 |
|
|
now() |
|
|
|
| timestamp_modified |
timestamptz |
35,6 |
√ |
|
now() |
|
|
|
| is_below_detection |
bool |
1 |
√ |
|
false |
|
|
Whether the result was below the detection limit (see analyte_determination_limit.lower_detection_limit). Note constraint: abundance can only be empty when the result was below or above detection. |
