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:

NameTypeDescription
DMRANKINGITEM_IDBIGINT NOT NULLThe ranking identifier. This is the primary key.
DMELEMENT_IDINTEGER NOT NULLThe campaign element associated with this ranking list.
OBJECT_IDBIGINT NOT NULLThe 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_IDBIGINT NOT NULLThe 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.
SEQUENCEINTEGER NOT NULLThe order of the object within the ranking list.
STOREENT_IDINTEGER NOT NULLThe store identifier.
AMOUNTDOUBLE DEFAULT 0The amount related to the statistic. For example, the number of time browsed, or the number of times purchased.
FIELD1INTEGERCustomizable field.
FIELD2BIGINTCustomizable field.
FIELD3DECIMAL (20,5)Customizable field.
FIELD4VARCHAR (254)Customizable field.
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
<SYSTEM-GENERATED>DMRANKINGITEM_IDPrimary Key
I0001302DMELEMENT_ID+STOREENT_ID+OBJECT_ID+GROUP_IDUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3595DMELEMENT_IDDMELEMENTDMELEMENT_IDCascade