CATFILTER

Each row of this table represents a catalog filter.

Column Descriptions:

NameTypeDescription
CATFILTER_IDBIGINT NOT NULLGenerated primary key
STOREENT_IDINTEGER NOT NULLThe Store ID. The store the catalog filter belongs to
CATALOG_IDBIGINT NOT NULLThe Catalog ID. The catalog the catalog filter defined on
IDENTIFIERVARCHAR (254) NOT NULLThe identifier of catalog filter
USAGESMALLINTDeclare the usage of this catalog filter as follows:
0
For extended sites use.
1
For contract use.
2
For price use.
3
For marketing use.
4
for promotion use.
FIELD1BIGINTCustomizable
FIELD2INTEGERCustomizable
FIELD3VARCHAR (254)Customizable
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>CATFILTER_IDPrimary Key
I0001373STOREENT_ID+IDENTIFIER+CATALOG_IDUnique Index
I0001374STOREENT_ID+CATALOG_IDNon-Unique Index
I0001375CATALOG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3662CATALOG_IDCATALOGCATALOG_IDCascade
F_3663STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3664CATFILTER_IDCATFLTDSCCATFILTER_IDCascade
F_3666CATFILTER_IDCFPRODUCTSETCATFILTER_IDCascade
F_3669CATFILTER_IDCFCATGROUPCATFILTER_IDCascade
F_3769CATFILTER_IDEXPRESSIONCATFILTER_IDCascade