Node Table

 

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.