Customer

idnameemailphone
1John Doejohn@example.com1234567890
2Jane Smithjane@example.com0987654321
3Alice Johnsonalice@example.com1112223333
4Bob Brownbob@example.com4445556666
5Charlie Davischarlie@example.com7778889999
6David Wilsondavid@example.com1111222333

Tour

idtourNamelocationdurationprice
1Machu PicchuPeru6 hours100.0
2Great Wall of ChinaChina8 hours150.0
3Eiffel TowerFrance2 hours75.0
4ColosseumItaly4 hours80.0
5Statue of LibertyUSA2 hours50.0

ServiceProvider

idtypeserviceNamecontactInfo
1Trip_Planning_ServiceTravel Agency+1234567890
2Trip_Planning_ServiceOnline Booking Platform+987654321
3AccommodationHotel A+1112223333
4TransportationAirline XYZ+4445556666
5Food & BeverageRestaurant ABC+7778889999

Reservation

idcustomerIDtourIDtrip_planning_serviceIDreservationDate
(→ Customer.id)(→ Tour.id)(→ ServiceProvider.id)
11112023-01-01 10:00:00
22222023-01-10 10:00:00
33312023-02-01 10:00:00
44422023-02-10 10:00:00
55122023-03-01 10:00:00