| id | name | description |
|---|---|---|
| 1 | New York | The city that never sleeps |
| 2 | London | Home of Big Ben and Buckingham Palace |
| id | name |
|---|---|
| 1 | Victorian Era |
| 2 | Roaring Twenties |
| id | title | location_id | era_id |
|---|---|---|---|
| (→ Location.id) | (→ Era.id) | ||
| 1 | A Victorian Mystery | 1 | 1 |
| 2 | Gangsters of the Roaring Twenties | 2 | 2 |
| id | name | role | story_id |
|---|---|---|---|
| (→ Story.id) | |||
| 1 | Inspector Lestrade | Detective | 1 |
| 2 | Al Capone | Mob Boss | 2 |
| id | episode_number | title | release_date | story_id |
|---|---|---|---|---|
| (→ Story.id) | ||||
| 1 | 1 | Episode One - The Murder | 2022-06-01 | 1 |
| 2 | 2 | Episode Two - The Chase | 2022-06-08 | 1 |
| id | reviewer_name | rating | comment | episode_id |
|---|---|---|---|---|
| (→ Episode.id) | ||||
| 1 | John Doe | 5 | Great acting! | 1 |
| 2 | Jane Smith | 4 | Interesting plot but could be better | 2 |