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(11) 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
Back to top