Cisco Cisco Customer Voice Portal 8.0(1)

Page of 132
Figure 39: Summary Tables
Figure 40: Trunk Group Utilization Tables
Keys
The documentation for the reporting schema lists fields as PKFKAK, or No.
Fields are designated in this document as Primary Key (PK), Foreign Key (FK), or Alternate
Key (AK) for informational purposes only. For performance reasons, the schema does not
enforce Primary, Foreign, or Alternate keys. When the Index column for a field shows FK or
AK
, it means that a field can be looked up to return a text explanation of the code in another
table.
Primary and Alternate Keys are in fact supported by an index. Major Foreign Keys (CallGUID,
SessionID, ElementID) will have a supporting index. Foreign Keys which refer to lookup tables
are not supported by an index.
Reporting Guide for Cisco Unified Customer Voice Portal Release 8.0(1)
56
Chapter 4: Database Schema
Data Model Diagram