Skip to content

Latest commit

 

History

History
93 lines (77 loc) · 2.19 KB

README.md

File metadata and controls

93 lines (77 loc) · 2.19 KB
Raw

Doctor Who Episode Database

SQL database of Doctor Who episodes and related data. Currently used by the Catalogopolis API.

License

Public domain. Collections of facts can't be copywritten. But since licensing may be an issue for some people attempting to use this data, I've made it available under CC0.

CC0
To the extent possible under law, Dana Ross has waived all copyright and related or neighboring rights to Doctor Who Episode Database. This work is published from: United States.

Tables

actors

  • id : a sequentially assigned database ID
  • uuid : a unique ID to identify records outside the database
  • name
  • gender

doctors

  • id
  • incarnation
  • primary_actor

serials

  • id
  • season_id
  • story
  • serial
  • title
  • production_code

episodes

  • id
  • title
  • serial_id
  • story
  • episode_order
  • original_air_date
  • runtime
  • uk_viewers_mm
  • appreciation_index
  • missing
  • recreated

seasons

  • id
  • name

companions

  • id
  • name
  • actor

directors

  • id
  • name

writers

  • id
  • name

serials_doctors

  • serial_id
  • doctor_id

serials_companions

  • serial_id
  • companion_id

serials_directors

  • serial_id
  • director_id

serials_writers

  • serial_id
  • writer_id

UUIDs

Use this tool to generate decimal UUIDs when creating or updating records: https://onlinerandomtools.com/generate-random-uuid?chain=remove-string-punctuation%2Cconvert-hex-to-decimal&count=100