RoomID | Building | Area | Spa | Occupied | Rate |
---|---|---|---|---|---|
1 | Building A | Area 101 | 1 | 0 | 299.99 |
2 | Building B | Area 201 | 0 | 1 | 399.99 |
3 | Building C | Area 301 | 1 | 1 | 499.99 |
4 | Building D | Area 401 | 0 | 0 | 599.99 |
5 | Building E | Area 501 | 1 | 0 | 699.99 |
CustomerID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +123456789 |
2 | Jane | Smith | jane.smith@example.com | +987654321 |
3 | Michael | Brown | michael.brown@example.com | +111222333 |
4 | Emily | White | emily.white@example.com | +444555666 |
5 | David | Black | david.black@example.com | +777888999 |
ReservationID | CustomerID | CheckInDate | CheckOutDate | TotalAmount |
---|---|---|---|---|
(→ Customers.CustomerID) | ||||
1 | 1 | 2023-01-01 | 2023-01-05 | 1000.0 |
2 | 2 | 2023-01-10 | 2023-01-15 | 1200.0 |
3 | 3 | 2023-01-20 | 2023-01-25 | 1400.0 |
4 | 4 | 2023-02-01 | 2023-02-05 | 1600.0 |
5 | 5 | 2023-02-10 | 2023-02-15 | 1800.0 |
ServiceID | Description | Price |
---|---|---|
1 | Room upgrade to suite | 150.0 |
2 | Extra bed | 50.0 |
3 | Late checkout | 100.0 |
4 | Breakfast buffet | 30.0 |
5 | Welcome drink at bar | 15.0 |
BookingID | ReservationID | ServiceID | Quantity | TotalAmount |
---|---|---|---|---|
(→ Reservations.ReservationID) | (→ Services.ServiceID) | |||
1 | 1 | 1 | 1 | 150.0 |
2 | 1 | 2 | 1 | 50.0 |
3 | 1 | 3 | 1 | 100.0 |
4 | 1 | 4 | 1 | 30.0 |
5 | 1 | 5 | 1 | 15.0 |