Cisco Cisco Unified Contact Center Enterprise 9.0(2) Références techniques
2-151
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Query_Rule_Clause Table
Query_Rule_Clause Table
Contains the SQL rules associated with each query rule. There is a single row for each configured query
rule.
rule.
Related tables:
Query_Rule (via QueryRuleID)
Recovery Table
Central database only.
Contains internal status information for each table in the database.
Table 2-129 Query_Rule_Clause Table
Field Name
Description
Data Type
Keys and Null
Option
Option
QueryRuleID
The query rule to which this clause belongs. Foreign key
from the Query Rule table.
from the Query Rule table.
int
PK, FK, NOT
NULL
NULL
SequenceNumber
An index for query rule clauses within a given query rule. int
PK, NOT NULL
RuleData
The rule definition to be used to process each query rule.
varchar(255)
NOT NULL
Table 2-130 Recovery Table
Field Name
Description
Data Type
Keys and Null
Option
Option
RecoveryKey
A value used internally by the ICM software to track the
time the record is created.
time the record is created.
float
PK, NOT NULL
DateTime
Date and time of the checkpoint.
datetime
IE1, NOT NULL
Type
Type of record.
varchar(32)
NOT NULL
TableName
Name of the table that caused a checkpoint.
varchar(32)
NOT NULL
FromRecoveryKey
Starting recovery key value.
float
NULL
ToRecoveryKey
Ending recovery key value.
float
NOT NULL
StartTime
Starting time.
datetime
NULL
EndTime
Ending time.
datetime
NULL
RowsCopied
Number of rows copied.
int
NULL