Unified Civil Records Platform
Enterprise web platform for digitizing civil registry operations — citizen management, automatic National ID generation, civil events (birth/marriage/divorce/death), RBAC, audit trail, and official PDF issuance with QR codes.
نظرة عامة
The Unified Civil Records Platform is an enterprise-grade digital administration app built for civil registry officers and auditors. It features multi-role access control (RBAC), automated national ID creation, family tree mapping, civil event approvals (birth, marriage, divorce, death), real-time global search with debouncing, multi-criteria filtering, full audit trail logging with visual diffs, and instant PDF document generation with QR code verification.
الميزات الرئيسية
Automated National ID generation algorithm based on birth year & region code
Family Tree mapping linking citizens to parents directly in PostgreSQL
Civil event lifecycle management (Birth, Marriage, Divorce, Death) with approval workflow
1-click official PDF document issuance with QR code archiving and instant preview
Role-Based Access Control (RBAC) securing routes for Admin, Officer, and Auditor roles
Full audit trail recording all entity modifications with visual side-by-side diffs
التقنيات المستخدمة
التحديات والحلول
Designing a relational schema in Prisma supporting recursive family tree links and multi-type civil events without performance degradation — resolved using optimized PostgreSQL indices and lazy relation loading.
Ensuring strict data integrity and non-repudiation for audit logs across async server actions — implemented transactional middleware capturing before-and-after snapshots.
Generating client and server-side official PDFs with embedded QR codes dynamically while keeping document size small and render times under 500ms.
النتائج والأثر
100% Type-safe server actions and database queries with Next.js 16 and Prisma 7
Comprehensive test suite written with Vitest and React Testing Library
Full enterprise-ready architecture supporting real-world civil registry operations