tblChat

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.