Cisco Cisco IPCC Web Option Technical References
2-245
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
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:
(via QueryRuleID)
Table 2-260 Query_Rule_Clause Table Constraints
Constraint
Field Name(s)
PK
QueryRuleID
SequenceNumber
SequenceNumber
FK
QueryRuleID
Table 2-261 Query_Rule_Clause Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
QueryRuleID
The query rule to which this clause belongs.
Foreign key from the Query Rule table.
Foreign key from the Query Rule table.
DBINT
PK, FK
NOT NULL
RuleData
The rule definition to be used to process each
query rule.
query rule.
varchar(255)
NOT NULL
SequenceNumber
An index for query rule clauses within a given
query rule.
query rule.
DBINT
PK
NOT NULL