id | name | location |
---|---|---|
1 | Broadway Theatre | New York City |
2 | Shakespeare Theatre | Washington DC |
3 | Globe Theatre | London |
4 | Imperial Theatre | Toronto |
5 | National Theatre | Paris |
id | title | genre |
---|---|---|
1 | Hamlet | Tragedy |
2 | Macbeth | Tragedy |
3 | A Midsummer Night's Dream | Comedy |
4 | Othello | Tragedy |
5 | King Lear | Tragedy |
id | firstName | lastName |
---|---|---|
1 | Tom | Hanks |
2 | Meryl | Streep |
3 | Leonardo | DiCaprio |
4 | Jennifer | Lawrence |
5 | Robert | Downey Jr. |
id | firstName | lastName |
---|---|---|
1 | Martin | Scorsese |
2 | Steven | Spielberg |
3 | Christopher | Nolan |
4 | Quentin | Tarantino |
5 | Baz | Luhrmann |
theatreId | playId | performanceDate | actorId | directorId |
---|---|---|---|---|
(→ Theatres.id) | (→ Plays.id) | (→ Actors.id) | (→ Directors.id) | |
1 | 1 | 2023-07-01 | 1 | 1 |
1 | 2 | 2023-07-15 | 2 | 2 |
2 | 1 | 2023-08-01 | 3 | 3 |
2 | 2 | 2023-08-15 | 4 | 4 |
3 | 1 | 2023-09-01 | 5 | 5 |
4 | 1 | 2023-09-01 | 2 | 3 |
5 | 1 | 2023-09-01 | 3 | 2 |