Lab_Test

Laboratory process operating on a biological sample that produces a single value. Child of LAB TEST PANEL. Similar to EXPSAMPLE, but with a more clinical lab focus.

Columns
Name Type Description Foreign Key
lab_test_accession varchar(15) Primary key
biosample_accession varchar(15) Foreign key Reference to the BIOSAMPLE table biosample.biosample_accession
lab_test_panel_accession varchar(15) Foreign key reference to LAB_TEST_PANEL table lab_test_panel.lab_test_panel_accession
name_preferred varchar(40) Standardized name or idenitifier lk_lab_test_name.name
name_reported varchar(125) Name or identifier
reference_range_accession varchar(15) Foreign key reference to REFERENCE_RANGE table
result_unit_preferred varchar(40) Standardized value lk_unit_of_measure.name
result_unit_reported varchar(40) Reported value
result_value_preferred float Standardized value
result_value_reported varchar(250) Reported value
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Indexes
Name Column Description
PRIMARY lab_test_accession BTREE
idx_lab_test_biosample biosample_accession BTREE
idx_lab_test_workspace workspace_id BTREE
fk_lab_test_3 lab_test_panel_accession BTREE
fk_lab_test_4 name_preferred BTREE
fk_lab_test_5 result_unit_preferred BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
Back to top