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 adde

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 -- My

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 co

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 returne