publications

0 rows


Description

Each publication is one version of a submission.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
publication_id bigserial 19 √ nextval('publications_publication_id_seq'::regclass)
authors.publication_id authors_publication_idC
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_current_publication_idN
access_status int8 19 √ '0'::bigint
date_published date 13 √ null
last_modified timestamp 22 √ null
primary_contact_id int8 19 √ null
authors.author_id publications_author_idN
section_id int8 19 √ null
sections.section_id publications_section_id_foreignN
submission_id int8 19 null
submissions.submission_id publications_submission_id_foreignC
status int2 5 '1'::smallint
url_path varchar 64 √ null
version int8 19 √ null
doi_id int8 19 √ null
dois.doi_id publications_doi_id_foreignN

Indexes

Constraint Name Type Sort Column(s)
publications_pkey Primary key Asc publication_id
publications_author_id Performance Asc primary_contact_id
publications_doi_id Performance Asc doi_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