Papa Escola — Complete School Management Ecosystem
The complete school operating system — Parent Portal + Admin ERP + Public Website — built for Montessori, loved by parents.
About This Project
Papa Escola is a production-grade school management ecosystem consisting of three interconnected applications sharing a unified Prisma-backed PostgreSQL database with role-based access control, full audit logging, and TN EMIS compliance.
🏗️Architecture Overview
Papa Escola is a monorepo-based multi-app platform built with a shared database layer and independent deployment pipelines.
| Application | Purpose | Auth Model | Deployment |
|---|---|---|---|
| Parent Portal | Real-time child tracking for parents | Phone + DOB 2-step auth | parent-papaescola.vercel.app |
| Admin ERP | School operations management | Email + Password with RBAC | admin-papaescola.vercel.app |
| Marketing Website | Public school website and admissions | Public (no auth) | papaescola.vercel.app |
📱App 1: Parent Portal — Mobile-First PWA
A mobile-first progressive web app that gives parents real-time visibility into their child's school life — no app download required.
Key Features
Personalized Dashboard
Greeting with child's name, class, section, and profile photo
Attendance Summary
Visual donut chart with present/absent/holiday breakdown and color-coded monthly calendar
Quick Access Grid
10+ module icons: Gallery, Homework, Calendar, Meal Menu, Fees, Messages, Reports, Transport, Events, SOS
Fee Management
Detailed term-wise breakdown with payment history, approved receipts, and outstanding balance alerts
Homework and Diary
Daily homework pushes from teachers, circulars, and teacher remarks per student
Photo Gallery
School event photos organized by category with date stamps
Meal Menu
Weekly meal schedule with day-wise breakfast, lunch, and snack details
SOS Emergency Button
One-tap emergency contact to school with real-time location sharing
4+ Notification Types
Attendance alerts, homework reminders, fee due dates, circular broadcasts, event invitations
-Step Authentication
Phone number + Date of Birth verification — no password needed
Design and UI/UX
Home, Academics, Fees, More
🖥️App 2: Admin ERP Dashboard
A comprehensive school management console for principals, administrators, and teachers to manage all school operations from a single dashboard.
Key Features
At-a-Glance Stats
Total Students (156), Classes (8), Teachers (12), Parent Accounts (142) in glassmorphic stat cards
Quick Actions
6 one-click cards: Add Student, Mark Attendance, Send Circular, Collect Fees, Assign Homework, View Reports
Command Palette
Instant fuzzy search across all modules, students, and actions with keyboard shortcut
Student Management
Full CRUD with profile photos, parent mapping, class assignments, and EMIS ID tracking
Attendance System
Class-wise daily marking with Present/Absent/Late/Holiday states and TN EMIS compliance
Fee Collection
Fee schedule configuration per class/term, payment recording with receipt generation, and outstanding tracking
Circular and Communication
Broadcast messages to all parents or filtered by class, with read receipts and delivery tracking
Homework Management
Class-wise homework assignment with due dates, subject tagging, and parent portal push
Analytics Dashboard
Attendance trends, fee collection rates, enrollment statistics, and teacher performance metrics
Multi-Branch Ready
Architecture supports multiple school branches with centralized admin
Design and UI/UX
🌐App 3: Public Marketing Website
A conversion-optimized Montessori preschool website serving as the school's digital storefront for driving admissions and parent engagement.
Key Features
Playful Hero Section
Vibrant gradient background with 3D illustrations of children learning
Program Showcase
4 age-specific programs: Play Group, Nursery, LKG, UKG with developmental goals
Photo Gallery
School photos showcasing classrooms, activities, and events
Admission CTA
Enroll Now buttons with contact forms and WhatsApp integration
Achievements
School milestones, awards, and parent testimonials
Location and Contact
Google Maps embed, address, phone, email, and operating hours
SEO Optimized
Structured data, meta tags, and sitemap for organic search visibility
Design and UI/UX
Home, About Us, Programs, Facilities, Admissions, Blog, Contact
🛠️Technical Architecture
| Layer | Technologies | Details |
|---|---|---|
| Frontend | Next.js 15, React 19, TypeScript | 3 independent apps with shared components |
| Styling | Tailwind CSS v4, Material Design 3 | Unified design tokens across all apps |
| Database | PostgreSQL via Supabase | 25+ Prisma models with full relation mapping |
| Auth | Supabase Auth | Custom JWT claims for role-based access |
| Deployment | Vercel | Independent deployments per app |
| Monorepo | Turborepo | Shared packages for DB, utils, and UI |
Database Schema Highlights
5+ Prisma models
Full relation mapping with cascade rules
Row-Level Security
RLS policies on all sensitive tables
Audit columns
created_at, updated_at, created_by, updated_by on every table
Soft deletes
is_deleted flag and deleted_at timestamp
Composite indexes
Optimized for common query patterns
EMIS-compliant
Student ID and attendance schemas for Tamil Nadu
Key Technical Decisions
Monorepo
Turborepo with shared packages for database, utils, and UI components
Type Safety
End-to-end TypeScript with Zod validation on all inputs
Auth Strategy
Supabase Auth with custom JWT claims for role-based access
Deployment
Independent Vercel deployments per app with shared database
State Management
Server Components + React Server Actions (zero client-side state libraries)
Styling
Tailwind CSS v4 with Material Design 3 design tokens