hotels

idnamelocationaccommodation_type
1Grand HotelDowntownHotel
2Park PlazaUptownHotel
3Young Travelers HostelCity CenterYouth Hostel
4Backpacker InnSuburbiaYouth Hostel
5Luxury SuitesBeachsideHotel
6Mountain RetreatOutskirtsHotel

yhostels

idnamelocationaccommodation_type
1Global NomadsAirport AreaYouth Hostel
2Student HavenUniversity DistrictYouth Hostel
3Adventure LodgeNature ReserveYouth Hostel
4Surf & Turf HostelSeasideYouth Hostel
5Art Lovers HangoutArts QuarterYouth Hostel

rooms

hotel_idroom_numberprice
(→ hotels.id)
110150.0
330150.0
440180.0
660150.0

reviews

user_namereview_textratingroom_number
(→ rooms.room_number)
John DoeGreat experience!5101
Jane SmithNot what I expected.3201
Emma BrownFantastic stay!5301
Mike JohnsonToo expensive.2401
Laura WilsonAwesome hostel!4501
William ClarkI will come back again!5601
Kate KingNot my cup of tea.3701