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.