Setting

idnamedescription
1New YorkThe city that never sleeps
2LondonHome of Big Ben and Buckingham Palace

Character

idnamerolestory_id
(→ Story.id)
1Inspector LestradeDetective1
2Al CaponeMob Boss2

Episode

idepisode_numbertitlerelease_datestory_id
(→ Story.id)
11Episode One - The Murder2022-06-011
22Episode Two - The Chase2022-06-081

Review

idreviewer_nameratingcommentepisode_id
(→ Episode.id)
1John Doe5Great acting!1
2Jane Smith4Interesting plot but could be better2

Story

idtitlelocation_id
(→ Setting.id)
1A Victorian Mystery1
2Gangsters of the Roaring Twenties2