Topic Last Modified: 2011-01-26

The Node table contains the console tree (with category or chat room nodes) as managed in Microsoft Lync Server 2010, Group Chat Admin Tool.

Columns

Column Type Description

nodeID

int, not null

Node ID (unique number).

nodeGuid

uuid, not null

Node GUID.

parentID

int

Node ID of parent. The root node (with ID 1) includes itself as parent as well.

nodeType

bit, not null

True if the node is a category.

False if the node is a chat room.

nodeName

nvarchar (256), not null

Node name.

nodeDesc

nvarchar (256), not null

Node description.

topic

nvarchar (256), not null

Topic (for chat rooms only).

filestoreURI

nvarchar (256)

Uniform Resource Identifier (URI) of the file repository web service. It is used by only the root node. Other entries use Null.

inheritance

bit, not null

True if all children nodes must inherit the settings of this category node. Applies only to categories.

False for chat rooms.

scopeChange

bit, not null

True if subcategories are allowed to change (narrow down) the scope. Applies only to categories.

False for chat rooms.

overrideMember

bit, not null

True if the membership is overridden in the current node.

invite

bit

True if invites are on.

False if invites are off.

Null if the invites setting is inherited.

logged

bit

True if chat history is on.

False if chat history is off.

Null if the chat history setting is inherited.

filePost

bit

True if file uploads are allowed.

False if file uploads are disallowed.

Null if the file uploads setting is inherited.

disabled

bit, not null

True if the chat room is disabled. Applies only to chat rooms. (False for categories.)

restrictChildCreate

bit

True if child creation is allowed.

False if child creation is disallowed.

Null if the child creation setting is inherited.

behavior

smallint, not null

Behavior (looked up in EnumValue table):

  • 4: Normal (normal chat rooms and all categories)

  • 5: Auditorium (auditorium chat rooms, only presenters can contribute)

  • 6: AdHoc (not used)

visibility

smallint

Visibility (looked up on EnumValue table):

  • 1: Secret (not used)

  • 2: Private

  • 3: Scoped

  • Null: Inherited

scopeDefinerId

int, not null

ID of the node in the hierarchy that has the associated scope defined in ScopedPrincipal table and that is relevant to the current node.

roleDefinerId

int, not null

ID of the node in the hierarchy that can be used as a starting point to compute associated member roles that are defined in PrincipalRole table and that are relevant to the current node.

In other words, this is the node where a new membership was created. This column affects only the computation of membership. The list of managers cannot be reset, so the equivalent definer node is the root. (Voiced roles are applied only to chat rooms, so the equivalent definer node is the current one.)

siopId

uuid

Add-In GUID if an add-in is associated with this chat room. (Categories do not have add-ins.)

The add-in info is looked up in SiopWhiteList table.

nodeAddedBy

int, not null

ID of the principal that created this node.

nodeAddedOn

bigint, not null

Time stamp of the node creation.

nodeUpdatedBy

int, not null

ID of the principal that did the latest update of this node.

nodeUpdatedOn

bigint, not null

Time stamp of the latest update of this node.

purgedOn

datetime

Time of the latest purge operation (removal of scopes from ScopedPrincipal table and roles from PrincipalRole table) that affected this node. This is used by the Channel Server’s internal cache update mechanism.

Keys

Column Description

nodeID

Primary key.

behavior

Foreign key with lookup in EnumValue.valueID table.

visibility

Foreign key with lookup in EnumValue.valueID table.

parent

Foreign key with lookup in Node.nodeID table.

siopId

Foreign key with lookup in SiopWhiteList.siopId table.