Kowloon Shangri-La · Crowne Plaza HK · Futian Shangri-La
3 hotel bookings confirmed with conf codes
✅ Confirmed
🏠
Rapallo Airbnb 'Dimora in Piazza'
HMQWFCE2RB · $739.08 · Jun 22–25
✅ Confirmed
🚗
Noleggiare Rental Car · Milan Malpensa T1
Conf: 1658111823416694 · $149.56
✅ Confirmed
Database Audit
Data Critique
Critical
AA206 departure dates are null in DBValerie + kids' flight has no start_at / end_at — needs fixing before Day 10 reunion planning.
Critical
Day 9 lodging references old Shenzhen airport hotelItinerary was updated to depart from HKG but lodging record still says Hyatt Regency Shenzhen Airport.
Critical
Day 10 metadata says "FLIGHT NOT BOOKED"Lufthansa IS confirmed (conf: 1658112215516127, $1,398 paid) — stale warning was never removed.
Important
trip_travelers table is emptyAll traveler rows have null names, roles, emails. Joaquin, Valerie, Martin, Adrian need to be added.
Important
7 duplicate entries in places table + wrong coordinatesLugano points to California (36.54, -121.90). Pisa entry has Genoa's coordinates.
Important
All cost fields null in bookings tableAmounts are in notes but cost_amount / cost_currency are null — no budget tracking possible.
Minor
Stale notes in Days 13 + 17Day 13: unresolved timing warning. Day 17: mart note still references removed Pisa/Lucca stops.
The Roadmap
Future Adventures
Already seeded in the database. The family travel roadmap through 2030.
2027
🇮🇹 Tuscany
Renaissance art, rolling hills, hot springs, farm stays. Great for a 13yo history buff.
💰 $6,900–$11,200 · 8 nights · Direct flights
2028
🇮🇹 Puglia + Matera
Cave dwellings, Caribbean-like beaches. Cheapest Italy. Mind-blowing at 14.
💰 $8,000–$12,000 · 10–12 nights · Direct
2029
🇬🇷 Peloponnese
Olympia, Mycenae, ancient history. Perfect for a 15yo. More independence-ready.
💰 $8,500–$13,500 · 10–12 nights · 1-stop
2030
🇭🇷 Istria + Slovenia
Truffle hunting + crystal Adriatic. Off-the-beaten-path for adventurous teens.
💰 $9,500–$14,000 · 10–12 nights · Direct
See You on the Other Side
"24 days. 3 countries. One family."
June 13 — July 6, 2026 Built by mvrtnBot · Data from Supabase