CFPRODUCTSET

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

Column Descriptions:

Name	Type	Description
CFPRODUCTSET_ID	BIGINT NOT NULL	Generated primary key
CATFILTER_ID	BIGINT NOT NULL	Catalog Filter ID
PRODUCTSET_ID	INTEGER NOT NULL	Product Set ID
TYPE	SMALLINT NOT NULL DEFAULT 0	Declares 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).
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CFPRODUCTSET_ID	Primary Key
I0001376	CATFILTER_ID+PRODUCTSET_ID	Unique Index
I0001377	PRODUCTSET_ID	Non-Unique Index
I0001395	CATFILTER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3666	CATFILTER_ID	CATFILTER	CATFILTER_ID	Cascade
F_3667	PRODUCTSET_ID	PRODUCTSET	PRODUCTSET_ID	Cascade