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.