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.