Cisco Cisco Administrative Workstation Technical References
2-432
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Version Table
Version Table
A system table containing a single row which indicates the current version of the ICM database schema
installed in the central and local databases. This table is maintained by the ICM software installation
process.
installed in the central and local databases. This table is maintained by the ICM software installation
process.
View_Column Table
Describes how the ICM software interprets one column of imported schedule data.
Table 2-397 Version Table Constraints
Constraint
Field Name(s)
IE-1
Major
Table 2-398 Version Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AWMinor
The incremental version number of the local
database schema on the AW. For example, if the
version is 1.3, this value is 3.
database schema on the AW. For example, if the
version is 1.3, this value is 3.
DBINT
NOT NULL
CCMinor
The incremental version number of the central
database schema. For example, if the version is
1.2, this value is 2.
database schema. For example, if the version is
1.2, this value is 2.
DBINT
NOT NULL
Major
The number of the major version; for example, if
the version is 1.2, this value is 1.
the version is 1.2, this value is 1.
DBINT
IE-1
NOT NULL
Table 2-399 View_Column Table Constraints
Constraint
Field Name(s)
PK
ViewColumnID
AK-1
ColumnNumber
ICRViewID
ICRViewID
AK-2
ICRViewID
ViewName
ViewName
FK
ICRViewID