help with DB design / query please !

2008-04-08 Thread Nacho Garcia
hello, im trying to make a DB for a message system. the best way i have made is this: *TABLE conversations* (informacion de cada conversacion) . i*d_conversation (bigint) count(smallint) updated every time a new message is

Re: Help with db design

2008-04-07 Thread Richard Jones
Baron Schwartz wrote: Hi, This is a fine place to ask such questions. (In general you can just ask first, and people will tell you if you're off-topic). OK, thanks - I've posted the details to a new subject earlier today but it doesn't seem to have showed up yet. -- Richard Jones --

Re: Help with db design

2008-04-06 Thread Baron Schwartz
Hi, On Wed, Apr 2, 2008 at 5:10 PM, Richard Jones [EMAIL PROTECTED] wrote: Hi, I have a complex legacy application with around 30 tables which is in need of re-factoring, as there are tables with lots of nulls. I've partially managed to achieve this so that my queries mostly return correct

Help with db design

2008-04-02 Thread Richard Jones
Hi, I have a complex legacy application with around 30 tables which is in need of re-factoring, as there are tables with lots of nulls. I've partially managed to achieve this so that my queries mostly return correct information. But there are some circumstances where duplicate data is