Theaters
theater_id | name | location |
1 | Broadway Theater | New York |
2 | West End Theatre | London |
3 | Apollo Theatre | Paris |
4 | Drama Centre | Dublin |
5 | Royal Court Theatre | Liverpool |
Performances
performance_id | type |
1 | Comedy Play |
2 | Tragedy |
3 | Musical |
4 | Opera |
5 | Ballet |
Theaters_Performances
theater_id | performance_id |
(→ Theaters.theater_id) | (→ Performances.performance_id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
Actors
actor_id | first_name | last_name |
1 | John Doe | Doe |
2 | Jane Smith | Smith |
3 | Michael Johnson | Johnson |
4 | Emily Davis | Davis |
5 | William Brown | Brown |
Roles
role_id | description |
1 | Lead Role |
2 | Supporting Role |
3 | Villain |
4 | Protagonist |
5 | Antagonist |