Re: Tree (forest) design

From: Neo <neo55592_at_hotmail.com>
Date: 4 Mar 2004 11:09:42 -0800
Message-ID: <4b45d3ad.0403041109.369252c8@posting.google.com>

> Thank you fot the information and pointer. I wll look at it tomorrow.

One way to implement a similar design with typical databases is to create a table where each row relates the parent and child rows of various other tables. The referred tables would need each of their rows identified by a GUID.

T_Hierarchy
ParentTbl_ID
ParentTblRow_GUID
ChildTbl_ID
ChildTblRow_GUID

T_Table

1 T_Country
2 T_Region
3 T_State
4 T_City
5 T_Site
6 T_Building
7 T_Floor
8 T_Room
9 T_Rack

10 T_Bin
11 T_Part

T_Country
GUID
Name
Population

Etc... Received on Thu Mar 04 2004 - 13:09:42 CST