A summary of what we're building:
- Small center, single user - No complex authentication needed, just a simple system
- Soft & Friendly design - Warm colors, approachable UI for non-technical user
- Full System at Once - Complete feature set as specified
- Desktop focused, English UI - Optimized for front desk computer use
Based on your detailed requirements, here's my proposed plan:
A complete digital management system replacing paper forms, designed specifically for a non-technical desk lady with a warm, friendly interface and minimal learning curve.
- Smart Search Bar - Search students by name, phone, or group with instant results
- Quick Action Buttons - Large, colorful buttons for daily tasks (Add Student, Record Payment, Take Attendance)
- Alert Widgets - Visual cards showing:
- 🔴 Overdue payments count
- 🟡 Students with low remaining sessions
- ⚪ Today's attendance not yet recorded
- Inline editable fields (click to edit)
- Color-coded status badges (Active/Paused/Dropped)
- Auto-calculated: Remaining sessions, Attendance %, Payment status
- Quick filters sidebar (by status, payment, group, sessions)
- Soft delete only (archive, never lose data)
Opens from the right when clicking a student row:
- Personal Info Tab - Name, contact, enrollment date
- Discounts Tab - Checkboxes for discount types, percentage/fixed amount input
- Groups Tab - Enrolled groups with session usage, ability to move between groups
- Attendance Tab - Session history with Present/Absent/Excused, searchable by date
- Payments Tab - Full payment history including entrance fee, tuition, events
- Entrance Fee Section - One-time fee tracking with paid/unpaid status
- Group-based attendance view
- One-click buttons: ✓ Present | ✗ Absent | ⚠ Excused
- Auto-updates remaining sessions and attendance %
- Past attendance editable with mandatory reason field
- All changes logged in activity history
- Support for: Tuition, Partial payments, Entrance fees, Event payments
- Automatic discount application
- Entrance fee charged once only (system prevents duplicates)
- Overdue status triggers based on configurable rules
- Total collected this month
- Pending payments
- Overdue amounts
- Discounts given summary
- Group cards showing: Name, Language, Teacher, Schedule, Student count
- Add/Edit groups with session cycle settings
- Move students between groups easily
- Pause group feature (for holidays)
- Event types: Holiday, Extra class, Rescheduled session, Paid events
- Weekly/Monthly calendar view
- Events automatically affect attendance and payments
- Complete audit trail of all actions
- Tracks: Who, What, When for every change
- Searchable and filterable
- Student list export
- Attendance reports
- Payment/Finance reports
- Excel and PDF formats
Clean, normalized schema:
students- Core student datagroups- Group definitions with schedulestudent_groups- Many-to-many enrollmentattendance- Session attendance recordspayments- All payment transactionsdiscounts- Applied discountsevents- Calendar eventsteachers- Teacher infoactivity_logs- Complete audit trail
- 🎨 Soft & Friendly Theme - Warm peach/coral accents, rounded corners, gentle shadows
- 📱 Large Click Targets - Big buttons for fast daily operations
- 🔔 Visual Feedback - Toast notifications for all actions
- 💾 Auto-save - No "Save" buttons needed, changes apply immediately
- ⚡ Inline Editing - Click any field to edit directly in the table
This plan covers all your requirements in a logical build order. The system will use Supabase for the backend (database, real-time updates, and data persistence) to ensure no data is ever lost.
Does this plan align with your vision? Would you like me to adjust any priorities, add more detail to any section, or modify the approach?
Implement the plan Explain database schema in detail Describe screen layouts