[thelist] Photo Gallery Database Scheme

[Joshua Olson]

> -----Original Message-----
> From: Michele Foster - WizarDev
> Sent: Monday, June 13, 2005 8:03 PM

> So, my question is ... should I have separate tables for each 
> generation?
> Or just one family table with all relationships.  I'm 
> planning to have ID,
> Title, Path, DateCreated, WhateverElseStrikesMyFancy, in the 
> Parent table.
> If I go the separate table route those tables will also have a field
> ChildOf, or I can add it to the Family table, so for example

Michele,

I'd shoot for one table, no matter what.  The exact contents of the table...
well, that can vary.

Start here:

http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/404
7/?format=print

<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168 

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/