id | categoryName |
---|---|
1 | Fantasy |
2 | Horror |
id | title | budget | categoryId |
---|---|---|---|
(→ Categories.id) | |||
1 | Lord of the Rings | 20000000.0 | 1 |
2 | Harry Potter | 30000000.0 | 1 |
3 | The Shining | 20000000.0 | 2 |
4 | It | 18000000.0 | 2 |
id | firstName | lastName |
---|---|---|
1 | Leonardo | DiCaprio |
2 | Meryl | Streep |
id | directorName |
---|---|
1 | Peter Jackson |
2 | Christopher Nolan |
filmId | actorId | roleType | directorId |
---|---|---|---|
(→ Films.id) | (→ Actors.id) | (→ Directors.id) | |
1 | 1 | Leading Role | 1 |
2 | 2 | Supporting Role | 2 |
1 | 2 | Villain | 1 |
3 | 1 | Leading Role | 1 |
4 | 2 | Supporting Role | 2 |