Summer 2026 Trip Review

Jun 13 – Jul 6  ·  24 Days  ·  3 Countries  ·  4 Travelers
🇨🇳 Shenzhen 🇭🇰 Hong Kong 🇮🇹 Italian Riviera ⛵ Lake Como 🏙️ Milan Sourced from Supabase
🗺️ Trip Overview
High-level stats and phase breakdown for the 2026 family summer trip.
24
Total Days
3
Countries
4
Flights
4
Travelers
8
Confirmed Bookings
5
Hotels / Airbnbs
📍 Trip Phases
🇺🇸✈️🇭🇰

Phase 1 — Transit

Jun 13–14 · Days 1–2
👥 Joaquin + Martin + Harrison
  • MIA → SFO → HKG (United)
  • 20h 55m total flight
  • Arrive Kowloon Shangri-La
🇨🇳🏭

Phase 2 — Shenzhen

Jun 15–18 · Days 3–6
👤 Joaquin + Harrison (business)
  • SZIOF Trade Show
  • Eyewear factory visits
  • Futian Shangri-La (3 nights)
  • Huaqiangbei electronics market
🇭🇰🐉

Phase 3 — Hong Kong

Jun 18–21 · Days 6–9
👥 Joaquin + Martin
  • Dragon Boat Festival
  • Big Buddha + Tai O
  • Crowne Plaza Causeway Bay
  • Ocean Park + HKG depart
🇮🇹⛵

Phase 4 — Italian Riviera

Jun 22–28 · Days 10–16
👨‍👩‍👦‍👦 Full Family
  • Rapallo (Dimora in Piazza)
  • Portofino + Paraggi
  • Cinque Terre (2 days)
  • Genova → Tellaro
  • Portovenere + Palmaria
🏔️🇨🇭

Phase 5 — Lake Como

Jun 29–Jul 2 · Days 17–20
👨‍👩‍👦‍👦 Full Family
  • Como + Bellagio ferry
  • Villa Carlotta + Varenna
  • Day trip: Lugano, Switzerland
🏙️🎨

Phase 6 — Milan

Jul 3–6 · Days 21–24
👨‍👩‍👦‍👦 Full Family
  • Brera district
  • Duomo + Navigli
  • MXP → MIA (Jul 6)
📅 Day-by-Day Itinerary
All 24 days sourced from Supabase. Click any day to expand details.
🎫 Confirmed Bookings
Flights, hotels, and rentals pulled from the Supabase trip_bookings table.
🔍 Data Critique
Constructive analysis of the Supabase trip database — what's solid and what needs fixing.

✅ What's Well Done

🔴 Critical Issues

Critical Valerie + kids' outbound flight has no dates stored
Booking AA206 MIA→MXP is confirmed (conf: DPMCHM, seats 22D+22E) but start_at and end_at are null. You need the exact departure time to plan the Day 10 Malpensa family reunion correctly.
Critical Day 9 lodging is wrong — still references Shenzhen airport hotel
Day 9 lodging_summary says "Hyatt Regency Shenzhen Airport" but the itinerary was updated to depart directly from HKG (no border crossing). The Shenzhen airport hotel booking may also be outdated. This is contradictory data that will cause confusion.
Critical Day 10 metadata says "FLIGHT NOT BOOKED" but it is booked
The Lufthansa HKG→FRA→MXP flight (LH797 + LH248) is confirmed — conf: 1658112215516127, $1,398 paid. But Day 10's metadata.logistics still reads ⚠️ FLIGHT NOT BOOKED. This stale warning will cause unnecessary alarm.

🟡 Important Issues

Important trip_travelers table is completely empty
All traveler rows have null name, role, and email. Joaquin, Valerie, Martin, and Adrian should be entered for the 2026 trip at minimum. Any app feature relying on this table is broken.
Important Duplicate entries in the places table
At least 7 places appear twice: Futian Shangri-La, Tim Ho Wan, Dry Milano, Locanda Miranda, Osteria del Gallo, Ristorante Stendhal, and Yardbird. These need deduplication and foreign key consolidation.
Important Wrong coordinates — Lugano entry points to California
"Lugano Swiss restaurants" has coordinates 36.54, -121.90 — that is coastal California (near Monterey), not Switzerland. Lugano is at approximately 46.00, 8.96. Any map feature will show a wrong pin.
Important Pisa place entry has Genoa's data
The "Pisa" place record has city set to "Genoa" and coordinates for Genoa, not Pisa. Pisa is at 43.72, 10.40 — about 90km south of Genoa.
Important All cost fields in bookings are null
Actual amounts are mentioned in notes (e.g., $2,384.23 MIA→HKG, $1,398 Lufthansa, $149.56 car rental, $739.08 Rapallo Airbnb) but cost_amount / cost_currency are null everywhere. No programmatic budget tracking is possible.

🟢 Minor Issues

Minor Day 13 timing warning is unresolved
Day 13 logistics note flags "⚠️ TIMING TIGHT — Cinque Terre + Genova same day is ambitious." The plan is valid (CT day → drive Genova to sleep) but the itinerary never explicitly states this. Should be clarified to avoid confusion on the day.
Minor Day 17 mart note references removed Pisa + Lucca stops
Day 17's metadata.mart still mentions "Pisa + Lucca on the way to Milan" but those stops were removed from the day summary. Stale text that could confuse Martin.
Minor Cathedral View Como cost is TBD
Booking HMHQHTXX4M (Lake Como lodging) has cost_amount = null and a note saying "Cost: TBD from screenshot." This was never resolved and should be confirmed.
Minor trip_checklist_items likely empty
Based on the pattern of other tables, the checklist table is probably empty. Pre-trip packing and task lists would be a high-value addition before June 13.

📊 Summary Scorecard

3
Critical Issues
5
Important Issues
4
Minor Issues
A-
Itinerary Quality
🔮 Future Trip Ideas
Multi-year family travel roadmap already seeded in the database.