Topic Last Modified: 2012-10-06

The Persistent Chat compliance database schema consists of the following tables.

List of Persistent Chat Server Compliance Tables

Table Description

tblComplianceData

Contains the compliance events that have not yet been processed by the configured adapter.

This table includes Persistent Chat-related events, such as chat messages and file downloads. (Participant events are tracked by the tblComplianceParticipant table.)

(The servers that processed the events in this table are listed in the tblComplianceFanout table.)

tblComplianceFanout

Contains the servers that processed a compliance event. This table is tightly coupled with the tblComplianceData table.

tblComplianceParticipant

Contains current participants per chat service and per server. It is maintained based on join and part compliance events received from the Persistent Chat service.

tblComplianceState

Contains pool-wide compliance state information.