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 |