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_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 13 √ null
last_modified timestamp 22 √ null
primary_contact_id int8 19 √ null
authors.author_id publications_author_idN
publication_date_type varchar 32 √ 'pub'::character varying
publication_type varchar 32 √ 'publication'::character varying
seq float8 17,17 '0'::double precision
series_id int8 19 √ null
series.series_id publications_series_idC
series_position varchar 255 √ null
submission_id int8 19 null
submissions.submission_id publications_submission_idC
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_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