Hi all,
I'm designing a small database, it's essentially a tree-structure. I'm probably going to use a Modified Preorder Tree Traversal (On a side note, how is it different than an Unmodified Preorder Tree Traversal?).
Each node will have children etc, and those will have children, etc. But I want to apply data to groups of nodes. So each child will either be an actual entity, or a group of entities, which brings me to my problem.
If I have groups in one table, and entities in another, and a child can be either a group or an entity I can't store that 'ID' in the same column.
What are my options at approaching this? I've thought about writing so each child is a group, and every child is in a group (even if it's a group of one). That would solve my problem, but it seems like there could be a better solution.
Thanks, Chris
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
