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 |