i am trying to make a school management web site. But i can't decide yet that user tables seperated for students, parents, teachers, management etc. Or one user table for all with role. (relation with seperated profile table) . What do you prefer?
I tried one user table for all. But its is so complicated future. And the tried seperated user table. But the structure and the laravel settings are so complicated for me. I need simple solution for now and future.
Like Tim Lewis mentionned in his comment, the user table should be for user who can login to your site. They can have roles like (Superadmin, admin, editor...) Then you could have tables for each type of persons (students, parents, teachers, ...) with specific columns and relations between each. If some types of persons should be able to login then create a user associated to a profile (student, parent...).