❔ Multi-tenancy - database per tenant - which database(s) to store Users?
We're using Auth0 for authentication. A given User could have access to multiple tenants. I'm envisioning a
Catalog
Catalog
database with
Tenants
Tenants
table and
Users
Users
table, as well as a
UserTenants
UserTenants
table that links the two.
However, I imagine that the tenant databases will require user information, like first name, last name, email, etc, for business logic. So does it make sense to have a