play_id | title | author | year_of_creation |
---|---|---|---|
1 | Hamlet | William Shakespeare | 1603 |
2 | Othello | William Shakespeare | 1603 |
3 | Macbeth | William Shakespeare | 1606 |
4 | King Lear | William Shakespeare | 1608 |
5 | Romeo and Juliet | William Shakespeare | 1597 |
character_id | role | type |
---|---|---|
1 | protagonist | main |
2 | supporting | secondary |
3 | villain | antagonist |
play_id | character_id |
---|---|
(→ Plays.play_id) | (→ Characters.character_id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
director_id | name | birth_year | death_year |
---|---|---|---|
1 | Peter Brook | 1925 | 2022 |
2 | Nicholas Hytner | 1954 | None |
3 | Michael Grandage | 1962 | None |
4 | Sam Mendes | 1965 | None |
5 | Sir Trevor Nunn | 1930 | None |
production_id | play_id | director_id | start_date | end_date |
---|---|---|---|---|
(→ Plays.play_id) | (→ Directors.director_id) | |||
1 | 1 | 1 | 2003-09-01 | 2003-10-01 |
2 | 2 | 2 | 2004-09-01 | 2004-10-01 |
3 | 3 | 3 | 2005-09-01 | 2005-10-01 |
4 | 4 | 4 | 2006-09-01 | 2006-10-01 |
5 | 5 | 5 | 2007-09-01 | 2007-10-01 |
award_id | award_name | category |
---|---|---|
1 | Best Play | Play |
2 | Best Director | Director |
3 | Best Actor | Actor |
4 | Best Actress | Actress |
5 | Lifetime Achievement Award | Special |
play_award_id | play_id | award_id | year |
---|---|---|---|
(→ Plays.play_id) | (→ Awards.award_id) | ||
1 | 1 | 1 | 2003 |
2 | 2 | 2 | 2004 |
3 | 3 | 3 | 2005 |
4 | 4 | 4 | 2006 |
5 | 5 | 5 | 2007 |