## Film

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

## Actor

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

## Role

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

## Cinematographer

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

## Camera

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

## ShotList

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

## FilmReviews

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