FilmProjects
projectID | title | releaseDate |
1 | Film1 | 2023-01-01 |
2 | Film2 | 2023-07-08 |
Directors
directorID | name | birthdate |
1 | Director1 | 1975-11-26 |
2 | Director2 | 1980-08-03 |
Cinematographers
cinematographerID | name | experience |
1 | Cinematograher1 | 10 |
2 | Cinematograher2 | 15 |
Actors
actorID | name | age |
1 | Actor1 | 30 |
2 | Actor2 | 25 |
3 | Actor3 | 35 |
4 | Actor4 | 28 |
5 | Actor5 | 40 |
Roles
roleID | filmProjectID | actorID |
| (→ FilmProjects.projectID) | (→ Actors.actorID) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 1 | 3 |
4 | 2 | 4 |
5 | 1 | 5 |
Lighting_Technicians
technicianID | name | yearsExperience |
1 | Tech1 | 5 |
2 | Tech2 | 8 |
3 | Tech3 | 7 |
4 | Tech4 | 6 |
5 | Tech5 | 4 |
Fixtures
fixtureType | description |
Softbox | None |
LED Panel | None |
Fresnel | None |
Lighting_Technicians_Fixtures
technicianID | fixtureType |
(→ Lighting_Technicians.technicianID) | (→ Fixtures.fixtureType) |
1 | Softbox |
1 | LED Panel |
2 | Softbox |
2 | Fresnel |
3 | Softbox |
3 | LED Panel |
4 | Softbox |
4 | Fresnel |
5 | Softbox |
5 | LED Panel |
1 | 3 |
2 | 3 |
3 | 3 |
4 | 3 |
5 | 3 |