id | genre |
---|---|
1 | Action |
2 | Adventure |
id | star_name |
---|---|
1 | Tom Cruise |
2 | Keanu Reeves |
3 | Dwayne Johnson |
film_id | title | release_year | director_name | country | runtime |
---|---|---|---|---|---|
1 | Mission Impossible | 2018 | Christopher McQuarrie | USA | 147 |
2 | John Wick | 2014 | Chad Stahelski & David Leitch | USA | 106 |
3 | Oblivion | 2013 | Joseph Kosinski | USA | 124 |
4 | San Andreas | 2015 | Brad Peyton | USA | 119 |
film_genre_id | film_id |
---|---|
(→ Genres.id) | (→ Films.film_id) |
1 | 1 |
1 | 2 |
2 | 3 |
2 | 4 |
film_star_id | film_id | role |
---|---|---|
(→ Stars.id) | (→ Films.film_id) | |
1 | 1 | Ethan Hunt |
2 | 2 | John Wick |
1 | 3 | Jack Harper |
3 | 4 | Ray Gaines |