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
Back to top