ER - Ayuda Social Reversible y Bono Cesantia

general · er diagram.

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.

People also ask

How do I design a database schema for social assistance programs that automatically deduct outstanding loan balances from unemployment benefits?

This ER diagram shows five core entities: SOLICITANTE (applicant), GARANTE (guarantor), AYUDA_SOCIAL_REVERSIBLE (reversible aid with saldo_capital tracking), BONO_CESANTIA_PAGO_GLOBAL (unemployment benefits), and COMPENSACION_ASR_BONO (compensation records linking aid balances to benefit deductions). The schema enables automated debt recovery through foreign key relationships between applicants, t

ER - Ayuda Social Reversible y Bono Cesantia

Autointermediateentity-relationshipdatabase-designsocial-securitydata-modelingfinancial-systemspostgresql
Domain: Data EngineeringAudience: database architects designing social benefit management systems
1 views0 favoritesPublic

Created by

February 23, 2026

Updated

February 25, 2026 at 9:10 AM

Type

er

Need a custom architecture diagram?

Describe your architecture in plain English and get a production-ready Draw.io diagram in seconds. Works for AWS, Azure, GCP, Kubernetes, and more.

Generate with AI