Cisco Cisco E-Mail Manager Unity Integration Option テクニカルリファレンス
2-314
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Service Table
Service Table
Each row describes a service available at a peripheral.
Use the Service Explorer tool to add, update, and delete Service records.
Table 2-337 Service Table Constraints
Constraint
Field Name(s)
PK
SkillTargetID
AK-1
EnterpriseName
AK-2
PeripheralID
PeripheralNumber
PeripheralNumber
FK
MRDomainID
PeripheralID
ScheduleID
SkillTargetID
PeripheralID
ScheduleID
SkillTargetID
IE-1
ScheduleID
Table 2-338 Service Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
ConfigParam
A string of parameters the ICM software sends to
the peripheral to initialize the service.
the peripheral to initialize the service.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
Description
Additional information about the service.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for the service. This name
must be unique among all the services in the
enterprise.
must be unique among all the services in the
enterprise.
VNAME32
AK-1
NOT NULL
Extension
The extension number for the skill group (used by
the Definity ECS ACD).
the Definity ECS ACD).
VTELNO10
NULL
MRDomainID
The Media Routing Domain associated with this
service.
service.
DBINT
FK
NOT NULL
PeripheralID
Foreign key from the Peripheral table.
DBSMALLINT
AK-2, FK
NOT NULL
PeripheralName
Service name as known at the peripheral.
VNAME32
NOT NULL
PeripheralNumber
Service number as known at the peripheral. This
field together with PeripheralID form an alternate
unique key.
field together with PeripheralID form an alternate
unique key.
DBINT
AK-2
NOT NULL