Accommodations

idnamelocationpricecapacityaccommodation_type
1Glamping PodSnowdonia99.996Camping
2Glamping PodCornwall89.993Camping
3TreehouseSnowdonia179.995Hotel
4TreehouseDorset149.994Hotel
5MotelBrighton59.9910Lodging
6HostelEdinburgh29.9915Youth Hostel

Customers

customer_idfirstNamelastNameemailphoneNumberaddress
1JohnSmithjohnsmith@example.com+44123456789London, UK
2JaneDoejanedoe@example.com+44987654321Manchester, UK
3AliceWonderlandalicewonderland@example.com+44555555555Cardiff, UK
4CharlieBrowncharliebrown@example.com+4455555556Newcastle, UK

Reviews

review_idratingcommentdatecustomer_id
(→ Customers.customer_id)
15Great experience!2021-10-01 12:00:001
23Good but could be better2021-10-02 12:00:002
34Nice place, would come back.2021-10-03 12:00:003
45Fantastic stay, highly recommended!2021-10-04 12:00:004

Employees

employee_idfirstNamelastNamerolehireDatesalary
1EmmaStoneManager2021-06-0145000.0
2PeterJacksonHousekeeper2021-07-0130000.0
3LucyGarciaChef2021-08-0135000.0
4DavidWilliamsMaintenance2021-09-0128000.0

Bookings

booking_idcheckInTimecheckOutTimenumberOfGueststotalCostcustomer_idaccommodation_id
(→ Customers.customer_id)(→ Accommodations.id)
12021-10-10 10:00:002021-10-12 14:00:002199.9911
22021-10-15 10:00:002021-10-17 14:00:004399.9912
32021-10-20 10:00:002021-10-22 14:00:002249.9923
42021-10-25 10:00:002021-10-27 14:00:003399.9934