CEDYNDISPCONF

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

Column Descriptions:

NameTypeDescription
CEDYNDISPCONF_IDBIGINT NOT NULLThe internal reference number of this configuration.
ATTRIBUTEVARCHAR (256) NOT NULLThe name of the product attribute or analytics metric used to re-order products under a category.
WEIGHTVARCHAR (256) NOT NULLThe weight assigned to the analytics metric. The higher the weight the more influence this metric would have when ordering products.
SORT_PREFVARCHAR (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_IDBIGINT NOT NULLThe reference number that identifies the contextual information of the rule configuration. This is a foreign key to the CEDYNDISPCTX table.
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_0042CEDYNDISPCONF_IDPrimary Key
I0001536ATTRIBUTE+CEDYNDISPCTX_IDUnique Index
I0001537CEDYNDISPCTX_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3781CEDYNDISPCTX_IDCEDYNDISPCTXCEDYNDISPCTX_IDCascade