Database Setup - Roles/Permissions

Hi @sakaye87 ,

Not sure if this is what you need, but as far as permissions and roles go, this should get you started: https://laracasts.com/discuss/channels/general-discussion/check-if-user-has-admin-role I just found the topic a couple days ago, as I will be doing something similar in the coming days/weeks.

The role of the user can be saved as a "role" column in the "users" table, I personally would choose a enum field. The permissions are really easy to declare with Laravel, see Authorization:

$gate->define('evaluation-tools', function ($user) {
    return $user->role == 'teacher';
});

Which kind of information do you have to store about the students?

You can go with another table, like "students_info", and set a one-to-one relationship.

Thanks @TheNodi. I like your approach to my problem. None of my users will ever have more than 1 role so saving it on the users table should work and a separate table for additional student information is good too.