tblComplianceData
tblComplianceData contains the compliance events that haven't been processed by the compliance adapter yet.
Columns
| Column | Type | Description |
|---|---|---|
| cmplEventID |
bigint, not null |
Event ID. |
| entryDate |
smalldatetime, not null |
Time of insertion (might 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. |