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 |
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 |