Hello, I have a system in which a number of drivers are supposed to register and work. There are also some individuals who act as owners of goods. The owners of goods can announce their loads in their own panel, and the drivers can see these loads. I want to know the overall structure of the database. Should I separate the tables for these three types of users (drivers, managers, and owners of goods), or should I keep them all in one table and manage them based on their roles and permissions?
What I have tried:
This is just a question for guidance, I haven't tried anything yet. Basically, I want the login and logout process in the system to be based on sending a one-time password to the mobile phone.