tblComplianceData

tblComplianceData contains the compliance events that have not been processed by the compliance adapter yet.

Columns

Column Type Description
cmplEventID
bigint, not null
Event ID.
entryDate
smalldatetime, not null
Time of insertion (may be far in the future for cmplType=9 because the entry is just a placeholder in that case).
cmplType
int, not null
Type of compliance event:
1: Chat
2: Backchat
3: File download
4: File upload
9: Provisional file transfer
10: Chat deletion (with replace)
11: Chat purging
cmplTime
bigint, not null
Time stamp for the event.
cmplChannelUri
nvarchar (255), not null
Channel Uniform Resource Identifier (URI).
cmplChatID
bigint
Chat ID (corresponding to tblChat.chatId table).
cmplUserID
int, not null
Principal ID of the poster (corresponding to tblPrincipal.prinID table).
cmplUserUri
nvarchar (255), not null
User URI.
cmplMessage
nvarchar (max)
Message (encoding depends on cmplType).

Key

Column Description
cmplEventID
Primary key.