id | name | seating_capacity | price | availability |
---|---|---|---|---|
1 | Grand Hall | 300 | 8 | 1 |
2 | Conference Room | 100 | 6 | 1 |
3 | Executive Suite | 50 | 10 | 1 |
4 | Board Room | 20 | 12 | 1 |
5 | Meeting Room A | 75 | 9 | 1 |
id | name | seating_capacity | price | availability |
---|---|---|---|---|
1 | Terrace Garden | 200 | 7 | 1 |
2 | Rooftop Lounge | 150 | 9 | 1 |
3 | Poolside Patio | 100 | 8 | 1 |
4 | Gazebo | 50 | 10 | 1 |
5 | Foyer | 30 | 7 | 1 |
event_id | ballroom_id | greenroom_id | event_name | date |
---|---|---|---|---|
(→ Ballrooms.id) | (→ GreenRooms.id) | |||
1 | 1 | 1 | Annual Conference | 2023-01-01 |
2 | 2 | None | Company Meeting | 2023-02-15 |
3 | None | 2 | Wedding Reception | 2023-03-20 |
4 | 3 | None | Product Launch | 2023-04-01 |
5 | 4 | 4 | Holiday Party | 2023-12-20 |
guest_id | first_name | last_name | phone_number | event_id | |
---|---|---|---|---|---|
(→ Events.event_id) | |||||
1 | John | Doe | john.doe@example.com | +1234567890 | 1 |
2 | Jane | Smith | jane.smith@example.com | +0987654321 | 2 |
3 | Alice | Johnson | alice.johnson@example.com | +1122334455 | 3 |
4 | Bob | Williams | bob.williams@example.com | +2233445566 | 4 |
5 | Charlie | Miller | charlie.miller@example.com | +3344556677 | 5 |
booking_id | guest_id | event_date | special_requests |
---|---|---|---|
(→ Guests.guest_id) | |||
1 | 1 | 2023-01-02 18:00:00 | Vegan meal option |
2 | 2 | 2023-02-16 14:00:00 | Gluten-free menu |
3 | 3 | 2023-03-21 20:00:00 | Extra chairs required |
4 | 4 | 2023-04-02 19:00:00 | Music system setup |
5 | 5 | 2023-12-21 22:00:00 | Extended bar hours |