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	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