DMRANKINGITEM

This table stores calculated ranking information. For example, the top 10 products purchased in a category, or the top 5 browsed products in a category. Each ranking item under a ranking group has a sequence.

Column Descriptions:

Name	Type	Description
DMRANKINGITEM_ID	BIGINT NOT NULL	The ranking identifier. This is the primary key.
DMELEMENT_ID	INTEGER NOT NULL	The campaign element associated with this ranking list.
OBJECT_ID	BIGINT NOT NULL	The object for which the statistic is being gathered. For most purchased products in a category, this is the product catalog entry ID. For most browsed products in a category, this is the product catalog entry ID.
GROUP_ID	BIGINT NOT NULL	The group to which the object belongs. For most purchased products in a category, this is the category ID. For most browsed products in a category, this is the category ID.
SEQUENCE	INTEGER NOT NULL	The order of the object within the ranking list.
STOREENT_ID	INTEGER NOT NULL	The store identifier.
AMOUNT	DOUBLE DEFAULT 0	The amount related to the statistic. For example, the number of time browsed, or the number of times purchased.
FIELD1	INTEGER	Customizable field.
FIELD2	BIGINT	Customizable field.
FIELD3	DECIMAL (20,5)	Customizable field.
FIELD4	VARCHAR (254)	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
<SYSTEM-GENERATED>	DMRANKINGITEM_ID	Primary Key
I0001302	DMELEMENT_ID+STOREENT_ID+OBJECT_ID+GROUP_ID	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3595	DMELEMENT_ID	DMELEMENT	DMELEMENT_ID	Cascade