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

3 Commits

Author SHA1 Message Date
Adrian Flores Cortes
094cbe3ffb [EPIC-002] feat: Add user_id FK to employees + rename warehouse_type 
T2.1: Renamed warehouse_type -> construction_warehouse_type
      in almacenes_proyecto to avoid naming conflict with ERP-Core

T2.3: Added user_id column to hr.employees
      - Optional FK to auth.users (employee may not have system access)
      - Unique constraint for 1:1 mapping
      - Conditional FK (only created if auth.users exists)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-02-04 00:20:02 -06:00
Adrian Flores Cortes
2b69098fd4 [EPIC-001-FK-DEBILES] feat(ddl): Add conditional FK constraints to fix weak references 
Add 19 conditional FK constraints to 4 schema files:
- 06-inventory-ext: 7 FKs (warehouses, products, uom, stock_moves)
- 07-purchase-ext: 5 FKs (purchase_orders, partners, products)
- 03-hse: 3 FKs (almacen_temporal for EPP)
- 10-documents: 4 FKs (documents, users)

Features:
- Constraints are conditional (only created if target tables exist)
- Idempotent (can be re-run without errors)
- Added 6 new indexes for FK fields

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-02-04 00:00:23 -06:00
rckrdmrd
bf97e26cdf Migración desde erp-construccion/database - Estándar multi-repo v2 
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-16 08:11:21 -06:00