filmmaking
id | name | directorName | releaseDate |
1 | The Documentary | John Doe | 2021-09-01 |
2 | Another Documentary | Jane Smith | 2021-08-30 |
3 | A Short Film | Michael Johnson | 2021-07-26 |
4 | Yet Another Short Film | Emily Brown | 2021-07-25 |
film_type
id | type |
1 | Documentary |
2 | Short Film |
budget
id | amount |
1 | 500000.0 |
2 | 700000.0 |
film_details
id | filmmakingId | film_typeId | budgetId |
| (→ filmmaking.id) | (→ film_type.id) | (→ budget.id) |
1 | 1 | 1 | 1 |
2 | 2 | 1 | 2 |
3 | 3 | 2 | 1 |
4 | 4 | 2 | 2 |
crew_members
id | role | memberName |
1 | Director | John Doe |
2 | Producer | Alice Davis |
3 | Cinematographer | Charlie Green |
4 | Editor | David Black |
casts
id | filmmakingId | characterName | actorName |
| (→ filmmaking.id) | | |
1 | 1 | Himself | John Doe |
2 | 2 | Herself | Jane Smith |
3 | 3 | Child Prodigy | Michael Johnson |
4 | 4 | Leading Role | Emily Brown |