id | name |
---|---|
1 | Action |
2 | Adventure |
3 | Comedy |
4 | Drama |
5 | Fantasy |
id | typeName |
---|---|
1 | Film |
2 | Novel |
id | title | releaseYear | genreId | mediaTypeId |
---|---|---|---|---|
(→ Genre.id) | (→ MediaType.id) | |||
1 | Film1 | 2020 | 1 | 1 |
2 | Film2 | 2021 | 2 | 1 |
3 | Novel1 | 2020 | 3 | 2 |
4 | Novel2 | 2021 | 4 | 2 |
id | firstName | lastName |
---|---|---|
1 | John | Doe |
2 | Jane | Smith |
id | authorId | publicationYear |
---|---|---|
(→ Author.id) | ||
1 | 1 | 2020 |
2 | 2 | 2021 |
id | director | filmId |
---|---|---|
(→ EntertainmentItem.id) | ||
1 | Director1 | 1 |
2 | Director2 | 2 |