id | Title | Date | StartTime |
---|---|---|---|
1 | Hamlet | 2021-12-30 | 19:30 |
2 | Wicked | 2021-12-31 | 19:30 |
3 | Phantom of The Opera | 2022-01-01 | 19:30 |
4 | Mamma Mia! | 2022-01-02 | 19:30 |
5 | Lion King | 2022-01-03 | 19:30 |
id | PerformanceId | Name | Description |
---|---|---|---|
(→ Performances.id) | |||
1 | 1 | Comedy Club | A popular venue for stand-up comedy shows. |
2 | 2 | Open Stage | An intimate theatre where actors can perform their own material. |
id | PerformanceId | Composer | Lyricist |
---|---|---|---|
(→ Performances.id) | |||
1 | 1 | Stephen Sondheim | George Furth |
2 | 2 | Andrew Lloyd Webber | Tim Rice |
id | Name |
---|---|
1 | Cambridge Theatre |
2 | Her Majesty's Theatre |
id | VenueId | PerformanceId |
---|---|---|
(→ Venues.id) | (→ Performances.id) | |
1 | 1 | 1 |
2 | 2 | 2 |