## Ballrooms

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

## GreenRooms

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

## Events

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

## Guests

guest_id | first_name | last_name | email | 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

## Bookings

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