studio_id | name | location |
---|---|---|
1 | Warner Bros | Burbank, California |
2 | Universal Studios | Universal City, California |
3 | Disney Studios | Glendale, California |
producer_id | first_name | last_name | birthdate |
---|---|---|---|
1 | Jane | Doe | 1960-05-01 |
2 | John | Smith | 1975-08-15 |
movie_id | title | release_year | genre | studio_id | producer_id |
---|---|---|---|---|---|
(→ Studio.studio_id) | (→ Producer.producer_id) | ||||
1 | Inception | 2010 | Action/Adventure | 1 | 1 |
2 | Minions | 2015 | Animation | 2 | 2 |
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 |