Topic Last Modified: 2012-09-12

tblComplianceParticipant contains the current participants per channel and per server.

Columns

Column Type Description

channelUri

nvarchar (255), not null

Channel Uniform Resource Identifier (URI).

userId

int, not null

Principal ID of the participant (corresponding to tblPrincipal.prinID table).

joinedAt

bigint, not null

Time stamp of the joining event.

partedAt

bigint

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.

userUri

nvarchar(255), not null

User URI.

serverID

int

Server identity (as in tblServerIdentity.serverID table).

sessionId

bigint

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>

Primary key.