Skip to content

Coaching Management

website

A multi-tenant operations platform for coaching institutes that connects academic structure, people, attendance, finance, biometric devices, and SMS workflows.

Role
Client platform architecture and full-stack engineering
Scope
Multi-tenant RBAC, academic operations, finance, biometric integration, and messaging infrastructure
Status
Private client SaaS under active development

Problem

Coaching institutes often split student records, class structures, attendance devices, fee collection, expenses, and communication across disconnected tools. Operators need one system without allowing one organization to see or mutate another organization’s data.

Constraints

  1. C1

    Every academic and financial workflow must preserve organization isolation and granular role permissions.

  2. C2

    Students and teachers share physical biometric devices even though they have different domain records and responsibilities.

  3. C3

    Payments and other critical business records require audit history and recoverable soft deletion rather than destructive removal.

  4. C4

    Bangla SMS campaigns and attendance alerts must respect provider limits, scheduling, batching, and delivery state.

Architecture

Next.js App Router combines server-rendered reads with interactive client workflows, Prisma models PostgreSQL tenancy and audit state, Supabase provides database and identity infrastructure, and adapter boundaries isolate biometric devices and SMS providers.

01

Application interface

Next.js server and client components, shadcn/ui, TanStack Table, forms, and optimistic operational workflows.

02

Academic and finance domain

Organizations, roles, levels, subjects, class sections, enrollments, attendance, fees, payments, expenses, and audit records.

03

Persistence and identity

Prisma over PostgreSQL with Supabase-backed authentication, indexed tenant queries, and soft-delete history.

04

Operational integrations

Vendor adapters normalize biometric devices while encrypted credentials, scheduled polling, SMS queues, and provider clients stay behind server boundaries.

Decisions

D1

Make organization scope part of every protected query

Tenant identity and role checks are applied at server boundaries so client state cannot broaden access to academic or financial records.

D2

Normalize biometric vendors behind an adapter

Steller and Tipsoi integrations implement one internal device contract, allowing attendance workflows to remain stable when hardware protocols differ.

D3

Preserve critical records with soft-delete audit trails

Students, teachers, payments, and related business records retain deletion reasons and history instead of disappearing through irreversible mutations.

D4

Combine server reads with targeted client caching

Server Components handle initial data and access boundaries while TanStack Query supports high-interaction screens without turning the whole application into client state.

Contribution

  • Designed the multi-tenant organization, role, academic, finance, attendance, and audit data model.
  • Built management workflows for students, teachers, class sections, enrollment, fees, payments, expenses, and administrative roles.
  • Defined the encrypted biometric credential boundary, shared device identity strategy, polling workflow, and vendor adapter model.
  • Implemented the SMS scheduling and batch-delivery architecture for attendance notifications and marketing outreach.

Outcomes

  • Institute operators can manage academic, attendance, financial, and communication work from one tenant-aware platform.
  • Granular roles separate platform administration, organization administration, finance, and academic coordination.
  • Multiple biometric device vendors can feed one attendance model without leaking vendor-specific behavior into core workflows.
  • Financial corrections and record removal retain audit evidence instead of erasing operational history.

Verified stack

  • Next.js
  • React 19
  • TypeScript
  • PostgreSQL
  • Supabase
  • Prisma
  • TanStack Query
  • shadcn/ui
  • Tailwind CSS
  • Zod
  • Vitest
  • System Design

Working through something similar?

Share your challenge, scope, and timeline to start a focused conversation.