tblNode
tblNode contains the object tree (with category or chat room nodes) as managed in the 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. |