Experiment

Describes the type of experiment, measurement technique and links to protocols used in the experiment.

Columns

Name	Type	Description	Foreign Key
experiment_accession	varchar(15)	Primary key
description	varchar(4000)	Free text to expand upon details
measurement_technique	varchar(50)	Standardized value in LK_EXP_MEASUREMENT_TECH table	lk_exp_measurement_tech.name
name	varchar(500)	Name or identifier
study_accession	varchar(15)	Foreign key reference to STUDY table	study.study_accession
workspace_id	int	Foreign key reference to WORKSPACE table	workspace.workspace_id

Indexes

Name	Column	Description
PRIMARY	experiment_accession	BTREE
idx_experiment_study	study_accession	BTREE
idx_experiment_workspace	workspace_id	BTREE
fk_experiment_2	measurement_technique	BTREE

Tables that Reference this Table

Name	Column	Table Reference	Column Reference
control_sample	experiment_accession	experiment	experiment_accession
elisa_result	experiment_accession	experiment	experiment_accession
elispot_result	experiment_accession	experiment	experiment_accession
experiment_2_protocol	experiment_accession	experiment	experiment_accession
expsample	experiment_accession	experiment	experiment_accession
fcs_analyzed_result	experiment_accession	experiment	experiment_accession
hai_result	experiment_accession	experiment	experiment_accession
hla_typing_result	experiment_accession	experiment	experiment_accession
kir_typing_result	experiment_accession	experiment	experiment_accession
mass_spectrometry_result	experiment_accession	experiment	experiment_accession
mbaa_result	experiment_accession	experiment	experiment_accession
neut_ab_titer_result	experiment_accession	experiment	experiment_accession
pcr_result	experiment_accession	experiment	experiment_accession
standard_curve	experiment_accession	experiment	experiment_accession