11 Aug
2006
11 Aug
'06
9:31 p.m.
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 http://www.dixongroup.net