submissions

0 rows


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 bigserial 19 √ nextval('submissions_submission_id_seq'::regclass)
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
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 int8 19 null
presses.press_id submissions_context_idC
current_publication_id int8 19 √ null
publications.publication_id submissions_publication_idN
date_last_activity timestamp 22 √ null
date_submitted timestamp 22 √ null
last_modified timestamp 22 √ null
stage_id int8 19 '1'::bigint
locale varchar 14 √ null
status int2 5 '1'::smallint
submission_progress varchar 50 'start'::character varying
work_type int2 5 √ '0'::smallint

Indexes

Constraint Name Type Sort Column(s)
submissions_pkey Primary key Asc submission_id
submissions_context_id Performance Asc context_id

Relationships

Close relationships within degrees of separation