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