EduWav

EduWav is a full-stack, multi-tenant SaaS ERP built for educational institutions that need structured, year-bounded operations. It treats the academic year as a first-class architectural boundary across students, staff, attendance, fees, examinations, transport, hostel, HRMS, documents, ID cards, and reporting — so a year transition is a structured database operation, not a manual reconciliation.

Educational institutions manage workflows that reset or evolve every academic year. Flat ERP data models make year transitions fragile and reporting unreliable — the most common failure mode in school software.

Designed an academic-year-aware data model where every operational entity links to an explicit academic year record. Year transitions become structured, transactional operations rather than date-filtered assumptions.

React + TypeScript frontend, Node.js/Express API, a PostgreSQL data model where every operational table carries an academic_year_id, Redis for caching and queues, Docker Compose for local services, and role-scoped API boundaries for admin, teacher, student, and parent portals.

• Enforcing the academic-year boundary consistently at the query level, not just in the schema — every service function that touches operational data requires an explicit academicYearId parameter
• Designing year-close/year-open as a safe, multi-step database transaction (promotions, fee-template carry-forward, alumni marking) instead of a destructive script

• Made the academic year a first-class entity (academic_years, student_year_enrollments) rather than a date-filtered attribute
• Kept student identity records thin — all operational state hangs off year-scoped enrollment records

• Active development with the admin dashboard, records, attendance, fee collection, receipts, and institutional workflows functional end to end

• Source repository

• Building an Academic-Year-Aware School ERP