EXPRESSION

Each row represents a pre-compiled search expression which could be catalog filter based or productset based.

Column Descriptions:

NameTypeDescription
EXPRESSION_IDBIGINT NOT NULLGenerated primary key.
TRADING_IDBIGINTThe contract id. For a catalog filter based search expression, it could be null before this catalog filter was assigned to contract. For a product set based search expression, it is the contract where the filtering was defined against.
CATFILTER_IDBIGINTThe catalog filter Id. CATFILTER_ID could be null when this row represent a product set based search expression.
MEMBER_IDBIGINTMember of Member group Id. MEMBER_ID is null or -1 to represent that this search expression apply to all member. MEMBER_ID is not null when this is a member group level search expression.
QUERYCLOB (1000000)This is the generated or pre-compiled search expression. This search expression will be appended into a search query as filter query when entitlement is enabled.
FIELD1BIGINTCustomizable field
FIELD2VARCHAR (256)Customizable field
FIELD3VARCHAR (256)Customizable field
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
P_0030EXPRESSION_IDPrimary Key
I0001517TRADING_IDNon-Unique Index
I0001518CATFILTER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3768TRADING_IDTRADINGTRADING_IDCascade
F_3769CATFILTER_IDCATFILTERCATFILTER_IDCascade