publicationauthors

24961 rows


Description

This table lists authors as their names are given in publications. Only the initials are stored for authors’ given names. The ContactID links to the author’s full name and contact data in the Contacts table. Thus, for a bibliographic entry, Charles Robert Darwin is listed as C. R. Darwin, or as C. Darwin if the publication did not include his middle name. Book editors are also stored in this table if the entire book is cited. However, if a book chapter or section is cited, authors are stored in this table, but the book editors are stored in the PublicationEditors table. Thus, for the following reference, G. C. Frison is stored in the PublicationAuthors table.
Frison, G. C., editor. 1996. The Mill Iron site. University of New Mexico Press, Albuquerque, New Mexico, USA.
Whereas for the following publication, L. S. Cummings is listed in the PublicationAuthors table, and G. C. Frison is listed in the PublicationEditors table.
Cummings, L. S. 1996. Paleoenvironmental interpretations for the Mill Iron site: stratigraphic pollen and phyrolith analysis. Pages 177-193 in G. C. Frison, editor. The Mill Iron site. University of New Mexico Press, Albuquerque, New Mexico, USA.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
authorid serial 10 nextval('ndb.seq_publicationauthors_authorid'::regclass)
publicationid int4 10 null
publications.publicationid fk_publicationauthors_publicationsC
authororder int4 10 null
familyname varchar 64 null
initials varchar 8 null
suffix varchar 8 null
contactid int4 10 null
contacts.contactid fk_publicationauthors_contactsR
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
publicationauthors_pkey Primary key Asc authorid
ix_contactid_publicationauthors Performance Asc contactid
ix_publicationid_publicationauthors Performance Asc publicationid

Relationships