Studio
id | name | location |
1 | Warner Bros. | Burbank, CA |
2 | Disney | Burbank, CA |
3 | Universal Pictures | Universal City, CA |
4 | Paramount Pictures | Hollywood, CA |
5 | 20th Century Fox | Century City, CA |
Director
id | name | birth_year |
1 | Christopher Nolan | 1970 |
2 | Quentin Tarantino | 1963 |
3 | Steven Spielberg | 1946 |
4 | James Cameron | 1954 |
5 | Martin Scorsese | 1942 |
Movie
id | title | release_date | studio_id | director_id |
| | | (→ Studio.id) | (→ Director.id) |
1 | Inception | 2010-07-16 | 1 | 1 |
2 | Pulp Fiction | 1994-10-14 | 2 | 2 |
3 | Schindler's List | 1993-12-15 | 3 | 3 |
4 | Titanic | 1997-12-18 | 4 | 4 |
5 | Goodfellas | 1990-09-22 | 2 | 5 |
Actor
id | first_name | last_name | date_of_birth |
1 | Leonardo | DiCaprio | 1974-11-11 |
2 | Tom | Cruise | 1962-07-03 |
3 | Brad | Pitt | 1963-12-18 |
4 | Joaquin | Phoenix | 1974-10-28 |
Role
movie_id | actor_id | character |
(→ Movie.id) | (→ Actor.id) | |
1 | 1 | Dom Cobb |
2 | 2 | Vincent Vega |
3 | 3 | Oskar Schindler |
4 | 4 | Jack Dawson |
2 | 5 | Jules Winnfield |
Genre
genre_id | name |
1 | Action |
2 | Drama |
3 | Romance |
4 | Thriller |
5 | Crime |
MovieGenre
movie_id | genre_id |
(→ Movie.id) | (→ Genre.genre_id) |
1 | 1 |
1 | 3 |
2 | 2 |
3 | 4 |
4 | 5 |