Cisco Cisco IP Contact Center Release 4.6.1 Références techniques
2-68
Cisco ICM Software Database Schema Handbook
78-11677-04
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:
Customer Options (via CustomerDefinitionID)
ICR Instance (via ICRInstanceID)
Network VRU (via NetworkTargetID)
Customer_Options Table
Each row identifies options installed for a specific customer.
Related tables:
Customer Definition (via CustomerDefinitionID)
Table 2-50 Customer Definition Table
Field Name
Description
Data Type
Keys and Null
Option
Option
CustomerDefinitionID
A unique identifier for the customer definition.
int
PK, NOT NULL
ICRInstanceID
Identifies the ICM instance associated with the customer. int
FK, IE1, NOT
NULL
NULL
NetworkTargetID
Identifies the Network VRU, if any, associated with the
customer.
customer.
int
FK, NULL
EnterpriseName
An enterprise name for the customer. This name must be
unique among all customer definitions in the enterprise.
unique among all customer definitions in the enterprise.
varchar(32)
AK1, NOT
NULL
NULL
Description
Additional information about the customer definition.
varchar(255)
NULL
FeatureSetID
Identifies a feature set from the Feature_Control_Set
Table.
Table.
int
FK, NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-51 Customer_Options Table
Field Name
Description
Data Type
Keys and Null
Option
Option
CustomerDefinitionID
Identifies the customer definition associated with the
row.
row.
int
PK, FK, NOT
NULL
NULL
Type
The customer option defined by the row.
int
PK, NOT NULL
OptionValue
The option value.
varchar(255)
NULL