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