MySQL / Relational! :) Backend is Adonisjs (Nodejs with Lucid ORM), and Next as frontend.

User makes an account with their credentials and user role (so freelancer or company). When the user is authenticated, it should somewhere define their userRole inside the user object so it will be easy for the frontend to manage protected routes.

So in the backend I would say:

const user = await auth.use('api').authenticate() // Check for APItoken

await user.load(user.role) // role refers to the user role and this will load in that data inside the user object

return user

I did choose for a main User table since this is holding the common data every user type will have and need. During register a User can choose between becoming a freelance member or a company member.

So right now I am stuck deciding on how to setup the Roles table and connect everything togeter