Ticket #1332930 (Feature Requests)

Jason Dixon jason at dixongroup.net
Fri Aug 11 21:31:33 CEST 2006

On Aug 11, 2006, at 2:08 PM, Michel Moreira wrote:

> --See the DB Structure: http://img61.imageshack.us/my.php? 
> image=erdmb5.jpg

No offense, but given the design criteria Thomas mentioned earlier  
(iCal-like), doesn't it make more sense to use a "free field"  
method?  That is, to create a single table of "contact" key/value  
pairs associated with the user id?  Then you can easily pull all  
pairs associated with the user and arrange them according to a known  
set of keys (first_name, last_name, email, phone, im_contact, etc).

This approach has worked well in the past for systems like OTRS.   
Just my $0.02.

Jason Dixon
DixonGroup Consulting

More information about the Dev mailing list