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. |