analysis

2639 rows


Description

Analysis details for a batch i.e. preparation, experimental and analytical methods, who ran the analysis and/or provided the data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
analysis_id serial 10 √ nextval('analysis_analysis_id_seq'::regclass)
analyte_determination_limits.analysis_id analysis_analyte_determination_limits_fkR

PK. Unique ID for each analysis record for each batch. Generated by database.
prep_id int4 10 √ null
dic_prep_method.prep_id dic_prep_method_analysis_fkR

FK. ID for each preparation method e.g. Tungsten carbide shatterbox. Links to the dic_prep_method table.
exp_method_id int4 10 √ null
dic_exp_method.exp_method_id dic_exp_method_analysis_fkR

FK. ID for each experimental method used e.g. Treated with HCl. Links to the dic_exp_method table.
ana_method_id int4 10 √ null
dic_ana_method.ana_method_id dic_analysis_method_analysis_fkR

FK. ID for each analytical method used e.g. ICP:MS. Links to the dic_ana_method table.
batch_id int4 10 null
batch.batch_id batch_analysis_fkR

FK. Identifier for the batch. Links to the batch table
analysis_notes varchar 4000 √ null

Detailed description of the analysis. Often cut-and-paste from the methods section for published data.
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
lab_method_code varchar 100 √ null

Laboratory-specific code for the analysis, usually from a commercial lab e.g. MA200 from Bureau Veritas
run_by int4 10 √ null
person.person_id person_analysis_fkR

FK. The person who ran the experiment (note: sample preparation may have been done by someone else). Links to person table.
provided_by int4 10 √ null
person.person_id person_analysis_fk_1R

The person who provided the data - they may or may not have run the analysis themselves. Primarily used to track the provenance of unpublished results. Links to person table.

Indexes

Constraint Name Type Sort Column(s)
analysis_id Primary key Asc analysis_id
analysis_ana_method_id_idx Performance Asc ana_method_id
analysis_exp_method_id_idx Performance Asc exp_method_id
analysis_prep_id_idx Performance Asc prep_id

Relationships

Close relationships within degrees of separation