submission_files

0 rows


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 bigserial 19 √ nextval('submission_files_submission_file_id_seq'::regclass)
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 int8 19 null
submissions.submission_id submission_files_submission_idC
file_id int8 19 null
files.file_id submission_files_file_id_foreignC
source_submission_file_id int8 19 √ null
submission_files.submission_file_id submission_files_source_submission_file_id_foreignC
genre_id int8 19 √ null
genres.genre_id submission_files_genre_id_foreignN
file_stage int8 19 null
direct_sales_price varchar 255 √ null
sales_type varchar 255 √ null
viewable int2 5 √ null
created_at timestamp 22 null
updated_at timestamp 22 null
uploader_user_id int8 19 √ null
users.user_id submission_files_uploader_user_id_foreignN
assoc_type int8 19 √ null
assoc_id int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
submission_files_pkey 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