id | title | release_year | director | genre |
---|---|---|---|---|
1 | The Shawshank Redemption | 1994 | Frank Darabont | Drama |
2 | Pulp Fiction | 1994 | Quentin Tarantino | Crime |
3 | Schindler's List | 1993 | Steven Spielberg | Biographical Drama |
4 | Forrest Gump | 1994 | Robert Zemeckis | Romantic Comedy-drama |
5 | Inception | 2010 | Christopher Nolan | Action Sci-Fi |
id | name | birthdate | nationality |
---|---|---|---|
1 | Tom Hanks | 1956-07-09 | American |
2 | Brad Pitt | 1963-12-18 | American |
3 | Leonardo DiCaprio | 1974-11-11 | American |
4 | Morgan Freeman | 1937-06-01 | American |
5 | Kevin Spacey | 1959-07-26 | American |
id | actor_id | role_name | film_id |
---|---|---|---|
(→ Actor.id) | (→ Film.id) | ||
1 | 1 | Andrew Beckett | 1 |
2 | 2 | Jared Vennett | 1 |
3 | 3 | Chris Cotton | 1 |
4 | 4 | Daniel Hillard | 1 |
5 | 5 | Philippe Petit | 1 |
id | name | birthdate | nationality |
---|---|---|---|
1 | Roger Deakins | 1949-05-24 | English |
2 | Emmanuel Lubezki | 1964-12-30 | Mexican |
3 | Wally Pfister | 1961-02-21 | American |
4 | Janusz Kaminski | 1959-08-05 | Polish |
5 | Hoyte Van Hoytema | 1961-11-24 | Swedish |
id | camera_type | resolution |
---|---|---|
1 | ARRI Alexa | 4K |
2 | Red Epic Dragon | 5K |
3 | Canon C300 Mark II | 4K |
4 | Sony F55 | 4K |
5 | Blackmagic Ursa Mini 4.6K | 4.6K |
id | cinematographer_id | shot_description | camera_id |
---|---|---|---|
(→ Cinematographer.id) | (→ Camera.id) | ||
1 | 1 | Establishing shot of New York City skyline | 1 |
2 | 1 | Medium close-up of main character walking down street | 2 |
3 | 2 | Long shot of characters on rooftop at night | 3 |
4 | 2 | Close-up of characters discussing plans | 4 |
5 | 3 | Wide shot of car chase through city streets | 5 |
id | critic_rating | audience_rating | film_id |
---|---|---|---|
(→ Film.id) | |||
1 | 9.0 | 8.5 | 1 |
2 | 8.5 | 8.0 | 2 |
3 | 8.0 | 7.5 | 3 |
4 | 7.5 | 7.0 | 4 |
5 | 8.5 | 8.0 | 5 |