customers

customer_idfirst_namelast_nameemailphone_number
1JohnDoejohn.doe@example.com123-456-7890
2JaneSmithjane.smith@example.com098-765-4321

rooms

room_idroom_typepriceavailable
1Standard100.01
2Deluxe150.01

bookings

booking_idcustomer_idcheckincheckouttotal_amount
(→ customers.customer_id)
112023-01-012023-01-03200.0
222023-02-012023-02-03250.0

reviews

review_idcustomer_reviewdifficulty_levelhikes
1Great experience!3Waterfall loop
2Beautiful scenery but challenging.4View point hike