id | name | contact_info |
---|---|---|
1 | John Doe | +1234567890 |
2 | Jane Smith | +9876543210 |
3 | Alice Johnson | +1112223330 |
4 | Bob Brown | +4445556660 |
5 | Charlie Davis | +7778889990 |
id | description |
---|---|
1 | Film Permit Acquisition |
2 | Location Scouting |
3 | Health & Safety Compliance |
4 | Contract Negotiation |
5 | Equipment Coordination |
locations_manager_id | responsibility_id |
---|---|
(→ Locations_Managers.id) | (→ Responsibilities.id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 5 |
id | crew_name | role |
---|---|---|
1 | Camera Team | Director of Photography |
2 | Sound Team | Boom Operator |
3 | Production Designers | Art Director |
4 | Costume Department | Costumer |
5 | Special Effects | Pyrotechnics Specialist |
id | title | release_date | budget |
---|---|---|---|
1 | The Big Adventure | 2022-12-01 | 10000000.0 |
2 | Alien Invasion | 2023-06-15 | 15000000.0 |
3 | Love Story | 2024-02-14 | 5000000.0 |
4 | Action Thriller | 2025-08-20 | 20000000.0 |
5 | Comedy Drama | 2026-04-01 | 7000000.0 |
movie_id | actor_id | character_name |
---|---|---|
(→ Movie_Projects.id) | (→ Actors.id) | |
1 | 1 | Hero |
1 | 2 | Villain |
2 | 3 | Lead Scientist |
2 | 4 | Intergalactic Warrior |
3 | 5 | Lonely Heart |
3 | 6 | Business Tycoon |
4 | 7 | Detective |
4 | 8 | Gang Leader |
5 | 9 | Small Town Girl |
5 | 10 | Wise Old Man |
id | director_name | birth_year |
---|---|---|
1 | Samuel L Jackson | 1948 |
2 | Denzel Washington | 1954 |
3 | Tom Hanks | 1956 |
4 | Robert De Niro | 1943 |
5 | Anthony Hopkins | 1937 |
director_id | movie_id |
---|---|
(→ Directors.id) | (→ Movie_Projects.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |