Assessment_2_File_Info

Join table that associates ASSESEMENT_PANEL with FILE_INFO table records.

Columns

Name	Type	Description	Foreign Key
assessment_panel_accession	varchar(15)	Foreign key reference to ASSESSMENT_PANEL table	assessment_panel.assessment_panel_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	assessment_panel_accession	BTREE
PRIMARY	file_info_id	BTREE
idx_assessment_2_file_info	file_info_id	BTREE
idx_assessment_2_file_info	assessment_panel_accession	BTREE
fk_assessment_2_file_info_4	result_schema	BTREE

Tables that Reference this Table

Name	Column	Table Reference	Column Reference