File_Details
Contains metadata and content for files, template files, and other files archived to workspaces.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| file_details_id | int | Primary key | |
| reported_md5 | varchar(32) | md5 value reported by submitter | |
| generated_md5 | varchar(32) | md5 value generated by ImmPort | |
| study_accession | varchar(15) | Reference to the STUDY table | study.study_accession |
| filesize_bytes | bigint | File size in bytes | |
| file_type | varchar(250) | Type of file | |
| file_accession | varchar(250) | ImmPort file accession | |
| file_name | varchar(250) | Name of the file | |
| path | varchar(4000) | Path to the location of the file in the file directories | |
| date_file_updated | datetime | The Date the file was last updated | |
| ai_generated_keywords | varchar(4000) | Study file Keywords generated by AI | |
| ai_generated_summary | varchar(4000) | Study file summary generated by AI | |
| file_uuid | varchar(36) | UUID generated by ImmPort | |
| drs_object_created | varchar(1) | Flag indicating DRS object was created | |
| workspace_id | int | Foreign key reference to WORKSPACE table | workspace.workspace_id |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | file_details_id | BTREE |
| idx_file_details_workspace | workspace_id | BTREE |
| idx_file_details_study | study_accession | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|