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