Developer handoff

Browser (React / TanStack Start)
   |  signed upload URL
   v
Object storage  --->  Queue  --->  Python GPU worker
   |                                  |  YOLO detect -> BoT-SORT track -> team classify
   |                                  |  camera motion -> homography -> metre coords
   |                                  |  event detection -> metrics -> xG / xT
   v                                  v
Postgres (RLS, organization_id)  <---  worker writes results + confidence

organizations(id, name, type, country)
members(id, organization_id, user_id, role)
teams(id, organization_id, name, age_group)
players(id, organization_id, team_id, jersey_number, primary_position, ...)
matches(id, organization_id, home_team_id, away_team_id, kickoff_at,
        pitch_length_m, pitch_width_m, video_analysis_status, data_quality_score)
match_videos(id, match_id, storage_path, source_type, fps, resolution)
analysis_jobs(id, match_id, video_id, status, progress_percent, model_version,
              confidence_score, quality_flags jsonb, worker_job_reference)
tracking_frames(id, match_id, period, timestamp_seconds, objects jsonb)
match_events(id, match_id, event_type, period, timestamp_seconds,
             x_start_m, y_start_m, primary_player_id, outcome,
             confidence, source, validation_status, xg)
player_match_stats(id, match_id, player_id, minutes_played, impact_score,
                   metric_payload jsonb, confidence_payload jsonb, heatmap jsonb)
team_match_stats(match_id, team_id, possession, ppda, xg, ...)
validation_items, clips, reports, exports, integrations, audit_log

-- every table: organization_id + RLS policy using has_org_access(auth.uid(), organization_id)
-- GRANT SELECT, INSERT, UPDATE, DELETE ... TO authenticated; GRANT ALL ... TO service_role;

POST /analysis-jobs            queue a job for a match video
GET  /analysis-jobs/:id        status, stage, progress, quality flags
GET  /matches/:id/tracking     ?period&start_second&end_second&sample_rate
GET  /matches/:id/events       ?event_types&player_id&min_confidence
POST /matches/:id/identity-map assign tracking IDs to players
POST /events/:id/verify        analyst verdict + corrections
POST /clips | /reports | /exports
POST /webhooks/worker-callback signed callback from GPU worker