Location

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

Era

idname
1Victorian Era
2Roaring Twenties

Story

idtitlelocation_idera_id
(→ Location.id)(→ Era.id)
1A Victorian Mystery11
2Gangsters of the Roaring Twenties22

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