i need some information about multiple databases for a multi-tenant application ?
I am working on a project in which we are maintaining separate database for every company?
The Companies Database contain customer Data.
There is a common Database to store common information across these databases. Example Customer ID,Customer Contact Number and Customer Email etc.
A New Database is created for every new company.
If one customer belongs to company1 and same customer is added in company 2 then we need to give same customer id from company 1 to that customer across all companies.
There are many such scenarios similar to the above example.
Can any one tell me how to manage multiple databases(companies) and same customers across all companies.