Films
film_id | title | release_year |
1 | The Shawshank Redemption | 1994 |
2 | Forrest Gump | 1994 |
3 | Pulp Fiction | 1994 |
4 | Fight Club | 1999 |
5 | Inception | 2010 |
Crew_Members
member_id | role | name |
1 | Director | John Doe |
2 | Producer | Jane Smith |
3 | Screenwriter | Mike Johnson |
4 | Cinematographer | Emily Brown |
5 | Editor | David Wilson |
Films_Crew_Members
film_id | member_id |
(→ Films.film_id) | (→ Crew_Members.member_id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 4 |
Film_Genres
film_genre_id | genre |
1 | Drama |
2 | Romance |
3 | Crime |
4 | Thriller |
5 | Science Fiction |
Actors
actor_id | first_name | last_name |
1 | Tim | Robinson |
2 | Tom | Hanks |
3 | Brad | Pitt |
4 | Paul | Newman |
5 | Leonardo | DiCaprio |