## Plays

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

## Characters

character_id | role | type
--- | --- | ---
1 | protagonist | main
2 | supporting | secondary
3 | villain | antagonist

## Plays_Characters

play_id | character_id
--- | ---
(→ Plays.play_id) | (→ Characters.character_id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1

## Directors

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

## Productions

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

## Awards

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_Awards

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