Customers

idnameemailphoneNumberVacation_OptionActivities
1John Doejohn@example.com1234567890Cruise ShipDance Class
2Jane Smithjane@example.com0987654321Cruise ShipYoga
3Michael Johnsonmichael@example.com5555555555All-Inclusive ResortDance Class
4Emily Davisemily@example.com4444444444All-Inclusive ResortHiking
5Alice Brownalice@example.com3333333333Cruise ShipSnorkeling
6Bob Wilsonbob@example.com2222222222All-Inclusive ResortGolf

Rooms

idtypecapacityprice
1Single Room1100.0
2Double Room2200.0
3Triple Room3300.0
4Family Suite4400.0
5Luxury Suite2500.0

Bookings

idcheckInDatecheckOutDatetotalPriceroomId
(→ Rooms.id)
12022-01-012022-01-07700.01
22022-01-152022-01-211000.02
32022-02-012022-02-07400.03
42022-02-152022-02-21600.04
52022-03-012022-03-07800.05

Customer_Bookings

idcustomerIdbookingId
(→ Customers.id)(→ Bookings.id)
111
222
333
444
555