## customers

customer_id | first_name | last_name | email | phone_number
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 123-456-7890
2 | Jane | Smith | jane.smith@example.com | 098-765-4321

## rooms

room_id | room_type | price | available
--- | --- | --- | ---
1 | Standard | 100.0 | 1
2 | Deluxe | 150.0 | 1

## bookings

booking_id | customer_id | checkin | checkout | total_amount
--- | --- | --- | --- | ---
| (→ customers.customer_id) |  |  |
1 | 1 | 2023-01-01 | 2023-01-03 | 200.0
2 | 2 | 2023-02-01 | 2023-02-03 | 250.0

## reviews

review_id | customer_review | difficulty_level | hikes
--- | --- | --- | ---
1 | Great experience! | 3 | Waterfall loop
2 | Beautiful scenery but challenging. | 4 | View point hike