DirectorID | Name | BirthDate | Country |
---|---|---|---|
1 | Quentin Tarantino | 1963-03-27 | USA |
2 | Christopher Nolan | 1970-07-30 | UK |
3 | Martin Scorsese | 1942-11-22 | USA |
ProducerID | Name | CompanyName | Country |
---|---|---|---|
1 | Harvey Weinstein | Miramax | USA |
2 | David Heyman | Heyday Films | UK |
3 | Geronimo Ballesteros | RatPac-Dune Entertainment | Spain |
ActorID | Name | BirthDate | Country |
---|---|---|---|
1 | Leonardo DiCaprio | 1974-11-11 | USA |
2 | Kate Winslet | 1975-10-05 | UK |
3 | Joaquin Phoenix | 1974-10-28 | USA |
FilmID | Title | ReleaseYear | Country | Director_id | Producer_id |
---|---|---|---|---|---|
(→ Directors.DirectorID) | (→ Producers.ProducerID) | ||||
1 | Inglourious Basterds | 2009 | USA | 1 | 1 |
2 | The Dark Knight | 2008 | UK | 2 | 2 |
3 | Goodfellas | 1990 | USA | 3 | None |
4 | Titanic | 1997 | UK | 3 | 1 |
5 | Gladiator | 2000 | USA | None | 2 |
EventID | Type | Date | Location | Country | Film_id |
---|---|---|---|---|---|
(→ Films.FilmID) | |||||
1 | Acting School | 2022-01-01 | London | UK | 1 |
2 | Acting School | 2022-01-01 | Paris | France | 2 |
3 | Festival | 2022-01-01 | Cannes | France | 3 |
4 | Festival | 2022-01-01 | Venice | Italy | 4 |
CastingID | Film_id | Actor_id | Role | StartDate | EndDate |
---|---|---|---|---|---|
(→ Films.FilmID) | (→ Actors.ActorID) | ||||
1 | 1 | 1 | Hitler | 2009-01-01 | 2009-12-31 |
2 | 2 | 2 | Rachel Dawes | 2005-06-01 | 2005-11-30 |
3 | 3 | 3 | Henry VIII | 1997-09-01 | 1997-11-30 |
4 | 4 | 4 | Maximus Decimus Meridius | 1999-06-01 | 1999-10-31 |
5 | 5 | 5 | Commodus | 2000-06-01 | 2000-11-30 |