Adrian Flores Cortes
|
d72145f0b7
|
feat(MMD-014): Add GPS tracking schema
- Create gps_tracking schema with 5 tables
- Tables: gps_devices, gps_positions, geofences, geofence_events, route_segments
- Add PostGIS-compatible distance functions (haversine_distance)
- Add RLS policies for multi-tenant isolation
- Add views: vw_last_positions, vw_device_summary
- Add triggers for automatic last_position updates
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
|
2026-01-27 01:33:57 -06:00 |
|