## Production_houses

houseID | name
--- | ---
1 | Warner Bros
2 | Disney
3 | Universal Pictures
4 | Paramount Pictures
5 | Fox

## Directors

directorID | firstName | lastName
--- | --- | ---
1 | Christopher | Nolan
2 | Quentin | Tarantino
3 | Steven | Spielberg
4 | Guillermo | del Toro
5 | James | Cameron

## Movies

movieID | title | genre | duration | productionHouseID
--- | --- | --- | --- | ---
|  |  |  | (→ Production_houses.houseID)
1 | Inception | Action Movie | 120 | 1
2 | Pulp Fiction | Action Movie | 180 | 2
3 | Notting Hill | Romantic Comedy | 120 | 3
4 | Avatar | Romantic Comedy | 190 | 4
5 | The Dark Knight | Action Movie | 160 | 1
6 | Indiana Jones and the Last Crusade | Action Movie | 130 | 2
7 | Pretty Woman | Romantic Comedy | 120 | 3
8 | Forrest Gump | Romantic Comedy | 170 | 4

## Actors

actorID | firstName | lastName
--- | --- | ---
1 | Leonardo | DiCaprio
2 | Tom | Hanks
3 | Meryl | Streep
4 | Brad | Pitt
5 | Kevin | Spacey

## Roles

roleID | actorID | movieID | characterType
--- | --- | --- | ---
| (→ Actors.actorID) | (→ Movies.movieID) |
1 | 1 | 1 | Protagonist
2 | 2 | 2 | Antagonist
3 | 3 | 3 | Leading Lady
4 | 4 | 4 | Supporting Actor
5 | 5 | 5 | Villain

## Director_Roles

directorID | movieID
--- | ---
(→ Directors.directorID) | (→ Movies.movieID)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5