Cisco Cisco Administrative Workstation Technical References
Table 188: Indexes for Service_Array_Member Table
index_keys
index_description
index_name
ServiceArraySkillTargetID
nonclustered located on PRIMARY
XIF122Service_Array_Member
ServiceSkillTargetID
nonclustered located on PRIMARY
XIF123Service_Array_Member
ServiceArraySkillTargetID,
ServiceSkillTargetID
ServiceSkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKService_Array_Member
Service_Array_Member TableConstraints:
Field Name:
Constraint:
ServiceArraySkillTargetID
PK
ServiceSkillTargetID
PK
ServiceArraySkillTargetID
FK
Fields in Service_Array_Member Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Identifies the service array.
ServiceArraySkillTargetID
PK NOT NULL
DBINT
Identifies a service that is a member of the service array.
ServiceSkillTargetID
Service_Five_Minute Table
. To see database rules for these tables, click
Central database only.
Contains statistics about each service during the most recent five-minute interval.
The ICM software generates Service_Five_Minute records for each service.
Use the Service Explorer tool to add, update, and delete Service_Array records.
Related table
(via SkillTargetID)
Table 189: Indexes for Service_Five_Minute Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Service_Five_Minute
DateTime, SkillTargetID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKService_Five_Minute
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
330
Chapter 2: All Tables
Service_Five_Minute Table