publications


Description

Each publication is one version of a submission.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
publication_id BIGINT 19 √ null
authors.publication_id authors_publication_id_foreignC
citations.publication_id citations_publicationC
publication_categories.publication_id publication_categories_publication_id_foreignC
publication_galleys.publication_id publication_galleys_publication_idC
publication_settings.publication_id publication_settings_publication_idC
submissions.current_publication_id submissions_publication_idN
access_status BIGINT 19 √ 0
date_published DATE 10 √ NULL
last_modified DATETIME 19 √ NULL
primary_contact_id BIGINT 19 √ NULL
authors.author_id publications_primary_contact_idN
section_id BIGINT 19 √ NULL
sections.section_id publications_section_idN
seq DOUBLE 8,2 0.00
submission_id BIGINT 19 null
submissions.submission_id publications_submission_idC
status SMALLINT 5 1
url_path VARCHAR 64 √ NULL
version BIGINT 19 √ NULL
doi_id BIGINT 19 √ NULL
dois.doi_id publications_doi_id_foreignN

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc publication_id
publications_doi_id Performance Asc doi_id
publications_primary_contact_id Performance Asc primary_contact_id
publications_section_id Performance Asc section_id
publications_submission_id Performance Asc submission_id
publications_url_path Performance Asc url_path

Relationships

Close relationships within degrees of separation