Movie
id | title | releaseDate | Crime_Fiction | Studio | directorId |
| | | | | (→ Director.id) |
1 | MovieA | 2000-01-01 | Mystery | Warner Bros | 1 |
2 | MovieB | 2000-01-01 | Mystery | Universal Studios | 2 |
3 | MovieC | 2000-01-01 | Thriller | Warner Bros | 3 |
4 | MovieD | 2000-01-01 | Thriller | Disney | 4 |
5 | MovieE | 2000-01-01 | Comedy | Columbia Pictures | 5 |
Director
id | name | birthYear |
1 | John Doe | 1960 |
2 | Jane Smith | 1972 |
3 | Alice Brown | 1983 |
4 | Robert Johnson | 1990 |
5 | Emma Wilson | 1995 |
Actor
id | firstName | lastName | dateOfBirth |
1 | Tom | Hanks | 1956-07-09 |
2 | Denzel | Washington | 1954-12-28 |
3 | Scarlett | Johansson | 1984-11-22 |
4 | Leonardo | DiCaprio | 1974-11-11 |
5 | Mark | Ruffalo | 1967-11-22 |
Cast
movieId | actorId | role |
(→ Movie.id) | (→ Actor.id) | |
1 | 1 | Lead Role |
1 | 2 | Supporting Role |
2 | 3 | Lead Role |
2 | 4 | Supporting Role |
3 | 5 | Lead Role |
3 | 6 | Supporting Role |
Genre
id | genreText |
1 | Action |
2 | Adventure |
3 | Drama |
4 | Family |
5 | Fantasy |
MovieGenre
movieId | genreId |
(→ Movie.id) | (→ Genre.id) |
1 | 1 |
1 | 2 |
2 | 3 |
3 | 4 |
4 | 5 |