## hotels

id | name | location | accommodation_type
--- | --- | --- | ---
1 | Grand Hotel | Downtown | Hotel
2 | Park Plaza | Uptown | Hotel
3 | Young Travelers Hostel | City Center | Youth Hostel
4 | Backpacker Inn | Suburbia | Youth Hostel
5 | Luxury Suites | Beachside | Hotel
6 | Mountain Retreat | Outskirts | Hotel

## yhostels

id | name | location | accommodation_type
--- | --- | --- | ---
1 | Global Nomads | Airport Area | Youth Hostel
2 | Student Haven | University District | Youth Hostel
3 | Adventure Lodge | Nature Reserve | Youth Hostel
4 | Surf & Turf Hostel | Seaside | Youth Hostel
5 | Art Lovers Hangout | Arts Quarter | Youth Hostel

## rooms

hotel_id | room_number | price
--- | --- | ---
(→ hotels.id) |  |
1 | 101 | 50.0
3 | 301 | 50.0
4 | 401 | 80.0
6 | 601 | 50.0

## reviews

user_name | review_text | rating | room_number
--- | --- | --- | ---
|  |  | (→ rooms.room_number)
John Doe | Great experience! | 5 | 101
Jane Smith | Not what I expected. | 3 | 201
Emma Brown | Fantastic stay! | 5 | 301
Mike Johnson | Too expensive. | 2 | 401
Laura Wilson | Awesome hostel! | 4 | 501
William Clark | I will come back again! | 5 | 601
Kate King | Not my cup of tea. | 3 | 701