EventTypes
id | type |
1 | Acting School |
2 | Festival |
Countries
code | name |
GB | United Kingdom |
US | United States |
Films
film_id | title | year | country_code |
| | | (→ Countries.code) |
1 | Film A | 2019.0 | GB |
2 | Film B | 2020.0 | US |
FilmEvents
event_id | film_id | event_type_id | date | location |
| (→ Films.film_id) | (→ EventTypes.id) | | |
1 | 1 | 1 | 2019-06-30 | London |
2 | 1 | 2 | 2019-07-05 | Edinburgh |
3 | 2 | 2 | 2020-08-05 | New York |
Directors
director_id | firstname | lastname | birthdate | nationality |
1 | John | Doe | 1980-01-01 | UK |
2 | Jane | Smith | 1985-02-01 | USA |
FilmDirectorRelationships
film_director_rel_id | film_id | director_id | release_year |
| (→ Films.film_id) | (→ Directors.director_id) | |
1 | 1 | 1 | 2019.0 |
2 | 2 | 2 | 2020.0 |