Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
2-256
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Route Table
Route Table
Each row represents a possible destination for a call.
Use Configuration Manager to add, update, and delete Route records.
Related tables:
(via RouteID)
(via RouteID)
(via RouteID)
(via RouteID)
(via RouteID)
Table 2-281 Route Table Constraints
Constraint
Field Name(s)
PK
RouteID
AK-1
EnterpriseName
FK
ServiceSkillTargetID
SkillTargetID
SkillTargetID
IE-1
ServiceSkillTargetID
SkillTargetID
SkillTargetID
Table 2-282 Route 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
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
Description
Additional information about the route.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for the route. This must be
unique among all routes in the enterprise.
unique among all routes in the enterprise.
VNAME32
AK-1
NOT NULL
RouteID
Unique identifier for the route.
DBINT
PK
NOT NULL
ServiceSkillTargetID
Associated Service.SkillTargetID. Every route
that terminates at a peripheral should have a
service.
that terminates at a peripheral should have a
service.
DBINT
FK, IE-1
NULL
SkillTargetID
Foreign key from the Skill Target table that
represents the destination of the route. The
destination is a Service, Skill Group, Agent, or
Translation Route.
represents the destination of the route. The
destination is a Service, Skill Group, Agent, or
Translation Route.
DBINT
FK, IE-1
NULL