Problem
Many numeric columns are declared INTEGER (trails.latitude/longitude/rating, territories.center_lat/lng/area_size/perimeter, activities.elevation, etc.) though they hold floats. SQLite's type affinity preserves the float values today, but this is incorrect schema that will truncate under strict mode / Postgres / MySQL, and FK-ish ids/counts are stored as REAL in places too.
Acceptance
- Regenerate migrations so numeric columns use REAL and id/count columns use INTEGER.
- Verify values survive a fresh migrate.