submissions


Description

All submissions submitted to the context, including incomplete, declined and unpublished submissions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_id BIGINT 19 √ null
edit_decisions.submission_id edit_decisions_submission_idC
features.submission_id features_submission_id_foreignC
library_files.submission_id library_files_submission_id_foreignC
metrics_counter_submission_daily.submission_id msd_submission_id_foreignC
metrics_counter_submission_institution_daily.submission_id msid_submission_id_foreignC
metrics_counter_submission_institution_monthly.submission_id msim_submission_id_foreignC
metrics_counter_submission_monthly.submission_id msm_submission_id_foreignC
metrics_submission.submission_id metrics_submission_submission_id_foreignC
metrics_submission_geo_daily.submission_id msgd_submission_id_foreignC
metrics_submission_geo_monthly.submission_id msgm_submission_id_foreignC
new_releases.submission_id new_releases_submission_idC
publications.submission_id publications_submission_idC
representatives.submission_id representatives_submission_idC
review_assignments.submission_id review_assignments_submission_id_foreignR
review_round_files.submission_id review_round_files_submission_id_foreignC
review_rounds.submission_id review_rounds_submission_id_foreignR
stage_assignments.submission_id stage_assignments_submission_id_foreignC
submission_comments.submission_id submission_comments_submission_idC
submission_files.submission_id submission_files_submission_idC
submission_search_objects.submission_id submission_search_object_submissionC
submission_settings.submission_id submission_settings_submission_id_foreignC
usage_stats_total_temporary_records.submission_id ust_submission_id_foreignC
usage_stats_unique_item_investigations_temporary_records.submission_id usii_submission_id_foreignC
usage_stats_unique_item_requests_temporary_records.submission_id usir_submission_id_foreignC
usage_stats_unique_title_investigations_temporary_records.submission_id usti_submission_id_foreignC
usage_stats_unique_title_requests_temporary_records.submission_id ustr_submission_id_foreignC
context_id BIGINT 19 null
presses.press_id submissions_context_idC
current_publication_id BIGINT 19 √ NULL
publications.publication_id submissions_publication_idN
date_last_activity DATETIME 19 √ NULL
date_submitted DATETIME 19 √ NULL
last_modified DATETIME 19 √ NULL
stage_id BIGINT 19 1
locale VARCHAR 14 √ NULL
status SMALLINT 5 1
submission_progress VARCHAR 50 'start'
work_type SMALLINT 5 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc submission_id
submissions_context_id Performance Asc context_id
submissions_publication_id Performance Asc current_publication_id

Relationships

Close relationships within degrees of separation