Cisco Cisco Administrative Workstation Technical References

Page of 620
Customer_Definition Table
This table is part of the 
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)
CustomerDefinitionID)
CustomerDefinitionID)
CustomerDefinitionID)
 (via
ICRInstanceID)
FeatureSetID)
CustomerDefinitionID)
NetworkTargetID)
 (via
CustomerDefinitionID)
 (via
CustomerDefinitionID)
Table 69: Indexes for Customer_Definition Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1Customer_Definition
ICRInstanceID
nonclustered located on PRIMARY
XIE1Customer_Definition
CustomerDefinitionID
clustered, unique, primary key
located on PRIMARY
XPKCustomer_Definition
Fields in Customer_Definition Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
PK NOT NULL
DBINT
A unique identifier for the customer definition.
CustomerDefinitionID
NULL
DESCRIPTION
Additional information about the customer definition.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for the customer. This name must be unique
among all customer definitions in the enterprise.
EnterpriseName
FK NULL
DBINT
Identifies a feature set from the Feature_Control_Set Table.
FeatureSetID
FK, IE-1 NOT NULL
DBINT
Identifies the instance associated with the customer.
ICRInstanceID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
153
Chapter 2:  All Tables
Customer_Definition Table