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