CFPRODUCTSET

Each row represents the relationship between a catalog filter and a product set used for filtering.

Column Descriptions:

NameTypeDescription
CFPRODUCTSET_IDBIGINT NOT NULLGenerated primary key
CATFILTER_IDBIGINT NOT NULLCatalog Filter ID
PRODUCTSET_IDINTEGER NOT NULLProduct Set ID
TYPESMALLINT NOT NULL DEFAULT 0Declares the type of selected product set for use in catalog filtering:
0
Explicit catalog entry exclusion.
1
Explicit catalog entry inclusion.
2
Implicit SKU exclusion (When the parent product is explicitly excluded, child SKUs are implicitly excluded).
3
Implicit SKU inclusion (When the parent product is explicitly included, child SKUs are implicitly included).
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>CFPRODUCTSET_IDPrimary Key
I0001376CATFILTER_ID+PRODUCTSET_IDUnique Index
I0001377PRODUCTSET_IDNon-Unique Index
I0001395CATFILTER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3666CATFILTER_IDCATFILTERCATFILTER_IDCascade
F_3667PRODUCTSET_IDPRODUCTSETPRODUCTSET_IDCascade