rckrdmrd/erp-mecanicas-diesel-database-v2
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
10 Commits 1 Branch 0 Tags 111 KiB
main
Commit Graph

7 Commits

Author SHA1 Message Date
Adrian Flores Cortes
9902b4bbe1 feat(MMD-012): Add field service schema 
- Create field_service schema with 11 tables
- Add 5 enums: checklist_item_type, diagnosis_type, sync_status, checklist_status, worklog_status
- Add tables: service_checklists, checklist_item_templates, checklist_responses, checklist_item_responses, work_logs, activity_catalog, diagnosis_records, root_cause_catalog, field_evidence, offline_queue_items, field_checkins
- Add 4 views: vw_active_work_logs, vw_pending_sync, vw_technician_activity, vw_checklist_summary
- Add triggers for duration calculation and count updates
- Add RLS policies for multi-tenant isolation

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-27 02:42:50 -06:00
Adrian Flores Cortes
a746fdcd31 feat(MMD-011): Add dispatch center schema 
- Create dispatch schema with 7 tables
- dispatch_boards, unit_statuses, technician_skills, technician_shifts
- dispatch_rules, escalation_rules, dispatch_logs
- 5 enums for status, shift types, skill levels, channels, actions
- 4 views for available units, shifts, expiring skills, activity
- RLS policies for multi-tenant isolation
- Triggers for updated_at and status change logging

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-27 02:21:19 -06:00
Adrian Flores Cortes
daabe5320a feat(MMD-013): Add assets schema DDL 
- 6 tables: asset_categories, assets, asset_assignments, asset_audits, asset_audit_items, asset_maintenance
- Multiple enums for status tracking
- RLS policies for multi-tenancy
- Triggers for automatic updates
- Views for common queries

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-27 01:44:49 -06:00
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
Adrian Flores Cortes
863ab28b09 [MMD-010] feat: Add fiados schema for customer credit management 
- Create customer_credit_accounts table
- Create fiados table for credit sales
- Create fiado_payments table for payment tracking
- Add view v_customer_credit_summary
- Add indexes and RLS policies

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-25 08:22:30 -06:00
Adrian Flores Cortes
5cf220326a [PROP-CORE-004] feat: Add payment_terminals schema DDL 
Propagated from erp-core v1.5.0
Use: Cobro de servicios, venta refacciones mostrador

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-25 02:47:05 -06:00
rckrdmrd
40371c6151 Migración desde erp-mecanicas-diesel/database - Estándar multi-repo v2 
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-16 08:11:31 -06:00