Am writing multiple Multi-Tenant applications with separate database per each application (I've decided to go with shared database different schema approach). Each application have Staffs Table for tenants' staffs and Customers for, well customers.
The problem am having is all my applications share the two tables and so there are going to be duplicates if each database is going to be completely independent.
I have thought of having a common database with Staffs and Customers table and have a different app (like Oauth2 server) handling the registration and login. And then have stub table Users in each multi-tenant apps with columns id
and role
(customer/staff) forming Primary key and gets their data from remote Staffs and Customers respectively.
Am not sure this is a good approach so and if there are better ways to handle that.
If am not clear let me know in comments.