Skip to main content
Version: 1.0 | Date: 2026-03-11 | Status: Active

Platform Overview

Skole is a school communication and management platform connecting schools, teachers, and parents through three coordinated applications backed by a single REST API.
ComponentTechnologyPurpose
skole-api-1NestJS + Prisma + PostgreSQLUnified backend REST API
skole-parent-appExpo React NativeMobile app for parents
skole-teacher-appExpo React NativeMobile app for teachers/staff
skole-web-app-nextjsNext.jsAdmin web portal for school admins

Skole ID (skole_id)

Every entity in the platform (students, staff, notices, etc.) is scoped to a skole_id — a unique 15-character string identifying the school. This is the fundamental multi-tenancy key across all tables.

Module Registry

Module CodeModule NameAppsFile
SKOLE-AUTHAuthenticationAll01-auth#3-sub-modules—backlog
SKOLE-DASHDashboardParent, Teacher02-dashboard#3-sub-modules—backlog
SKOLE-ATNDAttendanceParent, Teacher, Web03-attendance#3-sub-modules—backlog
SKOLE-DIRYDigital DiaryParent, Teacher, Web04-digital-diary#3-sub-modules—backlog
SKOLE-ACTVActivitiesParent, Teacher, Web05-activities#3-sub-modules—backlog
SKOLE-WRITWrite To (Requests)Parent, Teacher, Web06-write-to#3-sub-modules—backlog
SKOLE-NOTBNoticeboardParent, Teacher, Web07-noticeboard#3-sub-modules—backlog
SKOLE-FOODFood MenuParent, Teacher, Web08-food-menu#3-sub-modules—backlog
SKOLE-CALSAcademic CalendarTeacher, Web09-academic-calendar#3-sub-modules—backlog
SKOLE-STUDStudent ManagementTeacher, Web10-students#3-sub-modules—backlog
SKOLE-STAFStaff ManagementWeb11-staff#3-sub-modules—backlog
SKOLE-ADMNAdmission FormWeb12-admission#3-sub-modules—backlog
SKOLE-ENGGEngagement (Comments/Reactions)Parent13-engagement#3-sub-modules—backlog
SKOLE-PROFProfile & CaretakerParent14-profile#3-sub-modules—backlog
SKOLE-FEESFeesParent15-fees#3-sub-modules—backlog
SKOLE-NOTFNotificationsTeacher16-notifications#3-sub-modules—backlog

Numbering Convention

[PROD]-[MOD]-[SUB]-[TYPE][NUM]

SKOLE-AUTH-OAU-FR001
│     │    │   │
│     │    │   └── Item type + number
│     │    └────── Sub-module (3–4 uppercase letters)
│     └─────────── Module (3–4 uppercase letters)
└──────────────────Product = SKOLE

Item Type Suffixes

CodeType
FRFunctional Requirement
NFNon-Functional Requirement
SMSub-module / Backlog item
CEConditional Expression
UIUI Screen
UCUI Component
TBDatabase Table
EPAPI Endpoint
EXExternal Service

Database Tables Quick Reference

TableModuleDescription
usersAUTHSchool admin user accounts
staffAUTH/STAFTeacher & staff records
studentsSTUDStudent records
parent_detailsAUTH/PROFParent information
parent_devicesAUTHParent device + session tokens
staff_sessionsAUTHStaff session tokens
user_sessionsAUTHAdmin user sessions
schoolsCORESchool master record
student_attendanceATNDDaily attendance records
digital_diaryDIRYDiary/homework entries
activitiesACTVSchool activities/events
write_toWRITParent-to-school requests
write_to_repliesWRITThreaded replies
noticeboardsNOTBSchool notices
food_menusFOODMenu items
food_menu_scheduleFOODMenu schedule
academic_eventsCALSCalendar events
commentsENGGComments on activities/diary
reactionsENGGLikes/loves on content
staff_studentSTUDStaff-to-student assignment
staff_designationSTAFRole + RBAC config
staff_addressSTAFStaff address
staff_leaveSTAFStaff leave records
student_addressSTUDStudent address
student_guardianSTUDGuardian information
registrationsADMNSchool registration leads