EXPRESSION

Each row represents a precompiled search expression which could be catalog filter based or productset based.

Column Descriptions:

Name	Type	Description
EXPRESSION_ID	BIGINT NOT NULL	Generated primary key.
TRADING_ID	BIGINT	The 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_ID	BIGINT	The catalog filter Id. CATFILTER_ID could be null when this row represent a product set based search expression.
MEMBER_ID	BIGINT	Member 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.
QUERY	CLOB (1000000)	This is the generated or precompiled search expression. This search expression will be appended into a search query as filter query when entitlement is enabled.
FIELD1	BIGINT	Customizable field
FIELD2	VARCHAR (256)	Customizable field
FIELD3	VARCHAR (256)	Customizable field
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
P_0030	EXPRESSION_ID	Primary Key
I0001517	TRADING_ID	Non-Unique Index
I0001518	CATFILTER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3768	TRADING_ID	TRADING	TRADING_ID	Cascade
F_3769	CATFILTER_ID	CATFILTER	CATFILTER_ID	Cascade