## Creators

id | name
--- | ---
1 | Christopher Nolan
2 | Quentin Tarantino

## FilmProjects

id | title | releaseDate | creatorId
--- | --- | --- | ---
|  |  | (→ Creators.id)
1 | The Dark Knight | 2008-07-16 | 1
2 | Pulp Fiction | 1994-06-30 | 2

## ProductionElements

id | type | content | filmProjectId
--- | --- | --- | ---
|  |  | (→ FilmProjects.id)
1 | Screenplay | Original Script | 1
2 | Screenplay | Adaptation | 2
3 | Storyboard | Visual Guide | 1
4 | Storyboard | Conceptual Sketches | 2

## Characters

id | name | roleInFilm
--- | --- | ---
1 | Bruce Wayne | Protagonist
2 | Alfred Pennyworth | Butler
3 | Joker | Antagonist
4 | Hannah | Love Interest
5 | Mia Wallace | Supporting Role

## Scenes

id | sceneNumber | characterId | productionElementId
--- | --- | --- | ---
|  | (→ Characters.id) | (→ ProductionElements.id)
1 | 1 | 1 | 1
2 | 2 | 2 | 1
3 | 3 | 3 | 2
4 | 4 | 4 | 2

## Awards

id | awardName | awardedToFilmProjectId
--- | --- | ---
|  | (→ FilmProjects.id)
1 | Best Director | 1
2 | Best Screenplay | 1
3 | Best Supporting Actor | 1
4 | Best Original Score | 2
5 | Audience Choice Award | 2