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