Topic Last Modified: 2012-09-12

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.