Studio

idname
1Warner Bros
2Universal Studios

Genre

idtype
1Mystery
2Thriller

Movie

idtitlerelease_datestudio_idgenre_id
(→ Studio.id)(→ Genre.id)
1The Maltese Falcon1941-08-2311
2Casablanca1942-11-2622
3Inception2010-07-1622
4Gone Girl2014-10-0111
5Jaws1975-06-2012

Mysteries

idmovie_idcluesmystery_level
(→ Movie.id)
11Clue 1, Clue 2, Clue 38
22Hint 1, Hint 2, Hint 39
33Tip 1, Tip 2, Tip 37
44Puzzle 1, Puzzle 2, Puzzle 310
55Riddle 1, Riddle 2, Riddle 36

Thrillers

idmovie_idsuspense_levelclimax
(→ Movie.id)
119Surprise ending
2210High-speed chase
338Hostage situation
447Twist revelation
556Tension-filled confrontation