INSTITUTIONS<hr/>id (PK)nametypesettingscreated_by

PROFILES<hr/>id (PK)auth_idemailroleinstitution (FK)created_at

CLASSES<hr/>id (PK)namelevelis_activeinstitution (FK)

SUBJECTS<hr/>id (PK)class_id (FK)nameis_activecreated_by

CHAPTERS<hr/>id (PK)subject_id (FK)titleis_activecreated_by

CONTENTS<hr/>id (PK)chapter_id (FK)typedatais_active

USER_PROGRESS<hr/>id (PK)user_id (FK)chapter_id (FK)statusscore

ASSESSMENTS<hr/>id (PK)titletypechaptersduration

ATTEMPTS<hr/>id (PK)user_id (FK)assessment (FK)score

QUESTIONS<hr/>id (PK)chapter_id (FK)typetext

NOTES<hr/>id (PK)user_id (FK)content_id (FK)note_text

BOOKMARKS<hr/>id (PK)user_id (FK)content_id (FK)created_at

INTERACTIONS<hr/>id (PK)user_id (FK)content_id (FK)type

schema