Cisco Cisco E-Mail Manager Unity Integration Option Technische Referenzen
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
Option
EnterpriseRouteID
Foreign key from the Enterprise_Route table.
int
PK, FK NOT
NULL
NULL
RouteID
Foreign key from the Route table.
int
PK, FK, NOT
NULL
NULL
Table 2-67 Enterprise_Service Table
Field Name
Description
Data Type
Keys and Null
Option
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.
which the enterprise service belongs.
int
AK1, FK, NOT
NULL
NULL
EnterpriseName
An enterprise name for this enterprise service. This name
must be unique among all enterprise services within the
business entity.
must be unique among all enterprise services within the
business entity.
varchar(32)
AK1, NOT
NULL
NULL
Description
Additional information about the enterprise service.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL