Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-251
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Region_Info Table
Region_Info Table
Specifies which prefixes and regions are predefined by the ICM software.
Region_Member Table
Each row defines the relationship between two regions. A region is composed of calling line ID prefixes
or of other regions. Each Region_Member row associates a region with a parent region.
or of other regions. Each Region_Member row associates a region with a parent region.
Use Configuration Manager to create, update, and delete Region Member rows.
Related tables:
(via RegionID and ParentRegionID)
Table 2-270 Region_Info Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
Comment
Any additional information about the pre-defined
regions.
regions.
DESCRIPTION
NULL
Location
Identifies the types of prefixes and regions
pre-defined by the ICM software.
pre-defined by the ICM software.
VNAME32
NOT NULL
MajorVersion
The major version number of the predefined
regions.
regions.
DBINT
NOT NULL
MinorVersion
The minor version number of the predefined
regions.
regions.
DBINT
NOT NULL
Table 2-271 Region_Member Table Constraints
Constraint
Field Name(s)
PK
ParentRegionID
RegionID
RegionID
FK
RegionID
IE-1
ParentRegionID
Table 2-272 Region_Member Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ParentRegionID
The larger region.
DBINT
PK, IE-1
NOT NULL
RegionID
The region that is a member of a larger region.
DBINT
PK, FK
NOT NULL