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.

See Also

Concepts

Node Table