Local summary database file structure

The ID fields define the relationships in the database tables. For example, managerID defines a relationship with a manager. This field contains a value in the ID field that corresponds to a specific manager record in the managers table.

The following database schema shows the relationships among the tables.

Figure: Local database schema

Note:

In the following tables, field data types are enclosed in <angle brackets>.

The following table describes the local summary database tables.

Table: Local summary database tables

Table Name	Description
Agents	Agents for which summary data has been received
AgentTrend	Agent level and score data points
DatabaseInfo	Microsoft Access .mdb file identity
DomainAgent	Relation table for the Domain/Agent many-to-many relationship
Domains	Domains for which summary data has been received
DomainTrend	Domain level and score data points
LatestAgentPolicyRuns	Relation table for the policy runs to agents relationship
Managers	Managers for which summary data has been received
ManagerTrend	Manager level and score data points
MessageInstance	Each specific instance of a message
Messages	Messages from the policy runs
Modules	Module list for each manager
Policies	Policies for which summary data has been received
PolicyModule	Relation table for the Policy/Domain many to many relationship
PolicyRuns	Policy run data
PolicyTrend	Policy level and score data points
RegionManager	Relation table for the Region/Manager many-t- many relationship
Regions	Regions for which summary data has been received
RegionTrend	Region level and score data points