Location

idname
1Snowdonia
2Lake District

AccommodationType

idtypeName
1Standard Pod
2Deluxe Pod

GlampingPod

idpodNumbercapacitylocationIdaccommodationTypeId
(→ Location.id)(→ AccommodationType.id)
11211
22311
33212
44422
55622

TreeHouse

idhouseNumbercapacitylocationIdaccommodationTypeId
(→ Location.id)(→ AccommodationType.id)
1101611
2102811
3103621
4104822
5105622

Booking

idguestIDglampingPodIdcheckInDatecheckOutDatetotalPrice
(→ Guest.id)(→ GlampingPod.id)
1112022-09-012022-09-07500
2222022-09-152022-09-21700
3332022-09-012022-09-07500
4442022-09-152022-09-21700
5552022-09-012022-09-07500

Guest

idfirstNamelastNameemailphoneNumber
1JohnDoejohn.doe@example.com+441234567890
2JaneSmithjane.smith@example.com+449876543210
3AliceBrownalice.brown@example.com+441234567891
4CharlieBlackcharlie.black@example.com+449876543211
5DavidWhitedavid.white@example.com+441234567892