## 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