id | LocationName |
---|---|
1 | Times Square, New York |
2 | Bryant Park, New York |
3 | Central Park, New York |
id | ShowTitle | StartTime | EndTime | LocationID | MagicianID | MimeID |
---|---|---|---|---|---|---|
(→ Locations.id) | (→ Magicians.id) | (→ Mimes.id) | ||||
1 | The Magic of Harry Houdini | 2022-11-01 19:00:00 | 2022-11-01 21:00:00 | 1 | 1 | None |
2 | A Night of Illusion | 2022-11-02 19:00:00 | 2022-11-02 21:00:00 | 2 | 2 | None |
3 | The Art of Silence | 2022-11-03 19:00:00 | 2022-11-03 21:00:00 | 3 | 3 | 4 |
4 | The World of Marvel | 2022-11-04 19:00:00 | 2022-11-04 21:00:00 | 4 | None | 5 |
5 | Laughter and Wonder | 2022-11-05 19:00:00 | 2022-11-05 21:00:00 | 5 | 4 | 6 |
id | PurchaserName | ShowID | SeatNumber | Price |
---|---|---|---|---|
(→ Shows.id) | ||||
1 | John Doe | 1 | 1 | 25 |
2 | Jane Smith | 1 | 2 | 25 |
3 | Alice Johnson | 2 | 1 | 30 |
4 | Bob Brown | 2 | 2 | 30 |
5 | Emma Wilson | 3 | 1 | 35 |
id | ReviewerName | Rating | Comment | ShowID |
---|---|---|---|---|
(→ Shows.id) | ||||
1 | John Doe | 5 | Great show! Loved it! | 1 |
2 | Jane Smith | 4 | Enjoyed the magic tricks! | 1 |
3 | Alice Johnson | 3 | Good performance but could have been better. | 2 |
4 | Bob Brown | 2 | Not my cup of tea. | 2 |
5 | Emma Wilson | 4 | Amazing mime performance! | 3 |
id | Name | Age | Street_Location |
---|---|---|---|
(→ Locations.id) | |||
1 | Harry Houdini | 130 | 1 |
2 | David Copperfield | 65 | 2 |
3 | Criss Angel | 47 | 3 |
4 | Dynamo | 39 | 1 |
5 | Penn & Teller | 75 | 2 |
id | Name | Age | Street_Location |
---|---|---|---|
(→ Locations.id) | |||
1 | Marcel Marceau | 88 | 1 |
2 | Whitey McConnell | 95 | 2 |
3 | Charlie Chaplin | 130 | 3 |
4 | Eric Jan De Groot | 70 | 1 |
5 | Leonard Pitts Jr. | 68 | 2 |