RE: Database layout question...

2003-08-14 Thread Tim Blair
> Fuse Table (this table brings the pages and sections together) > -- > fuseID, sectionID, pageID I'd get rid of the fuseID and just use sectionID and pageID as a combined primary key -- you're never going to have more than one copy of a given page in a given section so you can

Re: Database layout question...

2003-08-14 Thread Matt Robertson
I did a thing I called 'mirroring' wherein the user decides individually whether or not a page somewhere else should be shown in the current location. The page record has a 'mirror' field that, if an ID is in there, then that ID is used for data retrieval rather than the 'true' current page. M

Re: Database layout question...

2003-08-14 Thread Paul Giesenhagen
Create PageTable -- pageID, content Fuse Table (this table brings the pages and sections together) -- fuseID, sectionID, pageID Section Table -- sectionID, sectionName Then, you can call ALL pages that have sectionID = XX Thus, a page