Lab_Test_Panel
A collection of LAB_TESTs. Similar to an EXPERIMENT, but with a clinical assay focus.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| lab_test_panel_accession | varchar(15) | Primary key | |
| name_preferred | varchar(125) | Standardized name or idenitifier | |
| name_reported | varchar(125) | Name or identifier | |
| study_accession | varchar(15) | Foreign key reference to the STUDY table | study.study_accession |
| workspace_id | int | Foreign key reference to WORKSPACE table | workspace.workspace_id |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | lab_test_panel_accession | BTREE |
| idx_lab_test_panel_study | study_accession | BTREE |
| fk_lab_test_panel_1 | workspace_id | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|
| lab_test | lab_test_panel_accession | lab_test_panel | lab_test_panel_accession |
| lab_test_panel_2_protocol | lab_test_panel_accession | lab_test_panel | lab_test_panel_accession |