Library files can be associated with the context (press/server/journal) or with individual submissions, and are typically forms, agreements, and other administrative documents that are not part of the scholarly content.


Column Type Size Nulls Auto Default Children Parents Comments
file_id BIGINT 19 null
library_file_settings.file_id library_file_settings_file_id_foreignC
context_id BIGINT 19 null
journals.journal_id library_files_context_idC
file_name VARCHAR 255 null
original_file_name VARCHAR 255 null
file_type VARCHAR 255 null
file_size BIGINT 19 null
type SMALLINT 5 null
date_uploaded DATETIME 19 null
date_modified DATETIME 19 null
submission_id BIGINT 19 NULL
submissions.submission_id library_files_submission_id_foreignC
public_access SMALLINT 5 0


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc file_id
library_files_context_id Performance Asc context_id
library_files_submission_id Performance Asc submission_id