| 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 |