I am creating a Multi Tenant application which each individual Tenant will have their own list of users (able to login as well).
As this is the first time I am developing such application I am unsure what is the best practice to store those sub users under every Tenant.
Current design:
Master User Database (stores login credentials of multiple tenants)
Tenant Database (each tenant will have their individual database)
To allow individual Tenant to have their own sub users, I am thinking to add a new Table under individual Tenant Database. Another way is to add a new Table under Master User Database which will store all those information.
Also, the login should be done at a centralized login portal whereby Tenant or sub users will do the login there and will redirected accordingly.
But after logging in, I am unsure if it is best to redirect to Tenant sub domains or a general dashboard.
Anyone have experience in these and can give me some solid suggestions?
EDIT 2017-04-20: On another thought, I think that it might not be advisable for sub users of Tenant to store in Master User Database since it will be exposed? But if users are to be stored in individual Tenant database then how can a centralized login portal works?