Control sample 2 file info

Join table that associates CONTROL_SAMPLE with FILE_INFO table records.

Columns

Name	Type	Description	Foreign Key
control_sample_accession	varchar(15)	Foreign key reference to CONTROL_SAMPLE table	control_sample.control_sample_accession
file_info_id	int(11)	Foreign key reference to FILE_INFO table	file_info.file_info_id
result_schema	varchar(50)	Standardized value in LK_RESULT_SCHEMA	lk_expsample_result_schema.name

Indexes

Name	Column	Description
PRIMARY	control_sample_accession	BTREE
PRIMARY	file_info_id	BTREE
idx_control_sample_2_file_info	file_info_id	BTREE
idx_control_sample_2_file_info	control_sample_accession	BTREE
fk_control_sample_2_file_info_3	result_schema	BTREE

Tables that Reference this Table

Name	Column	Table Reference	Column Reference