houseID | name |
---|---|
1 | Warner Bros |
2 | Disney |
3 | Universal Pictures |
4 | Paramount Pictures |
5 | Fox |
directorID | firstName | lastName |
---|---|---|
1 | Christopher | Nolan |
2 | Quentin | Tarantino |
3 | Steven | Spielberg |
4 | Guillermo | del Toro |
5 | James | Cameron |
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 |
actorID | firstName | lastName |
---|---|---|
1 | Leonardo | DiCaprio |
2 | Tom | Hanks |
3 | Meryl | Streep |
4 | Brad | Pitt |
5 | Kevin | Spacey |
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 |
directorID | movieID |
---|---|
(→ Directors.directorID) | (→ Movies.movieID) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |