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).

cmplEventID

Primary key.