tblChat in Lync Server 2013

 

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.