Period

1
id ObjectId
*
school_id ObjectId

period_number Integer

start_time String

end_time String

name String

created_at Timestamp

updated_at Timestamp
Resource

resource_id String
*
school_id ObjectId

Announcement name String

announcement_id String resource_type String

*
school_id ObjectId link String

announcement String created_at Timestamp Discipline

created_at Timestamp School updated_at Timestamp discipline_id String

0..1 0..1
*
updated_at Timestamp 1 school_id String 1 school_id ObjectId
ExamType
1 name String comments String
id ObjectId
*
* address String student_id ObjectId
school_id ObjectId
website String created_at Timestamp
type String
phone_number String updated_at Timestamp
created_at Timestamp
established_year Date
updated_at Timestamp Student
principal_name String
1 1
student_id String
created_at Timestamp
*
guardian_id ObjectId
updated_at Timestamp
*
school_id ObjectId

name String
Grade
date_of_birth String
id ObjectId
* fees Float
school_id ObjectId
*
* class_id ObjectId
subject_id ObjectId
* age Int
student_id ObjectId
* gender String
exam_type ObjectId
enrollement_date Date
term Enum(First Term,Second Term,Third Term)
*
non_compulsory_sbj ObjectId
academic_year String
status Enum(enrolled,graduated,dropped,not enrolled)
grade String
created_at Timestamp
score Float
updated_at Timestamp
comments String

created_at Timestamp
Attendance
updated_at Timestamp
id ObjectId
*
school_id ObjectId
*
student_id ObjectId
*
schedule_id ObjectId

status Enum(Present,Absent,Late,Excused)

date Date

created_at Timestamp
Subject
0..1 updated_at Timestamp
subject_id String 1

subject_code String

compulsory Boolean
*
school_id ObjectId
* User
class_id ObjectId
0..1
1 id ObjectId
name String
0..1
user_id String
description String Class
0..1 Subscription firebaseUid String
coefficient Int 0..1
1 class_id String
* subscription_id string name String
department String school_id ObjectId
transaction_id string role Enum(admin,teacher,guardian,student)
created_at Timestamp class_level String
* email String
guardian_id ObjectId
updated_at Timestamp class_code String
student_id string[] password_hash String
created_at Timestamp
amount decimal phone String
updated_at Timestamp
email string avatar String

status boolean address String

*
expiryDate datetime school_ids ObjectId

created_at datetime created_at Timestamp

ClassSchedule updated_at datetime updated_at Timestamp

1
id ObjectId
*
class_id ObjectId
*
subject_id ObjectId

schedule_type Enum(Normal,Exam,Event)
*
period_id ObjectId
*
teacher_id ObjectId

day_of_week Enum(Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday)

created_at Timestamp

updated_at Timestamp
 Period
1
id ObjectId
*
school_id ObjectId

period_number Integer

start_time String

end_time String

name String

created_at Timestamp

updated_at Timestamp
Resource

resource_id String
*
school_id ObjectId

Announcement name String

announcement_id String resource_type String

*
school_id ObjectId link String

announcement String created_at Timestamp Discipline

created_at Timestamp School updated_at Timestamp discipline_id String

0..1 0..1
*
updated_at Timestamp 1 school_id String 1 school_id ObjectId
ExamType
1 name String comments String
id ObjectId
*
* address String student_id ObjectId
school_id ObjectId
website String created_at Timestamp
type String
phone_number String updated_at Timestamp
created_at Timestamp
established_year Date
updated_at Timestamp Student
principal_name String
1 1
student_id String
created_at Timestamp
*
guardian_id ObjectId
updated_at Timestamp
*
school_id ObjectId

name String
Grade
date_of_birth String
id ObjectId
* fees Float
school_id ObjectId
*
* class_id ObjectId
subject_id ObjectId
* age Int
student_id ObjectId
* gender String
exam_type ObjectId
enrollement_date Date
term Enum(First Term,Second Term,Third Term)
*
non_compulsory_sbj ObjectId
academic_year String
status Enum(enrolled,graduated,dropped,not enrolled)
grade String
created_at Timestamp
score Float
updated_at Timestamp
comments String

created_at Timestamp
Attendance
updated_at Timestamp
id ObjectId
*
school_id ObjectId
*
student_id ObjectId
*
schedule_id ObjectId

status Enum(Present,Absent,Late,Excused)

date Date

created_at Timestamp
Subject
0..1 updated_at Timestamp
subject_id String 1

subject_code String

compulsory Boolean
*
school_id ObjectId
* User
class_id ObjectId
0..1
1 id ObjectId
name String
0..1
user_id String
description String Class
0..1 Subscription firebaseUid String
coefficient Int 0..1
1 class_id String
* subscription_id string name String
department String school_id ObjectId
transaction_id string role Enum(admin,teacher,guardian,student)
created_at Timestamp class_level String
* email String
guardian_id ObjectId
updated_at Timestamp class_code String
student_id string[] password_hash String
created_at Timestamp
amount decimal phone String
updated_at Timestamp
email string avatar String

status boolean address String

*
expiryDate datetime school_ids ObjectId

created_at datetime created_at Timestamp

ClassSchedule updated_at datetime updated_at Timestamp

1
id ObjectId
*
class_id ObjectId
*
subject_id ObjectId

schedule_type Enum(Normal,Exam,Event)
*
period_id ObjectId
*
teacher_id ObjectId

day_of_week Enum(Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday)

created_at Timestamp

updated_at Timestamp