Cisco Cisco IPCC Web Option Technical References

Page of 404
 
2-156
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Region_View Table
Region_View Table
Each row defines a graphical display of regions.
Use Configuration Manager to create, update, and delete Region View rows.
Related tables:
Region View Member (via RegionViewID)
Region_View_Member Table
Each row associates a specific region with a region view.
Use Configuration Manager to create, update, and delete Region View Member rows.
Related tables:
Region (via RegionID)
Region View (via RegionViewID)
Table 2-136 Region_View Table
Field Name
Description
Data Type
Keys and Null 
Option
RegionViewID
A unique identifier for the record.
int
PK, NOT NULL
EnterpriseName
An enterprise name for the region view. This name must 
be unique for all region views in the enterprise.
varchar(32)
NOT NULL
Description
Additional information about the view.
varchar(255)
NULL
RegionViewType
The type of the view: 
1 = ICM-defined
2 = Custom
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL
Table 2-137 Region_View_Member Table
Field Name
Description
Data Type
Keys and Null 
Option
RegionViewID
Identifies the region view.
int
PK, FK, NOT 
NULL
RegionID
Identifies the region.
int
PK, FK, NOT 
NULL
Color
Identifies the color in which to display the region in the 
view.
int
NOT NULL