Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas

Página de 718
Table 243: Fields in Peripheral_Default_Route table
Keys and
NULL
Option
Data Type
Description
Name
PK, FK
NOT
NULL
DBINT
The Media Routing Domain associated with this
peripheral default 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
This table is one of the Peripheral tables in the
category. To see database rules for these tables, see
Central database only. Each row contains statistics for a specific peripheral for a specific half- hour interval.
Related tables
(via PeripheralID)
(via MRDomainID)
Table 244: Indexes for Peripheral_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Peripheral_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Peripheral_Half_Hour
DateTime, PeripheralID, TimeZone,
MRDomainID
clustered, unique, primary key located
on PRIMARY
XPKPeripheral_Half_Hour
The Peripheral_Interval Table will be populate with 30/15 minute reporting data, depending on the
Historical Reporting Interval setting for the PG. The Peripheral_Half_Hour Table will not be populated
with this data.
Note
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0    
343
All tables
Peripheral_Half_Hour