submission_chapters

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
chapter_id bigserial 19 nextval('submission_chapters_chapter_id_seq'::regclass)
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 int8 19 null
authors.author_id submission_chapters_primary_contact_id_foreignN
publication_id int8 19 null
publications.publication_id submission_chapters_publication_idC
seq float8 17,17 '0'::double precision
source_chapter_id int8 19 null
submission_chapters.chapter_id submission_chapters_source_chapter_id_foreignN
doi_id int8 19 null
dois.doi_id submission_chapters_doi_id_foreignN

Indexes

Constraint Name Type Sort Column(s)
submission_chapters_pkey Primary key Asc chapter_id
chapters_chapter_id Performance Asc chapter_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