ID | Name | Description |
---|---|---|
1 | Ballroom | A large room suitable for weddings and conferences. |
2 | Green Room | A cozy room perfect for small gatherings. |
CapacityID | MaxOccupancy |
---|---|
1 | 200 |
2 | 150 |
BookingId | ClientName | ContactInfo | DateOfBooking | StartTime | EndTime | FunctionRoomID | SeatingCapacityID |
---|---|---|---|---|---|---|---|
(→ FunctionRooms.ID) | (→ SeatingCapacities.CapacityID) | ||||||
1 | John Doe | +123456789 | 2023-01-01 10:00:00 | 14:00 | 16:00 | 1 | 1 |
2 | Jane Smith | +098765432 | 2023-01-02 10:00:00 | 14:00 | 16:00 | 1 | 2 |
3 | Alice Johnson | +123456789 | 2023-01-03 10:00:00 | 14:00 | 16:00 | 2 | 1 |
4 | Bob Brown | +098765432 | 2023-01-04 10:00:00 | 14:00 | 16:00 | 2 | 2 |
EmployeeId | FirstName | LastName | Role | Salary | HireDate |
---|---|---|---|---|---|
1 | Emma | Wilson | Event Coordinator | 45000.0 | 2022-01-01 |
2 | Michael | Davis | Chef | 50000.0 | 2022-01-01 |
3 | Anna | Taylor | Housekeeping Supervisor | 35000.0 | 2022-01-01 |
ClientId | FirstName | LastName | PhoneNumber | Address | |
---|---|---|---|---|---|
1 | Tom | Hanks | tom@example.com | +123456789 | 123 Main St |
2 | Chris | Evans | chris@example.com | +987654321 | 456 Elm St |
3 | Linda | Cardellini | linda@example.com | +135792468 | 789 Oak St |
4 | Elijah | Wood | elijah@example.com | +246813579 | 123 Pine St |