[thelist] Proper DB Table Design...

[Travis]

Hi Joshua, thanks for the reply,

> Placing a sortorder field in the categories and documents tables is not a
> bad design.

That's good to know - I'd prefer to keep everything in the 2 tables, if
possible, rather than start creating 'meta' tables with info about other
tables - seems that could get messy, once I start down that road...

It just seemed a little strange having to have unique values across 2
tables, is all.

Thanks,

-Travis


----- Original Message ----- 
From: "Joshua Olson" <joshua at waetech.com>
To: <thelist at lists.evolt.org>
Sent: Monday, September 13, 2004 5:48 AM
Subject: RE: [thelist] Proper DB Table Design...


> > -----Original Message-----
> > From: Travis
> > Sent: Sunday, September 12, 2004 7:39 PM
> >
> > I also would like to have the ability to sort documents and categories
in
> > whatever arbitrary order I choose. The simplest way I can think of to do
> > this is to add an additional 'sortorder' column to each table,
> > and order the records numerically, so the new tables would look
> > something like this...
>
> Travis,
>
> Placing a sortorder field in the categories and documents tables is not a
> bad design.  You will also find additional benefit if the sortorder column
> in the categories table represents the category's order within the ENTIRE
> hierarchical structure, not just within the siblings.  I'll leave it to
you
> to realize why.
>
> <><><><><><><><><><>
> Joshua Olson
> Web Application Engineer
> WAE Tech Inc.
> http://www.waetech.com/service_areas/
> 706.210.0168
>
>
> -- 
>
> News! - Evolt.org conference for web professionals.
> 17-19 September 2004 in Toronto, Canada.
> Details at http://TOevolt.org
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.745 / Virus Database: 497 - Release Date: 8/28/2004