Manualsbrain.com
  1. Manuais
  2. Marcas
  3. Cisco
  4. Cisco Unified Contact Center Enterprise 9.0(1)
  5. Referências técnicas

Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas

Download
Página de 404
 
2-291
Cisco ICM Software Database Schema Handbook
78-11677-04
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.
View_Column Table
Describes how the ICM software interprets one column of imported schedule data.
Table 2-195 Version Table
Field Name
Description
Data Type
Keys and Null 
Option
Major
The number of the major version; for example, if the version 
is 1.2, this value is 1.
int
NOT NULL
CCMinor
The incremental version number of the central database 
schema. For example, if the version is 1.2, this value is 2.
int
NOT NULL
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.
int
NOT NULL
Table 2-196 View_Column Table
Field Name
Description
Data Type
Keys and Null 
Option
ViewColumnID
A unique identifier for the column.
int
PK, NOT NULL
ICRViewID
Identifies the view to which the column belongs.
int
AK1, AK2, FK, 
NOT NULL
ColumnNumber
Indicates the position of the column within the 
Schedule Import table.
int
AK1, NOT 
NULL
BaseName
The name used for the column in the system from 
which it imported.
varchar(32)
NULL
ViewName
The name used for the column within the ICM 
software.
varchar(32)
AK2, NULL
Description
Additional information about the column.
varchar(255)
NULL
Shift
The number of bit positions to shift the value to the 
left.
int
NULL
Mask
Indicates which bit positions to use in the value. An 
AND operation is applied to the mask value and the 
field value.
int
NULL