Screenplays
screenplayID | title | director |
1 | Inception | Christopher Nolan |
2 | The Dark Knight | Christopher Nolan |
3 | Interstellar | Christopher Nolan |
4 | Pulp Fiction | Quentin Tarantino |
5 | Reservoir Dogs | Quentin Tarantino |
Characters
characterID | roleType |
1 | Protagonist |
2 | Antagonist |
3 | Supporting Role |
Screenplays_Characters
screenplayID | characterID |
(→ Screenplays.screenplayID) | (→ Characters.characterID) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 2 |
Directors
directorID | firstName | lastName |
1 | Christopher | Nolan |
2 | Quentin | Tarantino |
Actors
actorID | firstName | lastName |
1 | Leonardo | DiCaprio |
2 | Joseph | Gordon-Levitt |
3 | Ellen | Page |
4 | Tom | Hardy |
Films
filmID | title | releaseYear | directorID |
| | | (→ Directors.directorID) |
1 | Inception | 2010 | 1 |
2 | The Dark Knight | 2008 | 1 |
3 | Interstellar | 2014 | 1 |
4 | Pulp Fiction | 1994 | 2 |
5 | Reservoir Dogs | 1992 | 2 |
Film_Actors
filmID | actorID | role |
(→ Films.filmID) | (→ Actors.actorID) | |
1 | 1 | Cobb |
1 | 3 | Arthur |
2 | 1 | Batman |
2 | 2 | Rachel Dawes |
3 | 3 | Cooper |
3 | 2 | Ashley |
4 | 1 | Vincent Vega |
4 | 4 | Jules Winnfield |