Actor
actor_id | first_name | last_name | birth_date | nationality |
1 | Tom | Hanks | 1956-07-09 | American |
2 | Meryl | Streep | 1949-06-22 | American |
Movie
movie_id | title | release_year | genre | box_office |
1 | Forrest Gump | 1994 | Drama | 6773847284.0 |
2 | The Godfather | 1972 | Crime | 245124240.0 |
Director
director_id | first_name | last_name | birth_date | nationality |
1 | Robert | Zemeckis | 1951-05-14 | American |
2 | Francis | Ford Coppola | 1939-04-07 | American |
Role
role_id | actor_id | movie_id | character_name |
| (→ Actor.actor_id) | (→ Movie.movie_id) | |
1 | 1 | 1 | Forest Gump |
2 | 2 | 1 | Jenny Curran |
Theatre
theatre_id | name | location | capacity |
1 | Broadway Theatre | New York City | 2000 |
2 | Apollo Theatre | London | 1000 |
Performance
performance_id | play_id | theatre_id | date | time | ticket_price |
| (→ Play.play_id) | (→ Theatre.theatre_id) | | | |
1 | 1 | 1 | 2023-01-01 | 19:00:00 | 100.0 |
2 | 1 | 2 | 2023-01-01 | 19:00:00 | 100.0 |
Play
play_id | epoch | society | title | author | genre | length |
1 | 1606 | Elizabethan England | Macbeth | William Shakespeare | Tragedy | 200 |
2 | 1897 | Late Imperial Russia | Uncle Vanya | Anton Chekhov | Tragicomedy | 150 |