Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 404
 
2-80
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Enterprise_Route_Member Table
Related tables:
Business Entity (via EntityID)
Enterprise Route Member (via EnterpriseRouteID)
Enterprise_Route_Member Table
Maps routes to enterprise routes.
Use ICM Configuration Manager to add, update, and delete Enterprise_Route_Member records.
Related tables:
Enterprise Route (via EnterpriseRouteID)
Route (via RouteID)
Enterprise_Service Table
Each row defines an enterprise-wide service composed of services from different peripherals.
Use ICM Configuration Manager to add, update, and delete Enterprise_Service records.
Table 2-66 Enterprise_Route_Member Table
Field Name
Description
Data Type
Keys and Null 
Option
EnterpriseRouteID
Foreign key from the Enterprise_Route table.
int
PK, FK NOT 
NULL
RouteID
Foreign key from the Route table.
int
PK, FK, NOT 
NULL
Table 2-67 Enterprise_Service Table
Field Name
Description
Data Type
Keys and Null 
Option
EnterpriseServiceID
Unique identifier for this enterprise service.
int
PK, NOT NULL
EntityID
If partitioning is enabled, indicates the business entity to 
which the enterprise service belongs.
int
AK1, FK, NOT 
NULL
EnterpriseName
An enterprise name for this enterprise service. This name 
must be unique among all enterprise services within the 
business entity.
varchar(32)
AK1, NOT 
NULL
Description
Additional information about the enterprise service.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL