## Genre

id | name
--- | ---
1 | Action
2 | Comedy
3 | Drama
4 | Horror
5 | Mystery

## Film

id | title | release_year | genre_id
--- | --- | --- | ---
|  |  | (→ Genre.id)
1 | Inception | 2010 | 1
2 | The Hangover | 2009 | 2
3 | Gravity | 2013 | 3
4 | It | 2017 | 4
5 | Gone Girl | 2014 | 5

## Director

id | first_name | last_name
--- | --- | ---
1 | Christopher | Nolan
2 | Todd | Philips
3 | Alfonso | Cuaron
4 | Andy | Muschietti
5 | David | Fincher

## FilmDirector

film_id | director_id
--- | ---
(→ Film.id) | (→ Director.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## Script

id | concept | written_by | original_work_title | adaptation_from
--- | --- | --- | --- | ---
|  | (→ Author.author_name) |  |
1 | Adaptation | Stephen King | Carrie | None
2 | Original Work | Stephen King | The Shining | None
3 | Adaptation | Jonathan Nolan | Interstellar | None
4 | Original Work | William Goldman | Butch Cassidy and the Sundance Kid | None
5 | Adaptation | Akiva Goldsman | The Dark Tower | None