ID | TypeName | Commercial_Appliances | Apartments | PricePerNight |
---|---|---|---|---|
1 | Luxury Suite | Espresso Machine | High-end Residential | 200.0 |
2 | Standard Room | Espresso Machine | Not High-end Residential | 150.0 |
3 | Deluxe Studio | Blender | High-end Residential | 180.0 |
4 | Economy Room | Blender | Not High-end Residential | 120.0 |
5 | Penthouse | Microwave Oven | High-end Residential | 300.0 |
6 | Budget Room | Toaster | Not High-end Residential | 90.0 |
7 | Villa | Dishwasher | High-end Residential | 400.0 |
8 | Studio | Air Fryer | Not High-end Residential | 110.0 |
9 | Mansion | Oven | High-end Residential | 500.0 |
10 | Loft | Coffee Maker | Not High-end Residential | 130.0 |
ID | FirstName | LastName | PhoneNumber | ApartmentTypeID | |
---|---|---|---|---|---|
(→ ApartmentTypes.ID) | |||||
1 | John | Smith | johnsmith@example.com | 123-456-7890 | 1 |
2 | Jane | Doe | janedoe@example.com | 098-765-4321 | 2 |
3 | Alice | Wonderland | alicewonderland@example.com | 555-123-4567 | 3 |
4 | Bob | Builder | bobbuilder@example.com | 555-987-6543 | 4 |
5 | Charlie | Sheen | charliesheen@example.com | 555-111-2222 | 5 |
6 | David | Beckham | davidbeckham@example.com | 555-333-4444 | 6 |
7 | Emma | Watson | emmawatson@example.com | 555-555-5555 | 7 |
8 | George | Clooney | georgeclooney@example.com | 555-777-8888 | 8 |
9 | Helena | Bonham Carter | helanabonhamcarter@example.com | 555-999-0000 | 9 |
10 | Igor | Stravinsky | igorstravinsky@example.com | 555-666-1234 | 10 |
ID | CheckInDate | CheckOutDate | NumberOfGuests | TotalAmount | GuestID | ApartmentTypeID |
---|---|---|---|---|---|---|
(→ Guests.ID) | (→ ApartmentTypes.ID) | |||||
1 | 2021-10-01 | 2021-10-05 | 2 | 600.0 | 1 | 1 |
2 | 2021-10-06 | 2021-10-10 | 3 | 900.0 | 2 | 2 |
3 | 2021-10-11 | 2021-10-15 | 4 | 1200.0 | 3 | 3 |
4 | 2021-10-16 | 2021-10-20 | 5 | 1500.0 | 4 | 4 |
5 | 2021-10-21 | 2021-10-25 | 6 | 1800.0 | 5 | 5 |
6 | 2021-10-26 | 2021-10-30 | 7 | 2100.0 | 6 | 6 |
7 | 2021-10-31 | 2021-11-04 | 8 | 2400.0 | 7 | 7 |
8 | 2021-11-05 | 2021-11-09 | 9 | 2700.0 | 8 | 8 |
9 | 2021-11-10 | 2021-11-14 | 10 | 3000.0 | 9 | 9 |
10 | 2021-11-15 | 2021-11-19 | 11 | 3300.0 | 10 | 10 |
ID | Rating | Comment | ReviewedOn | GuestID | BookingID |
---|---|---|---|---|---|
(→ Guests.ID) | (→ Bookings.ID) | ||||
1 | 5 | Great experience! | 2021-10-03 | 1 | 1 |
2 | 4 | Good stay, but could have been better. | 2021-10-04 | 2 | 2 |
3 | 3 | The apartment was clean, but not spacious enough. | 2021-10-05 | 3 | 3 |
4 | 5 | Fantastic view of the city! | 2021-10-06 | 4 | 4 |
5 | 4 | We enjoyed our stay at this beautiful place. | 2021-10-07 | 5 | 5 |
6 | 5 | Amazing amenities! | 2021-10-08 | 6 | 6 |
7 | 4 | Quiet location, great for relaxation. | 2021-10-09 | 7 | 7 |
8 | 3 | Could use some updates. | 2021-10-10 | 8 | 8 |
9 | 5 | Everything was perfect! | 2021-10-11 | 9 | 9 |
10 | 4 | Would definitely come back. | 2021-10-12 | 10 | 10 |
ID | RequestDate | Description | Status | ApartmentTypeID |
---|---|---|---|---|
(→ ApartmentTypes.ID) | ||||
1 | 2021-10-01 | Leakage in bathroom | Pending | 1 |
2 | 2021-10-02 | Broken air conditioner | Completed | 2 |
3 | 2021-10-03 | Damaged kitchen appliance | Pending | 3 |
4 | 2021-10-04 | Malfunctioning elevator | Completed | 4 |
5 | 2021-10-05 | Issue with WiFi connection | Pending | 5 |
6 | 2021-10-06 | Dirty carpets | Completed | 6 |
7 | 2021-10-07 | Noisy neighbors | Pending | 7 |
8 | 2021-10-08 | Missing toiletries | Completed | 8 |
9 | 2021-10-09 | Non-working refrigerator | Pending | 9 |
10 | 2021-10-10 | Cracked window pane | Completed | 10 |