id | name | years_of_experience | filmography |
---|---|---|---|
1 | John Doe | 20 | Movie A, Movie B |
2 | Jane Smith | 30 | Film X, Film Y |
id | name | years_of_experience | films_worked_on |
---|---|---|---|
1 | Alice Johnson | 20 | Project Z, Project W |
2 | Bob Brown | 25 | The Sunset, The Dawn |
id | title | director_id | cinematographer_id |
---|---|---|---|
(→ Directors.id) | (→ Cinematographers.id) | ||
1 | Epic Adventure | 1 | 1 |
2 | Thrilling Mystery | 2 | 2 |
id | name | number_of_films |
---|---|---|
1 | Studio Alpha | 8 |
2 | Big Screen Productions | 10 |
id | film_id | production_house_id |
---|---|---|
(→ Films.id) | (→ ProductionHouses.id) | |
1 | 1 | 1 |
2 | 2 | 2 |
id | crew_member | years_of_experience | experience_details |
---|---|---|---|
1 | Director | 20 | Over a decade of directing movies. |
2 | Director | 15 | Multiple awards won for direction. |
3 | Cinematographer | 20 | Wide range of lighting techniques used. |
4 | Cinematographer | 17 | Worked on various genres. |