Locations_Managers

idnamecontact_info
1John Doe+1234567890
2Jane Smith+9876543210
3Alice Johnson+1112223330
4Bob Brown+4445556660
5Charlie Davis+7778889990

Responsibilities

iddescription
1Film Permit Acquisition
2Location Scouting
3Health & Safety Compliance
4Contract Negotiation
5Equipment Coordination

Locations_Managers_Responsibilities

locations_manager_idresponsibility_id
(→ Locations_Managers.id)(→ Responsibilities.id)
11
21
31
41
51
55

Film_Crews

idcrew_namerole
1Camera TeamDirector of Photography
2Sound TeamBoom Operator
3Production DesignersArt Director
4Costume DepartmentCostumer
5Special EffectsPyrotechnics Specialist

Movie_Projects

idtitlerelease_datebudget
1The Big Adventure2022-12-0110000000.0
2Alien Invasion2023-06-1515000000.0
3Love Story2024-02-145000000.0
4Action Thriller2025-08-2020000000.0
5Comedy Drama2026-04-017000000.0

Movies_Cast

movie_idactor_idcharacter_name
(→ Movie_Projects.id)(→ Actors.id)
11Hero
12Villain
23Lead Scientist
24Intergalactic Warrior
35Lonely Heart
36Business Tycoon
47Detective
48Gang Leader
59Small Town Girl
510Wise Old Man

Directors

iddirector_namebirth_year
1Samuel L Jackson1948
2Denzel Washington1954
3Tom Hanks1956
4Robert De Niro1943
5Anthony Hopkins1937

Directed_Movies

director_idmovie_id
(→ Directors.id)(→ Movie_Projects.id)
11
22
33
44
55