ApartmentTypes

IDTypeNameCommercial_AppliancesApartmentsPricePerNight
1Luxury SuiteEspresso MachineHigh-end Residential200.0
2Standard RoomEspresso MachineNot High-end Residential150.0
3Deluxe StudioBlenderHigh-end Residential180.0
4Economy RoomBlenderNot High-end Residential120.0
5PenthouseMicrowave OvenHigh-end Residential300.0
6Budget RoomToasterNot High-end Residential90.0
7VillaDishwasherHigh-end Residential400.0
8StudioAir FryerNot High-end Residential110.0
9MansionOvenHigh-end Residential500.0
10LoftCoffee MakerNot High-end Residential130.0

Guests

IDFirstNameLastNameEmailPhoneNumberApartmentTypeID
(→ ApartmentTypes.ID)
1JohnSmithjohnsmith@example.com123-456-78901
2JaneDoejanedoe@example.com098-765-43212
3AliceWonderlandalicewonderland@example.com555-123-45673
4BobBuilderbobbuilder@example.com555-987-65434
5CharlieSheencharliesheen@example.com555-111-22225
6DavidBeckhamdavidbeckham@example.com555-333-44446
7EmmaWatsonemmawatson@example.com555-555-55557
8GeorgeClooneygeorgeclooney@example.com555-777-88888
9HelenaBonham Carterhelanabonhamcarter@example.com555-999-00009
10IgorStravinskyigorstravinsky@example.com555-666-123410

Bookings

IDCheckInDateCheckOutDateNumberOfGuestsTotalAmountGuestIDApartmentTypeID
(→ Guests.ID)(→ ApartmentTypes.ID)
12021-10-012021-10-052600.011
22021-10-062021-10-103900.022
32021-10-112021-10-1541200.033
42021-10-162021-10-2051500.044
52021-10-212021-10-2561800.055
62021-10-262021-10-3072100.066
72021-10-312021-11-0482400.077
82021-11-052021-11-0992700.088
92021-11-102021-11-14103000.099
102021-11-152021-11-19113300.01010

Reviews

IDRatingCommentReviewedOnGuestIDBookingID
(→ Guests.ID)(→ Bookings.ID)
15Great experience!2021-10-0311
24Good stay, but could have been better.2021-10-0422
33The apartment was clean, but not spacious enough.2021-10-0533
45Fantastic view of the city!2021-10-0644
54We enjoyed our stay at this beautiful place.2021-10-0755
65Amazing amenities!2021-10-0866
74Quiet location, great for relaxation.2021-10-0977
83Could use some updates.2021-10-1088
95Everything was perfect!2021-10-1199
104Would definitely come back.2021-10-121010

MaintenanceRequests

IDRequestDateDescriptionStatusApartmentTypeID
(→ ApartmentTypes.ID)
12021-10-01Leakage in bathroomPending1
22021-10-02Broken air conditionerCompleted2
32021-10-03Damaged kitchen appliancePending3
42021-10-04Malfunctioning elevatorCompleted4
52021-10-05Issue with WiFi connectionPending5
62021-10-06Dirty carpetsCompleted6
72021-10-07Noisy neighborsPending7
82021-10-08Missing toiletriesCompleted8
92021-10-09Non-working refrigeratorPending9
102021-10-10Cracked window paneCompleted10