Технические ссылки для Cisco Cisco IPCC Web Option
2-247
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Recovery Table
Recovery Table
Central database only.
Contains internal status information for each table in the database.
Table 2-264 Recovery Table Constraints
Constraint
Field Name(s)
PK
RecoveryKey
AK-1
RecoveryKey
IE-1
DateTime
Table 2-265 Recovery Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
DateTime
Date and time of the checkpoint.
DBDATETIME
IE-1
NOT NULL
EndTime
Ending time.
DBDATETIME
NULL
FromRecoveryKey
Starting recovery key value.
DBFLT8
NULL
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
PK, AK-1
NOT NULL
RowsCopied
Number of rows copied.
DBINT
NULL
StartTime
Starting time.
DBDATETIME
NULL
TableName
Name of the table that caused a checkpoint.
VNAME32
NOT NULL
ToRecoveryKey
Ending recovery key value.
DBFLT8
NOT NULL
Type
Type of record.
VNAME32
NOT NULL