[Vtigercrm-developers] New way to store phone numbers, email addresses and postal addresses

[Mike Fedyk]

Comments?

> (23:36:53) *mfedyk:* does anyone know if 5.0 has any db changes in 
> storing phone numbers, email addresses and postal addresses?
> (23:39:11) *mfedyk:* I've been thinking we need one table that stores 
> them in one field with a data type and a subtype
> (23:40:25) *mfedyk:* so if you're searching for a phone number it 
> wouldn't matter if it was phone fax, mobile or pager (and you wouldn't 
> need custom fields if you have lots of phone numbers per lead, contact 
> or account.
> (23:41:31) *mfedyk:* see, because one of the uses of crm is in those 
> "save your ass" type situations. You know the phone number that is 
> calling you and you're talking to them but forgot their name (for 
> instance).
> (23:41:46) *mfedyk:* this way you don't have to search in phone number
> (23:42:01) *mfedyk:* then mobile
> (23:42:34) *mfedyk:* or any of the custom fields you've added for 
> phone numbers.
> (23:45:37) *mfedyk:* the table would have these fields: crmid, data 
> type (phone, email, web site, etc.), subtype (phone, fax, office, 
> mobile -- any division under the main type), data_field (VARCHAR(50))