Share via


Chat Table

 

Topic Last Modified: 2011-01-27

The Chat table 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 LastChatId 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 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.

Key

Column Description

<channelID, chatD>

Primary key.