## Location

id | name | description
--- | --- | ---
1 | New York | The city that never sleeps
2 | London | Home of Big Ben and Buckingham Palace

## Era

id | name
--- | ---
1 | Victorian Era
2 | Roaring Twenties

## Story

id | title | location_id | era_id
--- | --- | --- | ---
|  | (→ Location.id) | (→ Era.id)
1 | A Victorian Mystery | 1 | 1
2 | Gangsters of the Roaring Twenties | 2 | 2

## Character

id | name | role | story_id
--- | --- | --- | ---
|  |  | (→ Story.id)
1 | Inspector Lestrade | Detective | 1
2 | Al Capone | Mob Boss | 2

## Episode

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

## Review

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