Study_File
Contains files_associated with a STUDY.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| study_file_accession | varchar(15) | Primary key | |
| description | varchar(4000) | Free text to expand upon details | |
| file_name | varchar(250) | File name | |
| study_accession | varchar(15) | Foreign key reference to STUDY table | study.study_accession |
| study_file_type | varchar(50) | Standardized value in LK_STUDY_FILE_TYPE table | lk_study_file_type.name |
| workspace_id | int | Foreign key reference to WORKSPACE table |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | study_file_accession | BTREE |
| idx_study_file_study | study_accession | BTREE |
| idx_study_file_type | study_file_type | BTREE |
| idx_study_file_workspace | workspace_id | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|