Ballrooms

idnameseating_capacitypriceavailability
1Grand Hall30081
2Conference Room10061
3Executive Suite50101
4Board Room20121
5Meeting Room A7591

GreenRooms

idnameseating_capacitypriceavailability
1Terrace Garden20071
2Rooftop Lounge15091
3Poolside Patio10081
4Gazebo50101
5Foyer3071

Events

event_idballroom_idgreenroom_idevent_namedate
(→ Ballrooms.id)(→ GreenRooms.id)
111Annual Conference2023-01-01
22NoneCompany Meeting2023-02-15
3None2Wedding Reception2023-03-20
43NoneProduct Launch2023-04-01
544Holiday Party2023-12-20

Guests

guest_idfirst_namelast_nameemailphone_numberevent_id
(→ Events.event_id)
1JohnDoejohn.doe@example.com+12345678901
2JaneSmithjane.smith@example.com+09876543212
3AliceJohnsonalice.johnson@example.com+11223344553
4BobWilliamsbob.williams@example.com+22334455664
5CharlieMillercharlie.miller@example.com+33445566775

Bookings

booking_idguest_idevent_datespecial_requests
(→ Guests.guest_id)
112023-01-02 18:00:00Vegan meal option
222023-02-16 14:00:00Gluten-free menu
332023-03-21 20:00:00Extra chairs required
442023-04-02 19:00:00Music system setup
552023-12-21 22:00:00Extended bar hours