Barangay DB is a normalized relational schema for municipal resident and staff management, featuring five core entities: staff, residents, family_relationships, activity_log, and system_settings. Data flows from staff and residents through foreign keys to activity_log for audit trails, while residents link bidirectionally in family_relationships for household tracking. This schema enforces referential integrity with primary and unique constraints, supporting compliance reporting, demographic analysis, and administrative accountability in barangay operations. Fork this ERD on Diagrams.so to customize fields, add indexes, or adapt it for your municipality's specific requirements. The design separates authentication (staff credentials) from resident records, enabling role-based access control and secure activity logging.