Export (0) Print
Expand All

Tree Table

Lync Server 2010
 

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.

 
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft