publicationeditors

1201 rows


Description

This table stores the editors of publications for which chapters or sections are the primary bibliographic entries. Chapter authors are stored in the PublicatonAuthors table, where they are linked to the Contacts table. However, publication editors are not cross-referenced in the Contacts table, because chapter authors are the principal citation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
editorid serial 10 nextval('ndb.seq_publicationeditors_editorid'::regclass)

An arbitrary Editor identification number.

publicationid int4 10 null
publications.publicationid fk_publicationeditors_publicationsC

Publication identification number. Field links to the Publications table.

editororder int4 10 null

Ordinal number for the position in which the editor’s name appears in the publication’s author list.

familyname varchar 64 null

Family name of editor

initials varchar 8 null

Initials of editor’s given names

suffix varchar 8 null

Authors suffix (e.g. «Jr.»)

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
publicationeditors_pkey Primary key Asc editorid
ix_publicationid_publicationeditors Performance Asc publicationid

Relationships