Core Tables

Core tables are those that primarily hold the data about a publication, compared to Bridge Tables which primarily show the relationship between the data held in the core tables.

  • Addresses TableThe addresses table includes information about an address like city and country.
  • Citations TableThe citations table holds the information about a citation of a document including the volume, author, and year.
  • Documents TableThe documents table holds the information that describes a document like the title and abstract.
  • Files TableThe files table holds the information about the file that was used to create the database.
  • Keywords TableThe keywords table holds the information about a keywords of a document.
  • Patents TableThe patents table holds the information about a patent.
  • People TableThe people table includes information about authors, editors, and other people associated with a publication.
  • Publishers TableThe publishers table includes information about a publication's publisher like name and city.
  • Sources TableThe people table includes information about a publication's source like the full title, issn, and publication type.