Cisco Cisco IPCC Web Option Technical References
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
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.
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
2 = Custom
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-137 Region_View_Member Table
Field Name
Description
Data Type
Keys and Null
Option
Option
RegionViewID
Identifies the region view.
int
PK, FK, NOT
NULL
NULL
RegionID
Identifies the region.
int
PK, FK, NOT
NULL
NULL
Color
Identifies the color in which to display the region in the
view.
view.
int
NOT NULL