DMRANKINGSTAT

This table stores collected information used to generate a ranking list. For example, when a relevant product is purchased or browsed, the data will be recorded in this table.

Column Descriptions:

Name	Type	Description
DMRANKINGSTAT_ID	BIGINT NOT NULL	The ranking statistic identifier. This is the primary key.
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.
OBJECT_TYPE	SMALLINT NOT NULL	The type of the statistic. 0 = purchased in a category 1 = browsed in a category
STOREENT_ID	INTEGER NOT NULL	The store identifier.
DMELEMENT_ID	INTEGER NOT NULL	The campaign element associated with this ranking list.
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.
AMOUNT	DOUBLE NOT NULL DEFAULT 0	The amount related to the statistic. For example, the number of time browsed, or the number of times purchased.
FLAG	SMALLINT NOT NULL DEFAULT 0	A flag to indicate the type of the statistic record. 0 = New 1 = Summarized 2 = Unknown
TIMECREATED	TIMESTAMP	The time of when the statistic is recorded.
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>	DMRANKINGSTAT_ID	Primary Key
I0001303	STOREENT_ID+DMELEMENT_ID+GROUP_ID+TIMECREATED	Non-Unique Index