Publications

Notes

• Reference is typically a six letter string consisting of first four letters of first author name and two digit year.

  • Smith et al. 2020 would be Smit20.

  • In the case of short last names, either first letters of first name or underscores can be used to construct the four letter string. For example, WuXi21 or Wu__21

  • In the case of multiple publications in the same year, a short string is appended which corresponds to the last digits of the DOI or Bibcode. For example, Smit20.123. Avoid using abc suffixes.

See also

Ingesting publications

Documenation on ingesting publications

ingest_publication

Function to ingest publication data

find publication

Function to find publications in the database

Table documentation

Publications

The Publications table contains metadata (DOI, bibcodes, etc) for each publication referred to in the database. The reference short identifer of each publication is required to be unique.

Columns marked with an exclamation mark (❗️) may not be empty.

Column Name	Description	Datatype	Length	Units	UCD
❗️ reference	Publication short identifier	string	30		meta.ref;meta.main
bibcode	Publication bibcode from NASA ADS	string	100		meta.bib.bibcode
doi	Publication Document Object Identifier (DOI)	string	100		meta.ref.doi
description	Publication description	string	1000		meta.title

Indexes

Name	Columns	Description
PK_Publications	[‘#Publications.reference’]	Primary key for Publications table