Genres
id | name |
1 | Comedy |
2 | Drama |
3 | Action |
4 | Horror |
5 | Romance |
Movies
id | title | releaseDate | genreId |
| | | (→ Genres.id) |
1 | The Big New | 2019-07-01 | 1 |
2 | Inception | 2010-07-16 | 3 |
3 | Interstellar | 2014-11-07 | 3 |
4 | Get Out | 2017-02-24 | 4 |
5 | La La Land | 2016-12-02 | 2 |
TVShows
id | showName | startYear | endYear | genreId |
| | | | (→ Genres.id) |
1 | Friends | 1994 | 2004 | 1 |
2 | Breaking Bad | 2008 | 2013 | 4 |
3 | Game of Thrones | 2011 | 2019 | 2 |
4 | Stranger Things | 2016 | None | 3 |
5 | Outlander | 2014 | None | 1 |
Actors
id | firstName | lastName | birthdate |
1 | Leonardo | DiCaprio | 1974-11-11 |
2 | Joseph | Gordon-Levitt | 1981-02-17 |
3 | Ellen | Page | 1987-02-21 |
4 | Christopher | Nolan | 1970-07-30 |
5 | Dwayne | Johnson | 1972-05-02 |
MovieActors
movieId | actorId | character |
(→ Movies.id) | (→ Actors.id) | |
1 | 1 | Jack Torrance |
2 | 2 | Cobb |
3 | 3 | Murphy Mcauley |
4 | 4 | Walter White |
5 | 5 | Randy |
SeriesActors
tvShowId | actorId | character | seasonNumber | episodeNumber |
(→ TVShows.id) | (→ Actors.id) | | | |
1 | 1 | Ross Geller | 1 | 1 |
2 | 2 | Walter White | 1 | 1 |
3 | 3 | Claire Underwood | 1 | 1 |
4 | 4 | Hawkeye Pierce | 1 | 1 |
5 | 5 | Luke Skywalker | 1 | 1 |