## Genre

id | name
--- | ---
1 | Action
2 | Comedy
3 | Drama
4 | Horror
5 | Romance

## Director

id | firstName | lastName
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Michael | Jackson
4 | Emma | Watson
5 | Chris | Evans

## Actor

id | firstName | lastName
--- | --- | ---
1 | Tom | Hanks
2 | Scarlett | Johansson
3 | Leonardo | DiCaprio
4 | Brad | Pitt
5 | Angelina | Jolie

## Movie

id | title | releaseDate | genreId | directorId
--- | --- | --- | --- | ---
|  |  | (→ Genre.id) | (→ Director.id)
1 | Inception | 2010-07-16 | 1 | 1
2 | Interstellar | 2014-11-07 | 3 | 2
3 | The Dark Knight | 2008-07-18 | 1 | 3
4 | Avengers: Endgame | 2019-04-26 | 2 | 4
5 | Titanic | 1997-12-19 | 4 | 5

## Rating

movieId | ageRating | criticalRating | tvShow
--- | --- | --- | ---
(→ Movie.id) |  |  |
1 | 18 | 9.0 | 0
2 | 12 | 8.5 | 0
3 | 16 | 7.5 | 0
4 | 12 | 8.0 | 0
5 | 15 | 7.0 | 0

## Review

id | reviewText | rating | actorId | movieId
--- | --- | --- | --- | ---
|  |  | (→ Actor.id) | (→ Movie.id)
1 | Great acting and a thrilling plot. | 5 | 1 | 1
2 | A masterpiece of cinema. | 5 | 2 | 2
3 | Amazing visuals but weak storyline. | 3 | 3 | 3
4 | An emotional rollercoaster. | 5 | 4 | 4
5 | Too long and not as good as expected. | 2 | 5 | 5