Database Schema

From ISFDB

Jump to: navigation, search

This page lists all MySQL tables used by the ISFDB software and links to more detailed pages which provide a field-level view of each table.

Contents

Introduction

The ISFDB is built around the following types of records:

  • authors, which include editors and artists
  • publications, i.e. any separate appearances of SF-related works, mostly books and magazines
  • titles, i.e. separate works of fiction, non-fiction and art which can appear in one or more publications
  • series, i.e. groups of related titles
  • publishers
  • publication series, that is otherwise unrelated publications grouped together by the publisher, e.g. Ace Double
  • awards

Note that all notes are stored in the notes table, which other tables refer to via the primary note_id key. (The only exception is the Authors table which contains author notes.) The metadata table contains data pertinent to the database itself.

A high-level explanation of the database can be found in the Database Overview article (out of date.) An out-of-date diagram of the ISFDB tables and their relationships can be found here.

Global Tables

Information stored in the global tables are shared across the title, author, and publication related tables in the ISFDB.

User Tables

MediaWiki Tables

The ISFDB uses MediaWiki software to run its Wiki. See this MediaWiki chart for lists of table fields. The following MediaWiki pages are also used by the ISFDB software:

  • mw_page - Information about all Wiki pages. Used by the nightly cleanup reports to find Wiki-ISFDB mismatches.
  • mw_user‎ - User ID, name and other user-specific information. The version in publicly available backups has been cleansed of all private data.
  • mw_user‎_group - Includes the Wiki group (editors, moderators/sysops or bureaucrats) to which each user belongs.

Author-Related Tables

The following tables are used to store information about authors and their works:

Publication-Related Tables

The following tables are used to store information about publications:

Title-Related Tables

The following tables are used to store information about titles:

Awards-Related Tables

The following tables are used to store information about awards:

Transliteration Tables

Data Cleanup and Statistics Tables

Personal tools