FunctionRooms

IDNameDescription
1BallroomA large room suitable for weddings and conferences.
2Green RoomA cozy room perfect for small gatherings.

SeatingCapacities

CapacityIDMaxOccupancy
1200
2150

Bookings

BookingIdClientNameContactInfoDateOfBookingStartTimeEndTimeFunctionRoomIDSeatingCapacityID
(→ FunctionRooms.ID)(→ SeatingCapacities.CapacityID)
1John Doe+1234567892023-01-01 10:00:0014:0016:0011
2Jane Smith+0987654322023-01-02 10:00:0014:0016:0012
3Alice Johnson+1234567892023-01-03 10:00:0014:0016:0021
4Bob Brown+0987654322023-01-04 10:00:0014:0016:0022

Employees

EmployeeIdFirstNameLastNameRoleSalaryHireDate
1EmmaWilsonEvent Coordinator45000.02022-01-01
2MichaelDavisChef50000.02022-01-01
3AnnaTaylorHousekeeping Supervisor35000.02022-01-01

Clients

ClientIdFirstNameLastNameEmailPhoneNumberAddress
1TomHankstom@example.com+123456789123 Main St
2ChrisEvanschris@example.com+987654321456 Elm St
3LindaCardellinilinda@example.com+135792468789 Oak St
4ElijahWoodelijah@example.com+246813579123 Pine St