On Fri, 11 Aug 2006 15:31:33 -0400, Jason Dixon jason@dixongroup.net wrote:
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).
I'm lost. Wasn't that what he showed? Or am I not understanding your point?
What we need is this:
That's how I see it. Coments about it?
Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador