publicationeditors

1186 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)
publicationid int4 10 null
publications.publicationid fk_publicationeditors_publicationsC
editororder int4 10 null
familyname varchar 64 null
initials varchar 8 null
suffix varchar 8 null
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