## Genre

id | name
--- | ---
1 | Fantasy
2 | Adventure
3 | Action
4 | Drama
5 | Comedy

## Film

id | title | release_year | budget | genre_id
--- | --- | --- | --- | ---
|  |  |  | (→ Genre.id)
1 | Lord of the Rings | 2001 | 93000000.0 | 1
2 | Harry Potter and the Sorcerer's Stone | 2001 | 125000000.0 | 1
3 | Jurassic Park | 1993 | 63000000.0 | 3
4 | Titanic | 1997 | 200000000.0 | 5
5 | The Dark Knight | 2008 | 185000000.0 | 4

## FantasyFilm

id | film_id | fantasy_element
--- | --- | ---
| (→ Film.id) |
1 | 1 | Magical creatures
2 | 2 | Mythical beings
3 | 3 | Time travel
4 | 4 | Parallel universes
5 | 5 | Enchanted objects

## HorrorFilm

id | film_id | horror_theme
--- | --- | ---
| (→ Film.id) |
1 | 1 | Supernatural entities
2 | 2 | Psychological terror
3 | 3 | Gore and violence
4 | 4 | Creatures
5 | 5 | Thriller