Film_Historians
historian_id | name | birthdate |
1 | John Doe | 1970-02-15 |
2 | Jane Smith | 1968-03-20 |
3 | Michael Brown | 1975-04-25 |
4 | Emily Johnson | 1980-05-30 |
5 | David Wilson | 1985-06-05 |
Topics
topic_id | topic_name |
1 | Silent_Films |
2 | Animation |
3 | Documentary |
4 | Fantasy |
5 | Horror |
Films
film_id | title | release_year |
1 | The General | 1926 |
2 | Steamboat Bill Jr. | 1928 |
3 | Metropolis | 1927 |
4 | Nosferatu | 1922 |
5 | Frankenstein | 1931 |
Historian_Films
historian_film_id | historian_id | film_id |
| (→ Film_Historians.historian_id) | (→ Films.film_id) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
Historian_Topic
historian_topic_id | historian_id | topic_id |
| (→ Film_Historians.historian_id) | (→ Topics.topic_id) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
Historian_Topic_Films
historian_topic_films_id | historian_topic_id | film_id |
| (→ Historian_Topic.historian_topic_id) | (→ Films.film_id) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |