SIMBK
A school counseling-records platform handling sensitive student data: role-isolated dashboards, six-phase case management, an auditable action journal, and operational discipline most school systems never get — 214 test files and rehearsed offsite restores.
The problem
Counselors at a state senior high school were tracking hundreds of students across paper forms and scattered spreadsheets. Counseling records are among the most sensitive data a school holds, so the system needed strict role isolation, a tamper-evident action journal, and retention rules — not just nicer screens.
How it works
- Role-isolated dashboards for counselors, the principal, students, and read-only viewers, with automated role-isolation tests guarding every boundary.
- Case management built around the school's real workflow: intake, six-phase interventions, referrals, appointment scheduling with notifications, and follow-up agendas.
- An early-warning screen that groups students by attendance, violation points, academic notes, and counseling recommendations, so at-risk students surface before escalation.
- An audit journal on every administrative action, exposed through a viewer with human-readable action labels — backed by a 12-month retention policy and daily alerting.
- Operated like production, not a school project: Telegram alerts for backup freshness, audit failures, and disk pressure, plus rehearsed restore drills on local and offsite backups.
Results
- Student profiles
- 800+
- Automated tests
- 214 files
- Audit retention
- 12 months
registered in the system per its operational documentation
unit, regression, and database-integration suites run via node --test
enforced by scheduled maintenance with alerting on failure
Architecture
- Next.js App Router with Supabase (PostgreSQL) persistence and bcrypt-based authentication
- Database-integration test suite (tests/ruang-bk) exercising real workflows against a seeded database
- Operational shell scripts: scheduled retention cleanup, backup-freshness checks, Telegram alerting, and deploys with automatic cleanup and rollback archives