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(50)	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(50)	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	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