id | Venue | Location | Capacity | PricePerHead |
---|---|---|---|---|
1 | Grand Ballroom | Downtown | 300 | 89.75 |
2 | Ceremony Hall | Beachside | 250 | 69.5 |
3 | Rooftop Terrace | Uptown | 150 | 79.25 |
4 | Garden Oasis | Forest | 100 | 59.75 |
5 | Banquet Room | City Center | 200 | 75.0 |
id | Space | Location | Availability | SeatingCapacity |
---|---|---|---|---|
1 | Conference Room | Downtown | 1 | 50 |
2 | Boardroom | Beachside | 0 | 20 |
3 | Seminar Hall | Uptown | 1 | 80 |
4 | Meeting Room | Forest | 1 | 30 |
5 | Training Room | City Center | 0 | 60 |
id | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Smith | johnsmith@email.com | +123456789 |
2 | Jane | Doe | janedoe@email.com | +098765432 |
3 | Michael | Johnson | michaeljohnson@email.com | +111222333 |
4 | Emily | Williams | emilywilliams@email.com | +445566778 |
5 | David | Martinez | davidmartinez@email.com | +987654321 |
BookingId | EventType | Date | StartTime | EndTime | NumberOfGuests | ClientName | ContactEmail | ContactPhoneNumber |
---|---|---|---|---|---|---|---|---|
(→ Guests.FirstName) | (→ Guests.Email) | (→ Guests.PhoneNumber) | ||||||
1 | Wedding | 2023-01-14 | 18:00:00 | 22:00:00 | 150 | John Smith | johnsmith@email.com | +123456789 |
2 | Corporate Event | 2023-02-05 | 09:00:00 | 17:00:00 | 50 | Jane Doe | janedoe@email.com | +098765432 |
3 | Wedding | 2023-03-21 | 16:00:00 | 20:00:00 | 200 | Michael Johnson | michaeljohnson@email.com | +111222333 |
4 | Corporate Event | 2023-04-10 | 10:00:00 | 16:00:00 | 60 | Emily Williams | emilywilliams@email.com | +445566778 |
5 | Wedding | 2023-05-02 | 18:00:00 | 22:00:00 | 120 | David Martinez | davidmartinez@email.com | +987654321 |
Id | ItemName | Description | Price |
---|---|---|---|
1 | Filet Mignon | Tender beef steak with garlic butter | 29.99 |
2 | Seafood Platter | Assorted seafood including shrimp, scallops, and salmon | 34.99 |
3 | Chicken Alfredo | Pasta with creamy garlic chicken sauce | 16.99 |
4 | Quinoa Salad | Fresh quinoa salad with mixed vegetables | 9.99 |
5 | Lemon Tart | Delicious lemon tart dessert | 6.99 |
OrderId | BookingId | MenuItemId | Quantity | TotalPrice |
---|---|---|---|---|
(→ EventBookings.BookingId) | (→ MenuOptions.Id) | |||
1 | 1 | 1 | 4 | 119.96 |
2 | 1 | 2 | 3 | 104.97 |
3 | 2 | 3 | 5 | 84.95 |
4 | 3 | 1 | 6 | 179.94 |
5 | 4 | 4 | 2 | 13.98 |