rckrdmrd/michangarrito-database-v2
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
6 Commits 1 Branch 0 Tags 41 KiB
main
Commit Graph

6 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
rckrdmrd
ddd0c426da chore: Add .gitignore for clean repository 
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-20 07:29:19 -06:00
rckrdmrd
9f51315ea1 [MCH-006] feat: Agregar schema SQL para onboarding inteligente 
- Crear ENUMs: onboarding_status, onboarding_channel, scan_type, scan_status
- Crear tabla auth.onboarding_sessions para sesiones de configuracion
- Crear tabla catalog.product_scans para resultados OCR/audio
- Agregar indices para queries frecuentes
- Trigger para updated_at automatico

Sprint 5 - Modulo Onboarding Inteligente

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-18 04:19:48 -06:00
rckrdmrd
a9b72d8f45 [MCH-007] feat: Agregar schema SQL para templates con seeds de 8 proveedores 
- Crear ENUMs template_provider y template_giro
- Crear tabla product_templates con indice de busqueda
- Crear tabla template_imports para tracking de importaciones
- Agregar seeds de Sabritas, Coca-Cola, Bimbo, Marinela, Gamesa, Pepsi, Nestle
- Agregar seeds de productos genericos para papeleria
- Total: 85+ productos listos para importar

Sprint 5 - Inteligencia
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-18 04:11:42 -06:00
rckrdmrd
362e488ae7 feat(MCH-016): Add delivery schema DDL 
- Create delivery schema
- Add delivery_zones table with radius/polygon support
- Add deliveries table with status tracking and proof of delivery
- Add delivery_status_history for audit trail
- Add drivers table for delivery personnel
- Create updated_at triggers for all tables
- Add automatic status history logging trigger
- Create setup_default_zones() function for new tenants

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-18 03:42:57 -06:00
rckrdmrd
c730a9672d feat(notifications): Add notifications schema DDL (MCH-017) 
- Create notifications schema
- Add tables: notifications, notification_templates, notification_preferences, device_tokens
- Add indexes for performance
- Add default notification templates for orders, payments, alerts
- Add updated_at triggers

Sprint 3: MCH-017 Notificaciones

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-18 03:32:35 -06:00
rckrdmrd
ad9944d86b Initial commit 2026-01-16 14:05:46 +00:00