CFCONDGRP

Each row of this table represents a condition group in a certain catalog filter

Column Descriptions:

NameTypeDescription
CFCONDGRP_IDBIGINT NOT NULLGenerated primary key
CFCATGROUP_IDBIGINT NOT NULLThe CFCATGROUP ID
IDENTIFIERVARCHAR (254) NOT NULLThe identifier of condition group
CONDITIONRELATIONSMALLINT NOT NULLDeclare the relation between the affiliated conditions:
0
For 'AND' operation.
1
For 'OR' operation.
FIELD1BIGINTCustomizable
FIELD2INTEGERCustomizable
FIELD3VARCHAR (254)Customizable
FIELD4DECIMAL (20,5)Customizable
FIELD5DOUBLECustomizable
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CFCONDGRP_IDPrimary Key
I0001378CFCATGROUP_ID+IDENTIFIERUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3668CFCATGROUP_IDCFCATGROUPCFCATGROUP_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3671CFCONDGRP_IDCFCONDCFCONDGRP_IDCascade