tblComplianceParticipant

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.