File_Info

Contains metadata and content for result files, template files, and other files archived to workspaces.

Columns

Name	Type	Description	Foreign Key
file_info_id	int	Primary key
detail	varchar(100)	Standardized value in LK_FILE_DETAIL table	lk_file_detail.name
filesize_bytes	bigint	File size
name	varchar(250)	Name or identifier
original_file_name	varchar(250)	Original file name
workspace_id	int	Foreign key reference to WORKSPACE table	workspace.workspace_id

Indexes

Name	Column	Description
PRIMARY	file_info_id	BTREE
idx_file_info_workspace	workspace_id	BTREE
fk_file_info_2	detail	BTREE

Tables that Reference this Table

Name	Column	Table Reference	Column Reference
assessment_2_file_info	file_info_id	file_info	file_info_id
control_sample_2_file_info	file_info_id	file_info	file_info_id
expsample_2_file_info	file_info_id	file_info	file_info_id
fcs_analyzed_result	workspace_file_info_id	file_info	file_info_id
fcs_header	file_info_id	file_info	file_info_id
standard_curve_2_file_info	file_info_id	file_info	file_info_id