rckrdmrd/erp-transportistas-database-v2
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
3 Commits 1 Branch 0 Tags 64 KiB
main
Commit Graph

3 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
Adrian Flores Cortes
8de39831dc feat: Add new DDL schemas for GPS, dispatch and offline modules 
- 03a-gps-devices-ddl.sql: GPS device tracking schema
- 09-dispatch-schema-ddl.sql: Dispatch management schema
- 10-offline-schema-ddl.sql: Offline operation schema

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-30 12:11:04 -06:00
Adrian Flores Cortes
7a91823784 feat: Add complete DDL for all transport schemas (01-08) 
DDL files created:
- 01-transport-schema-ddl.sql: OT, embarques, viajes, paradas, POD, incidencias
- 02-fleet-schema-ddl.sql: unidades, remolques, operadores, documentos, asignaciones
- 03-tracking-schema-ddl.sql: posiciones GPS, eventos, geocercas, alertas, ETA
- 04-fuel-schema-ddl.sql: cargas combustible, peajes, gastos, anticipos, rendimiento
- 05-maintenance-schema-ddl.sql: planes, programacion, ordenes trabajo, checklist
- 06-carriers-schema-ddl.sql: carriers, documentos, unidades, operadores, scorecard
- 07-billing-transport-ddl.sql: lanes, tarifas, recargos, facturas, fuel surcharge
- 08-compliance-schema-ddl.sql: carta porte CFDI 3.1, HOS NOM-087, inspecciones

Features:
- All tables with tenant_id and RLS policies
- ENUMs for all status and type fields
- Proper indexes for common queries
- PostGIS for geospatial data
- Partitioned tables for high-volume GPS data
- CFDI Carta Porte 3.1 compliant structure

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-25 10:26:20 -06:00
Adrian Flores Cortes
c93e2b1e0e feat: Initial database structure for ERP Transportistas 
- PostgreSQL 15 with PostGIS extension
- 8 schemas for transport domain
- ENUMs for viaje states, unit types, events
- DDL documentation and conventions

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-25 09:51:31 -06:00