id | name |
---|---|
1 | Shakespeare |
2 | Arthur Miller |
3 | Neil Simon |
4 | Aphra Behn |
5 | Oscar Wilde |
id | form |
---|---|
1 | Comedy |
2 | Tragedy |
3 | Drama |
4 | Melodrama |
5 | Farce |
id | title | authorId | theatricalFormId |
---|---|---|---|
(→ Author.id) | (→ Theatrical_Form.id) | ||
1 | Romeo and Juliet | 1 | 1 |
2 | Death of a Salesman | 2 | 3 |
3 | The Odd Couple | 3 | 1 |
4 | Othello | 1 | 2 |
5 | Aphra Behn's Comedy | 4 | 1 |
id | firstName | lastName | birthYear | playId |
---|---|---|---|---|
(→ Play.id) | ||||
1 | Tom | Hanks | 1960 | 2 |
2 | John | Burton | 1987 | 3 |
3 | Julia | Roberts | 1990 | 4 |
4 | Samuel | L. Jackson | 1989 | 1 |
5 | Denzel | Washington | 1987 | 3 |
id | characterName | playId | actorId |
---|---|---|---|
(→ Play.id) | (→ Actor.id) | ||
1 | Cassius | 2 | 1 |
2 | Titus Andronicus | 1 | 4 |
3 | Blanche DuBois | 4 | 2 |
4 | Felix Unger | 3 | 3 |
5 | Macbeth | 1 | 5 |
id | roleDescription | characterId | actorId |
---|---|---|---|
(→ Character.id) | (→ Actor.id) | ||
1 | Friendly neighbourhood superhero | 1 | 1 |
2 | Rich business man | 2 | 2 |
3 | Kind old lady | 3 | 3 |
4 | Lead detective | 4 | 4 |
5 | Brave warrior | 5 | 5 |