submission_chapters


Description

A list of chapters for each submission (when submissions are divided into chapters).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
chapter_id BIGINT 19 √ null
metrics_submission.chapter_id metrics_submission_chapter_id_foreignC
submission_chapter_authors.chapter_id submission_chapter_authors_chapter_id_foreignC
submission_chapter_settings.chapter_id submission_chapter_settings_chapter_id_foreignC
submission_chapters.source_chapter_id submission_chapters_source_chapter_id_foreignN
usage_stats_total_temporary_records.chapter_id ust_chapter_id_foreignC
usage_stats_unique_item_investigations_temporary_records.chapter_id usii_chapter_id_foreignC
usage_stats_unique_item_requests_temporary_records.chapter_id usir_chapter_id_foreignC
usage_stats_unique_title_investigations_temporary_records.chapter_id usti_chapter_id_foreignC
usage_stats_unique_title_requests_temporary_records.chapter_id ustr_chapter_id_foreignC
primary_contact_id BIGINT 19 √ NULL
authors.author_id submission_chapters_primary_contact_id_foreignN
publication_id BIGINT 19 null
publications.publication_id submission_chapters_publication_idC
seq DOUBLE 8,2 0.00
source_chapter_id BIGINT 19 √ NULL
submission_chapters.chapter_id submission_chapters_source_chapter_id_foreignN
doi_id BIGINT 19 √ NULL
dois.doi_id submission_chapters_doi_id_foreignN

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc chapter_id
chapters_chapter_id Performance Asc chapter_id
submission_chapters_doi_id_foreign Performance Asc doi_id
submission_chapters_primary_contact_id Performance Asc primary_contact_id
submission_chapters_publication_id Performance Asc publication_id
submission_chapters_source_chapter_id Performance Asc source_chapter_id

Relationships

Close relationships within degrees of separation