I am working on a small CRM application based on PHP & MySQL. I am following SaaS architecture. Single Code base and every client have their own database.
Keep in mind all contact informations should be imported from CSV.
My objective is to allow clients to modify contact table structure. I mean each client can define their own table structure.
Example:
-
A client from photography industry, like to collect customer information as follows:
Name, Address, City, State, Country, Phone, email, whatsapp
-
Whereas another client from SEO industry, ike to collect customer information as follows:
First Name, Last Name, Address, City, State, Country, Phone, email, website, skype
What would be the best table structure to match all needs.
I hope I have explained my question clearly, If you face any difficulty understanding my question, please comment, I will correct it.