Expsample_2_File_Info

Join table that associates EXPSAMPLE with FILE_INFO table records.

Columns
Name Type Description Foreign Key
expsample_accession varchar(15) Foreign key reference to EXPSAMPLE table expsample.expsample_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 expsample_accession BTREE
PRIMARY file_info_id BTREE
idx_expsample_2_file_info file_info_id BTREE
idx_expsample_2_file_info expsample_accession BTREE
fk_expsample_2_file_info_3 result_schema BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
Back to top