- DB Security:
- users:
- student account: ❌ (CAN VIEW ALL DETAILS SUCH AS DOB, PHONE OF ALL TEACHERS!!! TO BE FIXED WITH PB HOOK)
- teacher account: ❌ (CAN VIEW ALL DETAILS SUCH AS DOB, PHONE OF ALL STUDENTS!!! TO BE FIXED WITH PB HOOK)
- classes:
- student account: ✅ (only classes that student is in)
- teacher account: ❌ (HAS HOOK BUT NEEDS UPDATE FOR NEW SCHEMA, TEACHERS CANT VIEW ONLY CLASS NAMES FOR MESSAGING)
- grades:
- student account: ✅ (only own grades)
- teacher account: ❌ (HAS HOOK BUT NEEDS UPDATE FOR NEW SCHEMA)
- rooms:
- student account: ✅ (public)
- teacher account: ✅ (public)
- subjects:
- student account: ✅ (public)
- teacher account: ✅ (public)
- timeframes:
- student account: ✅ (public)
- teacher account: ✅ (public)
- timeframes:
- student account: ✅ (only classes that student is in)
- teacher account: ❌ (IS SECURE BUT NON ADMINS CAN'T VIEW THEIR CLASSES TIMETABLES, PB HOOK NEEDED)
- messages:
- student account: ✅ (only messages sent or received by student)
- teacher account: ✅ (only messages sent or received by teacher)
- users:
:mewo: