CFCOND

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

Column Descriptions:

NameTypeDescription
CFCOND_IDBIGINT NOT NULLGenerated primary key
CFCONDGRP_IDBIGINT NOT NULLCondition Group ID. The condition group this condition belongs to.
TYPESMALLINT NOT NULL DEFAULT 0Condition attribute type.
0
Attribute dictionary attribute.
1
CATENTRY property.
2
CATENTRY attribute assigned to a unique catalog entry.
ATTR_IDBIGINTThe attribute ID. This column refers to the ATTR_ID in table ATTR under Attribute Dictionary. Use this when the TYPE is 0.
PROPERTYNAMEVARCHAR (254)Condition attribute type. Type of the condition attribute could be: 0. Attribute dictionary attribute. 1. Catentry Property.
OPERATORVARCHAR (254) NOT NULLThe Operator. The operator between the attribute and the attribute value.
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>CFCOND_IDPrimary Key
I0001380CFCONDGRP_IDNon-Unique Index
I0001381ATTR_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3670ATTR_IDATTRATTR_IDCascade
F_3671CFCONDGRP_IDCFCONDGRPCFCONDGRP_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3673CFCOND_IDCFCONDVALCFCOND_IDCascade