Treatment

Action applied to a sample ex vivo by an agent (e.g. a compound), a temperature change, and or a duration of some action (e.g. a time course).

Columns
Name Type Description Foreign Key
treatment_accession varchar(15) Primary key
amount_unit varchar(50) Standardized unit in the LK_UNIT_OF_MEASURE table lk_unit_of_measure.name
amount_value varchar(50) Reported amount of the treatment agent
comments varchar(500) Free text to expand upon details
duration_unit varchar(50) Standardized value in LK_TIME_UNIT table lk_time_unit.name
duration_value varchar(200) Reported duration of the treatment agent
name varchar(100) Name or identifier
temperature_unit varchar(50) Standardized value in LK_UNIT_OF_MEASURE lk_unit_of_measure.name
temperature_value varchar(50) Reported value
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Indexes
Name Column Description
PRIMARY treatment_accession BTREE
idx_treatment_workspace workspace_id BTREE
fk_treatment_2 amount_unit BTREE
fk_treatment_3 duration_unit BTREE
fk_treatment_4 temperature_unit BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
biosample_2_treatment treatment_accession treatment treatment_accession
expsample_2_treatment treatment_accession treatment treatment_accession
Back to top