Plays

play_idtitleauthoryear_of_creation
1HamletWilliam Shakespeare1603
2OthelloWilliam Shakespeare1603
3MacbethWilliam Shakespeare1606
4King LearWilliam Shakespeare1608
5Romeo and JulietWilliam Shakespeare1597

Characters

character_idroletype
1protagonistmain
2supportingsecondary
3villainantagonist

Plays_Characters

play_idcharacter_id
(→ Plays.play_id)(→ Characters.character_id)
11
21
31
41
51

Directors

director_idnamebirth_yeardeath_year
1Peter Brook19252022
2Nicholas Hytner1954None
3Michael Grandage1962None
4Sam Mendes1965None
5Sir Trevor Nunn1930None

Productions

production_idplay_iddirector_idstart_dateend_date
(→ Plays.play_id)(→ Directors.director_id)
1112003-09-012003-10-01
2222004-09-012004-10-01
3332005-09-012005-10-01
4442006-09-012006-10-01
5552007-09-012007-10-01

Awards

award_idaward_namecategory
1Best PlayPlay
2Best DirectorDirector
3Best ActorActor
4Best ActressActress
5Lifetime Achievement AwardSpecial

Play_Awards

play_award_idplay_idaward_idyear
(→ Plays.play_id)(→ Awards.award_id)
1112003
2222004
3332005
4442006
5552007