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