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