library_files


Description

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.

Columns

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
presses.press_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

Indexes

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

Relationships

Close relationships within degrees of separation