Topic Last Modified: 2012-09-12

tblNode contains the object tree (with category or chat room nodes) as managed in the Lync Server 2013 Control Panel and administrative cmdlets.

Columns

Column Type Description

nodeID

int, not null

Node ID (unique number).

nodeGuid

GUID, 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.

invite

bit

For categories:

  • True if invites are on.

  • False if invites are off.

For rooms:

  • False if invites are off (overrides the parent category).

  • Null if the invites setting is inherited from the parent category.

logged

bit

For categories:

  • True if chat history is on.

  • False if chat history is off.

For rooms:

  • Null.

filePost

bit

For categories:

  • True if file uploads are allowed.

  • False if file uploads are disallowed.

For rooms:

  • Null.

disabled

bit, not null

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

behavior

smallint, not null

Behavior (looked up in EnumValue table):

  • 4: Normal (normal chat rooms).

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

Applies only to chat rooms.

visibility

smallint, not null

Visibility (looked up on EnumValue table):

  • 2: Private

  • 3: Scoped

  • 6: Open

Applies only to chat rooms.

siopID

GUID

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

The add-in information 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 tblScopedPrincipal table and roles from tblPrincipalRole table) that affected this node. This is used by the Chat service’s internal cache update mechanism.

Keys

Column Description

nodeID

Primary key.

behavior

Foreign key with lookup in tblEnumValue.valueID table.

visibility

Foreign key with lookup in tblEnumValue.valueID table.

parentID

Foreign key with lookup in tblNode.nodeID table.

siopID

Foreign key with lookup in tblSiopWhiteList.siopId table.