| customer_id | first_name | last_name | phone_number | |
|---|---|---|---|---|
| 1 | John | Doe | john.doe@example.com | 123-456-7890 |
| 2 | Jane | Smith | jane.smith@example.com | 098-765-4321 |
| room_id | room_type | price | available |
|---|---|---|---|
| 1 | Standard | 100.0 | 1 |
| 2 | Deluxe | 150.0 | 1 |
| 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 |
| review_id | customer_review | difficulty_level | hikes |
|---|---|---|---|
| 1 | Great experience! | 3 | Waterfall loop |
| 2 | Beautiful scenery but challenging. | 4 | View point hike |