CEDYNDISPCONF

Reserved for HCL internal use. This table configures a rule that defines a sequence of products under a category.

Column Descriptions:

Name	Type	Description
CEDYNDISPCONF_ID	BIGINT NOT NULL	The internal reference number of this configuration.
ATTRIBUTE	VARCHAR (256) NOT NULL	The name of the product attribute or analytics metric used to re-order products under a category.
WEIGHT	VARCHAR (256) NOT NULL	The weight assigned to the analytics metric. The higher the weight the more influence this metric would have when ordering products.
SORT_PREF	VARCHAR (256) NOT NULL DEFAULT 'High'	The sort preference can be either 'High' or 'Low. If the present metric were the only one influencing the sort, then choosing 'Low' would rank the products from lowest to highest according to that metric. Similarly, in the absence of other metrics, choosing 'High' would rank them highest to lowest. In practice, other metrics will likely exist to influence the sort. Therefore, 'Low' and 'High' will influence or 'push' products towards the top but not guarantee their final ranking.
CEDYNDISPCTX_ID	BIGINT NOT NULL	The reference number that identifies the contextual information of the rule configuration. This is a foreign key to the CEDYNDISPCTX table.
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_0042	CEDYNDISPCONF_ID	Primary Key
I0001536	ATTRIBUTE+CEDYNDISPCTX_ID	Unique Index
I0001537	CEDYNDISPCTX_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3781	CEDYNDISPCTX_ID	CEDYNDISPCTX	CEDYNDISPCTX_ID	Cascade