## Studio

id | name
--- | ---
1 | Warner Bros
2 | Universal Studios

## Genre

id | type
--- | ---
1 | Mystery
2 | Thriller

## Movie

id | title | release_date | studio_id | genre_id
--- | --- | --- | --- | ---
|  |  | (→ Studio.id) | (→ Genre.id)
1 | The Maltese Falcon | 1941-08-23 | 1 | 1
2 | Casablanca | 1942-11-26 | 2 | 2
3 | Inception | 2010-07-16 | 2 | 2
4 | Gone Girl | 2014-10-01 | 1 | 1
5 | Jaws | 1975-06-20 | 1 | 2

## Mysteries

id | movie_id | clues | mystery_level
--- | --- | --- | ---
| (→ Movie.id) |  |
1 | 1 | Clue 1, Clue 2, Clue 3 | 8
2 | 2 | Hint 1, Hint 2, Hint 3 | 9
3 | 3 | Tip 1, Tip 2, Tip 3 | 7
4 | 4 | Puzzle 1, Puzzle 2, Puzzle 3 | 10
5 | 5 | Riddle 1, Riddle 2, Riddle 3 | 6

## Thrillers

id | movie_id | suspense_level | climax
--- | --- | --- | ---
| (→ Movie.id) |  |
1 | 1 | 9 | Surprise ending
2 | 2 | 10 | High-speed chase
3 | 3 | 8 | Hostage situation
4 | 4 | 7 | Twist revelation
5 | 5 | 6 | Tension-filled confrontation