studio_id | name | location |
---|---|---|
1 | Warner Bros | Burbank, California |
2 | Universal Studios | Universal City, California |
3 | Disney Studios | Glendale, California |
actor_id | first_name | last_name | date_of_birth | gender |
---|---|---|---|---|
1 | Leonardo | DiCaprio | 1974-11-11 | M |
2 | Emma | Watson | 1990-04-15 | F |
movie_actor_id | movie_id | actor_id | role |
---|---|---|---|
(→ Movies.movie_id) | (→ Actor.actor_id) | ||
1 | 1 | 1 | Cobb |
2 | 1 | 2 | Arthur |
director_id | first_name | last_name | birthdate |
---|---|---|---|
1 | Christopher | Nolan | 1970-06-20 |
2 | Pierre | Perifel | 1962-01-20 |
movie_director_id | movie_id | director_id |
---|---|---|
(→ Movies.movie_id) | (→ Director.director_id) | |
1 | 1 | 1 |
2 | 2 | 2 |
movie_id | title | release_year | genre | studio_id |
---|---|---|---|---|
(→ Production.studio_id) | ||||
1 | Inception | 2010 | Action/Adventure | 1 |
2 | Minions | 2015 | Animation | 2 |