FamilySuites

SuiteIDRoomNumberOccupancyLimitAmenitiesPrice_per_night
1A1236Air conditioning, TV, WiFi, Mini fridge150.0
2B4568Air conditioning, TV, WiFi, Balcony, Microwave200.0
3C78910Air conditioning, TV, WiFi, Kitchenette250.0
4D01212Air conditioning, TV, WiFi, Safe, Bathtub300.0
5E34514Air conditioning, TV, WiFi, Kitchenette, Terrace350.0

SingleRooms

RoomIDNumberOfBedsViewServicesPrice_per_night
11City viewTV, WiFi, Air conditioning150.0
21Mountain viewTV, WiFi, Minibar100.0
32Garden viewTV, WiFi, Air conditioning, Coffee/Tea maker120.0
42Pool viewTV, WiFi, Hairdryer, Ironing facilities130.0
51Sea viewTV, WiFi, Air conditioning, Refrigerator180.0

Guests

GuestIDFullNamePhoneNumberEmailAddress
1John Doe+1234567890johndoe@example.com
2Jane Smith+0987654321janesmith@example.com
3Michael Johnson+1234567890michaeljohnson@example.com
4Emily Davis+0987654321emilydavis@example.com
5David Brown+1234567890davidbrown@example.com

Bookings

BookingIDCheckInDateCheckOutDateTotalCostGuestID
(→ Guests.GuestID)
12023-01-012023-01-05600.01
22023-01-102023-01-151000.02
32023-01-152023-01-201500.03
42023-02-012023-02-05400.04
52023-02-082023-02-12750.05

Payments

PaymentIDAmountDatePaidCardTypeBookingID
(→ Bookings.BookingID)
16002023-01-02Visa1
210002023-01-07Mastercard2
315002023-01-14American Express3
44002023-02-01Visa4
57502023-02-08Mastercard5

Reviews

ReviewIDRatingCommentSubmissionDateGuestID
(→ Guests.GuestID)
15Great stay! Excellent service.2023-01-061
24Very comfortable room, good location.2023-01-122
33The suite was nice but a bit expensive.2023-01-183
45Amazing experience! Highly recommended.2023-02-054
54Good value for money, would return.2023-02-155