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(11) Primary key
detail varchar(100) Standardized value in LK_FILE_DETAIL table lk_file_detail.name
filesize_bytes int(11) File size
name varchar(250) Name or identifier
original_file_name varchar(250) Original file name
workspace_id int(11) 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
Back to top