Post_Production_Sound_Mixers
id | name | years_of_experience |
1 | John Doe | 10 |
2 | Jane Smith | 8 |
3 | Alice Johnson | 7 |
4 | Bob Brown | 6 |
5 | Tom Green | 9 |
Recording_Environments
id | environment_name |
1 | Isolation Booths |
2 | Live Studio |
3 | Outdoor Location |
4 | Foley Stage |
5 | Dubbing Theatre |
FilmProjects
id | title | release_date |
1 | Film A | 2023-01-01 |
2 | Film B | 2023-02-01 |
3 | Film C | 2023-03-01 |
4 | Film D | 2023-04-01 |
5 | Film E | 2023-05-01 |
Films_with_Sound_Mixing
film_id | mixer_id |
(→ FilmProjects.id) | (→ Post_Production_Sound_Mixers.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
Sound_Mixer_Environment_History
sound_mixer_id | environment_id | start_year | end_year |
(→ Post_Production_Sound_Mixers.id) | (→ Recording_Environments.id) | | |
1 | 1 | 2013 | 2017 |
1 | 2 | 2017 | 2020 |
2 | 2 | 2015 | 2019 |
2 | 3 | 2019 | 2022 |
3 | 3 | 2014 | 2018 |
2 | 1 | 2015 | 2019 |
3 | 1 | 2014 | 2018 |
4 | 1 | None | None |
5 | 1 | None | None |