About This Architecture
Entity-relationship model for a reversible social assistance and unemployment benefit compensation system. The schema links SOLICITANTE (applicant) to AYUDA_SOCIAL_REVERSIBLE (reversible social aid) with GARANTE (guarantor) backing, while BONO_CESANTIA_PAGO_GLOBAL tracks unemployment bonuses and global payments. COMPENSACION_ASR_BONO records deductions from bonuses to offset outstanding social aid balances, enabling automated debt recovery workflows. This design supports Latin American social security programs requiring guarantor-backed loans with automatic payroll deductions. Fork this ER diagram on Diagrams.so to adapt table structures, add audit fields, or export as SQL DDL for PostgreSQL or MySQL implementations.