submissions

672 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_id BIGINT 19 √ null
edit_decisions.submission_id Implied Constraint R
library_files.submission_id Implied Constraint R
metrics.submission_id Implied Constraint R
publications.submission_id Implied Constraint R
review_assignments.submission_id Implied Constraint R
review_round_files.submission_id Implied Constraint R
review_rounds.submission_id Implied Constraint R
stage_assignments.submission_id Implied Constraint R
submission_comments.submission_id Implied Constraint R
submission_files.submission_id Implied Constraint R
submission_search_objects.submission_id Implied Constraint R
submission_settings.submission_id Implied Constraint R
submission_tombstones.submission_id Implied Constraint R
context_id BIGINT 19 null
current_publication_id BIGINT 19 √ NULL
publications.publication_id Implied Constraint R
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 SMALLINT 5 1
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