That doesn't sound too complex. As long as you just use one users table and one user_roles table you should be good.
I also suggest you read my post on designing the database. https://tray2.se/posts/database-design
Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
Hey everyone, I work on a big project that has different functionality we do refactor on big code logic but I was confused a little bit when I want to create this logic in terms of database and best practice relation to not make complex queries :
questions : I attach owner and super admins to the company and each time department is created I query the owner and super admins I do not attach owner and super admins to any department and I work with deep relations between company department users isolate the owner and admins with own table role have company_id department with his own role with the intermediate table have dep_id role_id user_id
That doesn't sound too complex. As long as you just use one users table and one user_roles table you should be good.
I also suggest you read my post on designing the database. https://tray2.se/posts/database-design
Please or to participate in this conversation.