ComplianceParticipant Table

 

Topic Last Modified: 2011-01-27

The ComplianceParticipant table 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 Principal.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).

sessionId

bigint

Server session. This is a random number generated each time a Channel Server starts. It is used to differentiate sessions for the purpose of identifying orphaned participants.

Key

Column Description

<channelUri, userId, joinedAt>

Primary key.