id | name |
---|---|
1 | Warner Bros |
2 | Universal Studios |
id | type |
---|---|
1 | Mystery |
2 | Thriller |
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 |
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 |
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 |