Re: Tree (forest) design
From: Neo <neo55592_at_hotmail.com>
Date: 4 Mar 2004 11:09:42 -0800
Message-ID: <4b45d3ad.0403041109.369252c8_at_posting.google.com>
10 T_Bin
11 T_Part
Date: 4 Mar 2004 11:09:42 -0800
Message-ID: <4b45d3ad.0403041109.369252c8_at_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 - 20:09:42 CET