id | name | birthdate |
---|---|---|
1 | John Doe | 1970-01-01 |
2 | Jane Smith | 1980-02-02 |
id | name | birthdate |
---|---|---|
1 | Alice Johnson | 1990-03-03 |
2 | Bob Brown | 1985-04-04 |
id | movieId | actorId | roleName |
---|---|---|---|
(→ Movies.id) | (→ Actors.id) | ||
1 | 1 | 1 | Lead Actor |
2 | 2 | 2 | Supporting Actor |
id | genreName |
---|---|
1 | Sci-Fi |
2 | Fantasy |
id | title | releaseDate | directorId | genreId | filmingLocation |
---|---|---|---|---|---|
(→ Directors.id) | (→ Genres.id) | ||||
1 | Movie1 | 2020-01-01 | 1 | 1 | New Zealand |
2 | Movie2 | 2021-02-02 | 2 | 2 | Not New Zealand |
3 | Movie3 | 2019-03-03 | 1 | 2 | New Zealand |
4 | Movie4 | 2022-04-04 | 2 | 1 | Not New Zealand |