[thelist] Photo Gallery Database Scheme

Joshua Olson joshua at waetech.com
Mon Jun 13 21:13:02 CDT 2005


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




More information about the thelist mailing list