submission_files


Description

All files associated with a submission, such as those uploaded during submission, as revisions, or by copyeditors or layout editors for production.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_file_id BIGINT UNSIGNED 20 √ null
metrics_submission.submission_file_id metrics_submission_submission_file_id_foreignC
publication_galleys.submission_file_id publication_galleys_submission_file_id_foreignR
review_files.submission_file_id review_files_submission_file_id_foreignC
review_round_files.submission_file_id review_round_files_submission_file_id_foreignC
submission_file_revisions.submission_file_id submission_file_revisions_submission_file_id_foreignC
submission_file_settings.submission_file_id submission_file_settings_submission_file_id_foreignC
submission_files.source_submission_file_id submission_files_source_submission_file_id_foreignC
usage_stats_total_temporary_records.submission_file_id ust_submission_file_id_foreignC
usage_stats_unique_item_investigations_temporary_records.submission_file_id usii_submission_file_id_foreignC
usage_stats_unique_item_requests_temporary_records.submission_file_id usir_submission_file_id_foreignC
submission_id BIGINT 19 null
submissions.submission_id submission_files_submission_idC
file_id BIGINT UNSIGNED 20 null
files.file_id submission_files_file_id_foreignC
source_submission_file_id BIGINT UNSIGNED 20 √ NULL
submission_files.submission_file_id submission_files_source_submission_file_id_foreignC
genre_id BIGINT 19 √ NULL
genres.genre_id submission_files_genre_id_foreignN
file_stage BIGINT 19 null
direct_sales_price VARCHAR 255 √ NULL
sales_type VARCHAR 255 √ NULL
viewable SMALLINT 5 √ NULL
created_at DATETIME 19 null
updated_at DATETIME 19 null
uploader_user_id BIGINT 19 √ NULL
users.user_id submission_files_uploader_user_id_foreignN
assoc_type BIGINT 19 √ NULL
assoc_id BIGINT 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc submission_file_id
submission_files_file_id Performance Asc file_id
submission_files_genre_id Performance Asc genre_id
submission_files_source_submission_file_id Performance Asc source_submission_file_id
submission_files_stage_assoc Performance Asc/Asc/Asc file_stage + assoc_type + assoc_id
submission_files_submission_id Performance Asc submission_id
submission_files_uploader_user_id Performance Asc uploader_user_id

Relationships

Close relationships within degrees of separation