Cisco Cisco IPCC Web Option テクニカルリファレンス

ページ / 548
   
2-119
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Customer_Definition Table
Customer_Definition Table
Each row defines a customer associated with an ICM instance.
Use the Customer list tool to create, update, or delete a customer definition.
Related tables:
 (via CustomerDefinitionID)
 (via ICRInstanceID)
 (via NetworkTargetID)
Table 2-101 Customer Definition Table Constraints
Constraint
Field Name(s)
PK
CustomerDefinitionID
AK-1
EnterpriseName
FK
FeatureSetID
ICRInstanceID
NetworkTargetID
IE-1
ICRInstanceID
Table 2-102 Customer Definition Table
Field Name
Description
Data Type
Keys and 
Null Option
ChangeStamp
Incremented when the record is changed in the 
central database.
CHANGESTAMP
NOT NULL
CustomerDefinitionID
A unique identifier for the customer definition.
DBINT
PK
NOT NULL
Description
Additional information about the customer 
definition.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for the customer. This name 
must be unique among all customer definitions in 
the enterprise.
VNAME32
AK-1
NOT NULL
FeatureSetID
Identifies a feature set from the 
Feature_Control_Set Table.
DBINT
FK
NULL
ICRInstanceID
Identifies the ICM instance associated with the 
customer.
DBINT
FK, IE-1
NOT NULL
NetworkTargetID
Identifies the Network VRU, if any, associated 
with the customer.
DBINT
FK, NULL