Technical References

Table 138: Indexes for Peripheral_Default_Route Table
index_keysindex_descriptionindex_name
RouteIDnonclustered located on PRIMARYXIE1Peripheral_Default_Route
PeripheralID, MRDomainIDclustered, unique, primary key
located on PRIMARY
XPKPeripheral_Default_Route
Fields in Peripheral_Default_Route Table:
Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
The Media Routing Domain associated with this peripheral default
route.
MRDomainID
PK, FK NOT NULLDBSMALLINT
Link to the Peripheral table.
PeripheralID
FK, IE-1 NULLDBINT
Foreign key from the Route table.
RouteID
Peripheral_Half_Hour Table
This table is one of the Peripheral tables in the Device category (page 441). To see database
rules for these tables, click here (page 504).
Central database only. Each row contains statistics for a specific peripheral for a specific half-
hour interval.
Related tables
Peripheral (page 250) (via PeripheralID)
Media Routing Domain (page 234) (via MRDomainID)
Table 139: Indexes for Peripheral_Half_Hour Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Peripheral_Half_Hour
DbDateTimenonclustered located on PRIMARYXIE1Peripheral_Half_Hour
DateTime, PeripheralID, TimeZone,
MRDomainID
clustered, unique, primary key
located on PRIMARY
XPKPeripheral_Half_Hour
Fields in Peripheral_Half_Hour Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Number of seconds the associated CTI Server was active during
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