publications

11047 rows


Description

This table stores publication or bibliographic data. The table is designed with fields for bibliographic data so that bibliographies can be formatted in different styles and potentially exported to bibliographic software such EndNote®. In the constituent databases that were originally merged into Neotoma, bibliographic entries were not parsed into separate fields, but rather were stored as free-form text. Because complete parsing of these thousands of legacy bibliographic entries into individual fields would have been prohibitively time consuming, the existing bibliographic data were ingested “as is” with a PubTypeID = Other. However, for legacy publications, the year of publication was added to the Year field, and authors were parsed into the PublicationAuthors table and added to the Contacts table. In addition, some global changes were made. For example, «Pp.» was changed to «Pages», «Ed.» to «Editor», and «Eds.» to «Editors». Also for FAUNMAP entries, abbreviated journal names were changed to fully spelled out names.
The merged databases used different bibliographic styles, and data entry personnel working on the same database sometimes followed different conventions. Consequently, the current bibliographic entries are not stylistically uniform. Eventually, the legacy bibliographic data will be parsed into separate fields.
The Publications table has fields to accommodate a number of different types of publications. Some fields contain different kinds of data for different kinds of publications. For example, the BookTitle field stores the titles of books, but stores the journal name for journal articles. The Publisher field stores the name of the publisher for books, but the name of the university for theses and dissertations.
Authors are stored in the PublicationAuthors table. Editors are also stored in the PublicationAuthors table if the entire publication is cited. The PublicationAuthors table has a ContactID field, which links to the Contacts table, where full names and contact information is stored for authors and editors. The PubTypeID «Authored Book» or «Edited Book» indicates whether the Publication Authors records are authors or editors. If a book chapter or section is the primary bibliographic entry, then the book editors are stored in the PublicationEditors table, which does not have a ContactID field.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
publicationid serial 10 nextval('ndb.seq_publications_publicationid'::regclass)
calibrationcurves.publicationid fk_calibrationcurves_publicationsC
datasetpublications.publicationid fk_datasetpublications_publicationsR
eventpublications.publicationid fk_eventpublications_publicationsC
externalpublications.publicationid fk_externalpublications_publicationsC
formtaxa.publicationid fk_formtaxa_publicationsC
geochronpublications.publicationid fk_geochronpublications_publicationsC
publicationauthors.publicationid fk_publicationauthors_publicationsC
publicationeditors.publicationid fk_publicationeditors_publicationsC
publicationtranslators.publicationid fk_publicationtranslators_publicationsC
pubtsv.publicationid Implied ConstraintR
relativeagepublications.publicationid fk_relativeagepublications_publicationsC
synonymy.publicationid fk_synonymy_publicationsC
taxa.publicationid fk_publicationidR
pubtypeid int4 10 null
publicationtypes.pubtypeid pub_ptyR
year varchar 64 null
citation text 2147483647 null
articletitle text 2147483647 null
journal text 2147483647 null
volume varchar 16 null
issue varchar 8 null
pages varchar 24 null
citationnumber varchar 24 null
doi varchar 128 null
booktitle text 2147483647 null
numvolumes varchar 8 null
edition varchar 24 null
volumetitle text 2147483647 null
seriestitle text 2147483647 null
seriesvolume varchar 24 null
publisher varchar 255 null
url text 2147483647 null
city varchar 64 null
state varchar 64 null
country varchar 64 null
originallanguage varchar 64 null
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
publications_pkey Primary key Asc publicationid

Relationships