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