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(11) 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
Back to top