--- 🤖 Starting New Agent Attempt ---
Task: Task: Implement Session Conflict Detection using the , ciaran ciaran ciaran, and the new  and  tables.
Requirements:
1. Data Migration: Ensure the  join table is used to link multiple ciaran ciaran ciaran (where  = 1) to a single  record.
2. Location Logic: When a user selects a location, store the data in the  table. Use the  from  to differentiate specific spots (like 'Pitch 1' vs 'Pitch 2') at the same .
3. Validation Engine:     Check for overlapping sessions in  sharing the same  and .
 Loop through all  assigned to the session. For each, check the  table for overlaps and call the Google Calendar API for their personal schedule.
 Calculate travel time via Google Distance Matrix API between the coordinates of the current session and the coach's previous session on that day.
4. Hard Warning: If any  array is returned, interrupt the save process and display a Modal. The coach must click a 'Schedule Anyway' button to bypass.
5. User View: Add a 'Add to Google Calendar' helper that generates an event for the user and links to the  via a Google Maps URL.

---

### 1. The Migration & New Schema

The current schema is available in /schema

We will create a  table to store Google Places data and a  table to handle the multi-coach requirement.

locationsidgoogle_place_idnameaddresslatitudelongitudeidgoogle_place_idgoogle_place_idsession_coachessession_idcoach_idsession_idcoach_idfk_sessionsession_idtimetableidfk_coachcoach_idusersidtimetablelocation_id_locationcustom_location_labellocation_idgoogle_calendar_event_idfk_timetable_locationlocation_idlocationsid

---

### 2. Multi-Coach Conflict Engine Pseudo-code

This logic accounts for the specific table relationships in your schema.

FUNCTION validate_session(new_session, assigned_coaches):
    warnings = []

    # --- TIER 1: VENUE CONFLICT ---
    # Matches same Google Place AND same specific label (e.g. Pitch 4)
    venue_busy = DB.query(timetable).filter(
        time_overlaps(new_session),
        location_id == new_session.location_id,
        custom_location_label == new_session.custom_location_label
    ).first()
    
    IF venue_busy:
        warnings.append(f'Venue Conflict: {new_session.custom_label} is already booked.')

    # --- TIER 2: COACH LOOP (Internal & External) ---
    FOR coach_id IN assigned_coaches:
        coach = DB.query(users).get(coach_id)
        
        # A. Check other sessions in the 'session_coaches' table
        internal_overlap = DB.query(session_coaches).join(timetable).filter(
            coach_id == coach_id,
            time_overlaps(new_session)
        ).first()
        
        IF internal_overlap:
            warnings.append(f'Coach {coach.lastname}: Already assigned to a session at this time.')

        # B. Check Coach's personal Google Calendar
        gcal_events = GoogleCalendarAPI.fetch(coach.email, new_session.date)
        IF gcal_events.has_overlap(new_session.start, new_session.end):
            warnings.append(f'Coach {coach.lastname}: Has a personal Google Calendar conflict.')

        # C. Travel Check (Maps API)
        prev_session = get_coach_previous_session(coach_id, new_session.start)
        IF prev_session:
            travel = GoogleMaps.get_travel_time(prev_session.coords, new_session.coords)
            IF (new_session.start - prev_session.end) < (travel.duration + 10):
                warnings.append(f'Coach {coach.lastname}: Not enough travel time from {prev_session.location}.')

    RETURN warnings

--- 💾 ACTION REQUIRED: SAVE PROJECT STATE ---