Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |