Activity

activity_idactivity_nameactivity_type
1Tourist AttractionAttraction
2Tourist AttractionMuseum
3Local MarketMarket
4Local MarketFarmers Market
5RestaurantItalian

Location

location_idlocation_name
1Portobello
2Notting Hill
3Covent Garden
4Camden Town
5Piccadilly Circus

Activity_Location

activity_location_idactivity_idlocation_id
(→ Activity.activity_id)(→ Location.location_id)
111
212
331
442
553

Customer

customer_idfirst_namelast_nameemail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3AliceBrownalice.brown@example.com
4BobWhitebob.white@example.com
5CharlieBlackcharlie.black@example.com

Booking

booking_idcustomer_idcheckin_datecheckout_date
(→ Customer.customer_id)
112023-01-012023-01-07
222023-01-152023-01-22
332023-02-012023-02-08
442023-02-162023-02-23
552023-03-012023-03-09

Reservation

reservation_idbooking_idactivity_location_idnum_people
(→ Booking.booking_id)(→ Activity_Location.activity_location_id)
1114
2123
3232
4245
5354