Data Architecture
Supabase-ready platform schema.
The platform is designed around relational tables for roles, courses, lessons, enrolments, assignments, attendance, grades, certificates, messages and schools.
profilesUsers and roles: student, parent, tutor, school_admin, super_adminCore
schoolsInstitution profiles and rollout settingsEnterprise
coursesCourse catalogue recordsLMS
lessonsCourse modules, linked LMS resources and lesson orderLMS
enrollmentsStudent-course relationships and progressLMS
assignmentsTasks, submissions and statusAcademic
attendanceSession logsReports
gradesAssessment and CBT scoresReports
certificatesCertificate records and verification IDsProof
messagesParent/tutor/student/school communication recordsPortal