See Also
Topic Last Modified: 2011-01-27
The TreeTable table contains redundant information that can be computed from Node table. It helps optimize various types of searches through the console tree.
Columns
| Column | Type | Description |
|---|---|---|
|
treeNodeID |
int, not null |
Node ID. |
|
treeParentID |
int, not null |
Ancestor node ID. |
|
treeDepth |
int, not null |
Distance between the current node and the ancestor. |
Keys
| Column | Description |
|---|---|
|
<treeNodeID, treeParentID> |
Primary key. |
|
treeNodeID |
Foreign key with lookup in tblNode.nodeID. |
|
treeParentID |
Foreign key with lookup in tblNode.nodeID. |
