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_formats.publication_id publication_formats_publication_idC
publication_settings.publication_id publication_settings_publication_id_foreignC
submission_chapters.publication_id submission_chapters_publication_idC
submissions.current_publication_id submissions_publication_idN
date_published DATE 10 √ NULL
last_modified DATETIME 19 √ NULL
primary_contact_id BIGINT 19 √ NULL
authors.author_id publications_author_idN
publication_date_type VARCHAR 32 √ 'pub'
publication_type VARCHAR 32 √ 'publication'
seq DOUBLE 8,2 0.00
series_id BIGINT 19 √ NULL
series.series_id publications_series_idN
series_position VARCHAR 255 √ NULL
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 series_id
publications_submission_id Performance Asc submission_id

Relationships

Close relationships within degrees of separation