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 |