BE-064: Create activities table migration

Track: 1 — MVP
Section: 1.17 GPS Activity Tracking (Running/Cycling)
Status: [ ] Todo
Repo: backend-api
Branch: feature/BE-064-activities-table

Done When

Table: id, user_id, activity_type (enum: run, cycle, walk, hike, swim, other), started_at, ended_at, duration_seconds, distance_meters, avg_pace_sec_per_km, avg_speed_kmh, calories, elevation_gain_meters, elevation_loss_meters, avg_heart_rate, max_heart_rate, route (JSONB — array of {lat, lng, alt, timestamp}), summary (JSONB), source (app, device, import), meta (JSONB), created_at. Index on (user_id, activity_type, started_at)

Notes

No notes yet.