analyte_determination_limits

38732 rows


Description

Analytes, detection limits (lower and upper) and reference standards for each analysis.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
limit_id serial 10 √ nextval('analyte_determination_limits_limit_id_seq'::regclass)
analyte_determination.limit_id analyte_determination_limit_analyte_determination_fk R

PK. Unique ID for each record describing the analyte determination limits for a each analyte in a batch. Generated by the database
analysis_id int4 10 null
analysis.analysis_id analysis_analyte_determination_limits_fk R

FK. ID for each analysis record. Links to analysis table.
detection_lower_limit numeric 15,8 √ null

From BGS: This column contains for each analyte the LOWEST level that can be reliably detected using the specified combination of laboratory, analysis method, sample preparation technique. The unit is assumed to be the same as the unit for the analysis.
detection_upper_limit numeric 15,8 √ null

From BGS: This column contains for each analyte the MAXIMUM level that can be reliably detected using the specified combination of laboratory, analysis method, sample preparation technique. The unit is assumed to be the same as the unit for the analysis.
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
analyte_code varchar 200 null
dic_analyte.analyte_code dic_analyte_analyte_determination_limits_fk R

FK. Analyte code. Link to dic_analyte
reference_standard varchar 250 √ null

Reference standard used for analyses, in particular isotopes e.g. VPDB

Indexes

Constraint Name Type Sort Column(s)
limit_id Primary key Asc limit_id
analyte_determination_limits_analyte_code_idx Performance Asc analyte_code
analyte_determination_limits_analyte_code_idx1 Performance Asc analyte_code

Relationships

Close relationships within degrees of separation