## Documentaries

id | title | director | release_date | budget
--- | --- | --- | --- | ---
1 | The Great Migration | Alastair Fothergill | 2019-08-30 | 500000.0
2 | Cities of Light | Jean-Pierre Lefebvre | 2016-07-15 | 400000.0
3 | Planet Earth II | Fredi Devas & Mark Linfield | 2016-11-05 | 550000.0
4 | The Blue Planet | Alastair Fothergill and Mark Linfield | 2001-10-25 | 1000000.0
5 | Oceans | James Cameron | 2009-10-13 | 300000.0

## ShortFilms

id | title | director | release_date | duration
--- | --- | --- | --- | ---
1 | A Day at the Beach | Tom Brown | 2021-06-12 | 5
2 | The Little Prince | Mark Osborne | 2015-03-27 | 10
3 | Le Petit Nicolas | Laurent Tirard | 2017-01-20 | 15
4 | My Life as a Courgette | Claude Barras | 2016-10-03 | 7
5 | The Girl Who Leapt Through Time | Mamoru Hosoda | 2006-07-01 | 6

## Directors

id | name | birth_year
--- | --- | ---
1 | Alastair Fothergill | 1962
2 | Jean-Pierre Lefebvre | 1950
3 | Fredi Devas | 1965
4 | Mark Linfield | 1959
5 | James Cameron | 1954

## Producers

id | name | company
--- | --- | ---
1 | Simon Chinn | Passion Pictures
2 | Daisy Gili | Passion Pictures
3 | John Baxter | DisneyNature
4 | Philippe Mechelen | Wild Bunch
5 | Christophe Bonniot | Wild Bunch

## Casts

id | film_id | actor_name | role
--- | --- | --- | ---
| (→ Films.id) |  |
1 | 1 | David Attenborough | Narrator
2 | 2 | Chris Packham | Himself
3 | 3 | Sir David Attenborough | Presenter
4 | 4 | Stephen Fry | Voiceover
5 | 5 | Sigourney Weaver | Narrator

## Films

id | type | documentary_id | short_film_id | director_id | producer_id | budget
--- | --- | --- | --- | --- | --- | ---
|  | (→ Documentaries.id) | (→ ShortFilms.id) | (→ Directors.id) | (→ Producers.id) |
1 | Documentary | 1 | None | 1 | 1 | 500000.0
2 | Documentary | 2 | None | 2 | 2 | 400000.0
3 | Short Film | None | 1 | 3 | 3 | 500000.0
4 | Short Film | None | 2 | 4 | 4 | 550000.0
5 | Documentary | 3 | None | 5 | 5 | 1000000.0
6 | Documentary | 4 | None | 6 | 6 | 300000.0