Skip to main content

Table 1 Metadata for medline_author table.

From: Tools for loading MEDLINE into a local relational database

columnNameDef

xmlElementNameDef

columnTypeDef

pmid

PMID

Types.INTEGER

last_name

Author.LastName

Types.VARCHAR

fore_name

Author.ForeName

Types.VARCHAR

first_name

Author.FirstName

Types.VARCHAR

middle_name

Author.MiddleName

Types.VARCHAR

initials

Author.Initials

Types.VARCHAR

suffix

Author.Suffix

Types.VARCHAR

affiliation

Author.Affiliation

Types.VARCHAR

collective_name

Author.CollectiveName

Types.VARCHAR

  1. columnNameDef: column names for the table,
  2. xmlElementNameDef: XML element names that correspond to column names,
  3. columnTypeDef: data type of each column