Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Table 138: Indexes for Peripheral_Default_Route Table
index_keys
index_description
index_name
RouteID
nonclustered located on PRIMARY
XIE1Peripheral_Default_Route
PeripheralID, MRDomainID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKPeripheral_Default_Route
Fields in Peripheral_Default_Route Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
The Media Routing Domain associated with this peripheral default
route.
route.
MRDomainID
PK, FK NOT NULL
DBSMALLINT
Link to the Peripheral table.
PeripheralID
FK, IE-1 NULL
DBINT
Foreign key from the Route table.
RouteID
Peripheral_Half_Hour Table
. To see database
rules for these tables, click
Central database only. Each row contains statistics for a specific peripheral for a specific half-
hour interval.
hour interval.
Related tables
(via PeripheralID)
Table 139: Indexes for Peripheral_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Peripheral_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Peripheral_Half_Hour
DateTime, PeripheralID, TimeZone,
MRDomainID
MRDomainID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKPeripheral_Half_Hour
Fields in Peripheral_Half_Hour Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of seconds the associated CTI Server was active during
the half- hour interval.
the half- hour interval.
ActiveCTIServerTimeToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
254
Chapter 2: All Tables
Peripheral_Half_Hour Table