Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

tblChat

 

Topic Last Modified: 2012-09-12

tblChat contains all chat messages.

Columns

Column Type Description

channelId

int, not null

Node ID.

chatId

bigint, not null

Unique sequential number (per node ID) that defines the chat room order, generated by tblLastChatId table.

chatDate

bigint, not null

Time stamp for the chat message.

userId

int, not null

Principal ID of the poster.

isAlert

bit, not null

True if the message is an alert message. False if it is not.

content

nvarchar (max), not null

Chat content (the plain text version). The content is usually in plain text with the following exceptions:

  • Files are represented as ma-filelink: links.
  • Links are represented as an HTML element (although the type of content cannot be considered HTML).
  • Stories are encoded as a “[STORY]....”-like format.

rtf

varchar(max)

Chat content (the RTF version). May be Null if client doesn’t provide it.

Key

Column Description

<channelID, chatD>

Primary key.

 
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.