Protocol
Describes the methods and procedures in studies, experiments, and lab tests. Protocols may be of any file type.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| protocol_accession | varchar(15) | Primary key | |
| description | varchar(4000) | Free text to expand upon details | |
| file_name | varchar(250) | File name | |
| name | varchar(250) | Name or identifier | |
| original_file_name | varchar(250) | Original file name | |
| type | varchar(100) | Category | lk_protocol_type.name |
| workspace_id | int | Foreign key reference to WORKSPACE table | workspace.workspace_id |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | protocol_accession | BTREE |
| fk_protocol_1 | type | BTREE |
| fk_protocol_2 | workspace_id | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|
| experiment_2_protocol | protocol_accession | protocol | protocol_accession |
| lab_test_panel_2_protocol | protocol_accession | protocol | protocol_accession |
| study_2_protocol | protocol_accession | protocol | protocol_accession |