Filmmaker
id | name | birth_year |
1 | Alfred Hitchcock | 1899 |
2 | Quentin Tarantino | 1963 |
3 | Christopher Nolan | 1970 |
4 | Martin Scorsese | 1942 |
5 | Stanley Kubrick | 1928 |
Screenwriter
id | name | birth_year |
1 | Joseph Stefano | 1922 |
2 | Quentin Tarantino | 1963 |
3 | Jonathan Nolan | 1976 |
4 | Paul Schrader | 1946 |
5 | David Webb Peoples | 1941 |
Movie
id | title | release_date | filmmaker_id | screenwriter_id |
| | | (→ Filmmaker.id) | (→ Screenwriter.id) |
1 | Psycho | 1960-06-16 | 1 | 1 |
2 | Inglourious Basterds | 2009-08-20 | 2 | 2 |
3 | The Prestige | 2006-10-19 | 3 | 3 |
4 | Taxi Driver | 1976-02-08 | 4 | 5 |
5 | Blade Runner | 1982-06-25 | 4 | 6 |
Genre
id | genre_name |
1 | Thriller |
2 | Crime |
3 | Drama |
4 | Science Fiction |
5 | Action |
Actor
id | name | birth_year |
1 | Leonardo DiCaprio | 1974 |
2 | Joseph Gordon-Levitt | 1981 |
3 | Tom Hardy | 1977 |
4 | Cate Blanchett | 1969 |
5 | Kristen Scott Thomas | 1960 |
Cast
movie_id | actor_id | role |
(→ Movie.id) | (→ Actor.id) | |
1 | 1 | Norman Bates |
1 | 2 | Marion Crane |
2 | 1 | Fredric Quentlin |
2 | 3 | Brad Pitt |
3 | 4 | Robert Angier |