tblComplianceData
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:
|
| 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. |
