## 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