Movies
movie_id | title | director | release_year |
1 | Movie1 | Director1 | 2001 |
2 | Movie2 | Director2 | 2002 |
3 | Movie3 | Director3 | 2003 |
4 | Movie4 | Director4 | 2004 |
5 | Movie5 | Director5 | 2005 |
Actors
actor_id | first_name | last_name | date_of_birth |
1 | Actor1FirstName | Actor1LastName | 1976-05-10 |
2 | Actor2FirstName | Actor2LastName | 1980-06-15 |
3 | Actor3FirstName | Actor3LastName | 1985-07-20 |
4 | Actor4FirstName | Actor4LastName | 1990-08-25 |
5 | Actor5FirstName | Actor5LastName | 1995-09-30 |
Roles
role_id | production_role | salary |
| (→ Roles.production_role) | |
1 | Casting Director | 80000.0 |
2 | Casting Director | 90000.0 |
3 | Location Scout | 80000.0 |
4 | Location Scout | 90000.0 |
5 | Assistant Director | 60000.0 |
MovieActors
movie_actor_id | movie_id | actor_id | role_id |
| (→ Movies.movie_id) | (→ Actors.actor_id) | (→ Roles.role_id) |
1 | 1 | 1 | 1 |
2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 |
4 | 4 | 4 | 4 |
5 | 5 | 5 | 5 |