TravelAgency

idnameaddressphoneNumberemailAddress
1Agent AStreet 1+123456789agent@a.com
2Agent BStreet 2+987654321agent@b.com
3Agent CStreet 3+135792468agent@c.com
4Agent DStreet 4+246813579agent@d.com
5Agent EStreet 5+364815926agent@e.com

OnlineBookingPlatform

idnameaddressphoneNumberemailAddress
1Platform XStreet 6+654321789platform@x.com
2Platform YStreet 7+987654321platform@y.com
3Platform ZStreet 8+123456789platform@z.com
4Platform WStreet 9+321456789platform@w.com
5Platform VStreet 10+46815926platform@v.com

Tour

iddestinationdescriptiondurationprice
1Machu PicchuAn ancient Inca city located high up on a mountain ridge.3500.0
2EgyptExplore the Pyramids of Giza and other historical sites.71000.0
3FranceVisit Paris, known as the City of Lights.5700.0
4JapanExperience Japanese culture, cuisine, and technology.71200.0
5AustraliaDiscover the Great Barrier Reef and unique wildlife.101500.0

TripPlanningService

idtripTypeserviceProviderIdtourId
(→ TravelAgency.id)(→ Tour.id)
1Travel Agency11
2Travel Agency22
3Online Booking Platform31
4Online Booking Platform43
5Travel Agency52
6Online Booking Platform63
7Travel Agency73
8Online Booking Platform84
9Travel Agency94
10Online Booking Platform105