CFCATGROUP

Each row represents a selected catalog group in the catalog tree.

Column Descriptions:

NameTypeDescription
CFCATGROUP_IDBIGINT NOT NULLGenerated primary key
CATFILTER_IDBIGINT NOT NULLCatalog Filter ID
CATGROUP_IDBIGINT NOT NULLCatalog group ID
TYPESMALLINT NOT NULLDeclares the type of selected catalog group:
0
Catgroup Exclusion
1
Catgroup Inclusion
CONDGRPRELATIONSMALLINT
0
'AND' operation
1
'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>CFCATGROUP_IDPrimary Key
I0001379CATFILTER_ID+CATGROUP_IDUnique Index
I0001387CATGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3669CATFILTER_IDCATFILTERCATFILTER_IDCascade
F_3674CATGROUP_IDCATGROUPCATGROUP_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3668CFCATGROUP_IDCFCONDGRPCFCATGROUP_IDCascade