Costume_Designers
id | name | birthdate |
1 | John Smith | 1960-07-23 |
2 | Jane Doe | 1980-09-15 |
3 | Michael Brown | 1990-11-30 |
4 | Emily Davis | 1995-02-22 |
5 | David Johnson | 1970-05-01 |
Eras
id | era_name |
1 | Victorian Era |
2 | Modern Era |
3 | Renaissance |
4 | Baroque |
5 | Gothic |
Film_Projects
id | title | release_year | director |
1 | Film A | 2000 | Alice Cooper |
2 | Film B | 2005 | Bob Evans |
3 | Film C | 2010 | Carol King |
4 | Film D | 2015 | Dave Lee |
5 | Film E | 2020 | Edward Wright |
Films_and_Directors
film_id | director_id |
(→ Film_Projects.id) | (→ Directors.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
Actors
id | first_name | last_name |
1 | Alex | Adams |
2 | Ben | Blake |
3 | Chris | Cooper |
4 | Daniel | Dean |
5 | Ethan | Edwards |
Roles
role_id | actor_id | character_name |
| (→ Actors.id) | |
1 | 1 | Role A |
2 | 2 | Role B |
3 | 3 | Role C |
4 | 4 | Role D |
5 | 5 | Role E |
Films_and_Actors
film_id | actor_id |
(→ Film_Projects.id) | (→ Actors.id) |
1 | 1 |
1 | 2 |
2 | 3 |
3 | 4 |
4 | 5 |
Directors
id | first_name | last_name |
1 | Mark | Wood |
2 | Nick | Hopkins |
3 | Samantha | Green |
4 | Tommy | Carter |
5 | Paul | Evans |
Costume_Designers_Eras
costume_designer_id | eras_id |
(→ Costume_Designers.id) | (→ Eras.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |