## 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