From: Peter Brawley <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Lieven De Keyzer <[EMAIL PROTECTED]>
Subject: Re: Multi-user bookmark system
Date: Fri, 06 May 2005 11:07:48 -0500
Lieven,
Here it is.
Removing the FK looks to me like an incorrect fix to the transitive
dependen
Peter,
From: Peter Brawley <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Lieven De Keyzer <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: Multi-user bookmark system
Date: Fri, 06 May 2005 10:09:12 -0500
Lieven,
If a folder belongs to an account, why not use the accoun
Lieven,
If a folder belongs to an account, why not use the account PK as a FK in
folders?
See http://www.intelligententerprise.com/001020/celko1_1.jhtml for ideas
about SQL representation of trees.
Peter Brawley
http://www.artfulsoftware.com
-
Lieven De Keyzer wrote:
I'm writing a web-appli
I'm writing a web-application that allows users to store their bookmarks.
Each user has a tree of folders (and bookmarks belong to these folders).
The only thing I want to do with tree elements at
the same level is display them, and let the
user only go up and down in the tree by one level. No aggr