ComplianceData Table

 

Topic Last Modified: 2011-01-27

The ComplianceData table contains the compliance events that have not been processed by all the registered translators yet.

Columns

Column Type Description

cmplEventID

int, not null

Event ID.

entryDate

smalldatetime, not null

Time of insertion.

cmplType

int, not null

Type of compliance event:

  • 1: Chat

  • 2: Backchat

  • 3: File download

  • 4: File upload

cmplTime

bigint, not null

Time stamp for the event.

cmplChannelUri

nvarchar (255), not null

Channel Uniform Resource Identifier (URI).

cmplChatID

bigint, not null

Chat ID (corresponding to Chat.chatId table).

cmplUserID

int, not null

Principal ID of the poster (corresponding to Principal.prinID table).

cmplUserUri

nvarchar (255), not null

User URI.

cmplMessage

nvarchar (max)

Message (corresponding to Chat.content table).

Key

Column Description

cmplEventID

Primary key.