Difference between revisions of "Database Schema"

From ISFDB
Jump to navigation Jump to search
(→‎Publication-Related Tables: "magazine" marked as unused)
(→‎Transliteration Tables: +Data cleanup tables section)
Line 76: Line 76:
 
* [[Schema:trans_puba]] - Transliterated titles for publications
 
* [[Schema:trans_puba]] - Transliterated titles for publications
 
* [[Schema:trans_titles]] - Transliterated titles for title records
 
* [[Schema:trans_titles]] - Transliterated titles for title records
 +
 +
==Data Cleanup Tables==
 +
 +
* [[Schema:bad_images]] - Publication IDs with suspect images
 +
* [[Schema:cleanup]] - Record IDs in need of review and potential cleanup
 +
* [[Schema:missing_author_urls]] - Author mismatches between ISFDB and other sites (SFE3 only at this time)

Revision as of 17:04, 3 September 2016

Introduction

There are three primary document views utilized by the ISFDB: showing the bibliography of an author, showing the titles present in a publication, and showing the publications in which a title was published. These views require three primary tables: authors, titles, and publications. Various normalization tables are provided to reduce errors and storage needs.

The illustration below shows the relationship between the various tables. All notes are stored in the notes table, which other tables refer to via the primary note_id key. 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. 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.

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 Tables