SuiteID | RoomNumber | OccupancyLimit | Amenities | Price_per_night |
---|---|---|---|---|
1 | A123 | 6 | Air conditioning, TV, WiFi, Mini fridge | 150.0 |
2 | B456 | 8 | Air conditioning, TV, WiFi, Balcony, Microwave | 200.0 |
3 | C789 | 10 | Air conditioning, TV, WiFi, Kitchenette | 250.0 |
4 | D012 | 12 | Air conditioning, TV, WiFi, Safe, Bathtub | 300.0 |
5 | E345 | 14 | Air conditioning, TV, WiFi, Kitchenette, Terrace | 350.0 |
RoomID | NumberOfBeds | View | Services | Price_per_night |
---|---|---|---|---|
1 | 1 | City view | TV, WiFi, Air conditioning | 150.0 |
2 | 1 | Mountain view | TV, WiFi, Minibar | 100.0 |
3 | 2 | Garden view | TV, WiFi, Air conditioning, Coffee/Tea maker | 120.0 |
4 | 2 | Pool view | TV, WiFi, Hairdryer, Ironing facilities | 130.0 |
5 | 1 | Sea view | TV, WiFi, Air conditioning, Refrigerator | 180.0 |
GuestID | FullName | PhoneNumber | EmailAddress |
---|---|---|---|
1 | John Doe | +1234567890 | johndoe@example.com |
2 | Jane Smith | +0987654321 | janesmith@example.com |
3 | Michael Johnson | +1234567890 | michaeljohnson@example.com |
4 | Emily Davis | +0987654321 | emilydavis@example.com |
5 | David Brown | +1234567890 | davidbrown@example.com |
BookingID | CheckInDate | CheckOutDate | TotalCost | GuestID |
---|---|---|---|---|
(→ Guests.GuestID) | ||||
1 | 2023-01-01 | 2023-01-05 | 600.0 | 1 |
2 | 2023-01-10 | 2023-01-15 | 1000.0 | 2 |
3 | 2023-01-15 | 2023-01-20 | 1500.0 | 3 |
4 | 2023-02-01 | 2023-02-05 | 400.0 | 4 |
5 | 2023-02-08 | 2023-02-12 | 750.0 | 5 |
PaymentID | Amount | DatePaid | CardType | BookingID |
---|---|---|---|---|
(→ Bookings.BookingID) | ||||
1 | 600 | 2023-01-02 | Visa | 1 |
2 | 1000 | 2023-01-07 | Mastercard | 2 |
3 | 1500 | 2023-01-14 | American Express | 3 |
4 | 400 | 2023-02-01 | Visa | 4 |
5 | 750 | 2023-02-08 | Mastercard | 5 |
ReviewID | Rating | Comment | SubmissionDate | GuestID |
---|---|---|---|---|
(→ Guests.GuestID) | ||||
1 | 5 | Great stay! Excellent service. | 2023-01-06 | 1 |
2 | 4 | Very comfortable room, good location. | 2023-01-12 | 2 |
3 | 3 | The suite was nice but a bit expensive. | 2023-01-18 | 3 |
4 | 5 | Amazing experience! Highly recommended. | 2023-02-05 | 4 |
5 | 4 | Good value for money, would return. | 2023-02-15 | 5 |