publicationauthors

31426 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)

An arbitrary Author identification number.
publicationid int4 10 null
publications.publicationid fk_publicationauthors_publicationsC

Publication identification number. Field links to the Publications table.
authororder int4 10 √ null

Ordinal number for the position in which the author’s name appears in the publication’s author list.
familyname varchar 64 √ null

Family name of author
initials varchar 8 √ null

Initials of author’s given names
suffix varchar 8 √ null

Authors suffix (e.g. «Jr.»)
contactid int4 10 √ null
contacts.contactid fk_publicationauthors_contactsR

Contact identification number. Field links to the Contacts table.
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

Close relationships within degrees of separation