Lync Server 2013 中的 tblComplianceParticipanttblComplianceParticipant in Lync Server 2013

 

上次修改的主题: 2012-09-12Topic Last Modified: 2012-09-12

tblComplianceParticipant 包含每个通道和每台服务器的当前参与者。tblComplianceParticipant contains the current participants per channel and per server.

列数Columns

Column 类型Type 说明Description

channelUrichannelUri

nvarchar (255),不为 nullnvarchar (255), not null

通道统一资源标识符 (URI)。Channel Uniform Resource Identifier (URI).

userIduserId

int,不为 nullint, not null

参与者的主体 ID(与 tblPrincipal.prinID 表对应)。Principal ID of the participant (corresponding to tblPrincipal.prinID table).

joinedAtjoinedAt

bigint,不为 nullbigint, not null

加入事件的时间戳。Time stamp of the joining event.

partedAtpartedAt

bigintbigint

如果仍加入参与者,则为 null。如果不为 null,则为通道离开事件的时间戳。Null if participant is still joined. The time stamp of the channel leaving event if not null.

当所有转换器处理该事件时,将最终删除这些项。These entries are eventually removed when all translators process the event.

userUriuserUri

nvarchar(255),不为 nullnvarchar(255), not null

用户 URI。User URI.

serverIDserverID

intint

服务器标识(如 tblServerIdentity.serverID 表中所示)。Server identity (as in tblServerIdentity.serverID table).

sessionIdsessionId

bigintbigint

服务器会话。它是每次聊天服务启动时生成的随机数字。它用于区分会话以便标识孤立参与者。Server session. This is a random number generated each time a Chat service starts. It is used to differentiate sessions for the purpose of identifying orphaned participants.

Key

Column 说明Description

<channelUri、userId、joinedAt><channelUri, userId, joinedAt>

主键。Primary key.