My idea of the db structure. Sorry about the other message.
2006/8/11, Martin Marques martin@bugs.unl.edu.ar:
On Thu, 10 Aug 2006, Michel Moreira wrote:
I dont think that saving the all the field data in one vcard string is a good idea.
How about searching my contacts that live on some city, some info that is in this vcard string?
It isnt good to add a field to each contact info that is available...
I think that can be created 2 tables, one with the contact info type and one that has an 1-n relationship between the contacts table and tis contact info type table, where u can put the info.
Then u can search freely withouth performance issues and store and extends all the contact info without having too many empty fields.
This is a good idea. can we through some ideas on DB structure?
-- 21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18
Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador