Design Decisions - Which is the best

A. Having multiple users tables - Admin, Teacher, Parent, Student, and having the same for other tables, Admin-Attendance, Teacher-Attendance, Parent-Attendance, Student-Attendance.

B. Having one users table with access rights column, Admin, Teacher, Parent, Student, and having one Attendance table with Access-right. So I can easily sort.

Or any other way of doing it would be happily accepted into consideration.

jlrdw

5 years ago

Best Answer

Level 75

@randy_johnson you have probably seen this answer before.

Authentication for login, and Authorization do determine who can do what once logged in. So one users table.

Also watch the authentication videos here https://laracasts.com/series/laravel-6-from-scratch

Beginning at episode 50. He has several free ones on authorization.

1 like

Please or to participate in this conversation.