Standard_Curve

A STANDARD_CURVE is defined for each analyte in a batch (e.g., on a single plate)

Columns
Name Type Description Foreign Key
standard_curve_accession varchar(15) Primary key
analyte_accession varchar(15) Foreign key reference to LK_ANALYTE lk_analyte.analyte_accession
analyte_preferred varchar(100) Preferred analyte name
analyte_reported varchar(100) Reported analyte name
assay_group_id varchar(100) Associates this result with a set of results that may come from a group of plates or chips
assay_id varchar(100) Associates this result with a set of results that come from the same plate or chip. A plate may have results for experiment sample, control sample, standard curve
experiment_accession varchar(15) Foreign key reference to the EXPERIMENT table experiment.experiment_accession
formula varchar(500) Formula for defining the standard curve
lower_limit varchar(100) Lower boundary for the reference range value
lower_limit_unit varchar(100) The unit (e.g., pg/ml) of the lower limit of detection value
result_schema varchar(50) Standardized value in LK_RESULT_SCHEMA lk_expsample_result_schema.name
upload_result_status varchar(20) Upload result status
upper_limit varchar(100) Upper boundary for the reference range value
upper_limit_unit varchar(100) The unit (e.g., pg/ml) of the upper limit of detection value
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Indexes
Name Column Description
PRIMARY standard_curve_accession BTREE
fk_standard_curve_1 workspace_id BTREE
fk_standard_curve_2 experiment_accession BTREE
fk_standard_curve_3 result_schema BTREE
fk_standard_curve_4 analyte_accession BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
standard_curve_2_file_info standard_curve_accession standard_curve standard_curve_accession
Back to top