Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: 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 Name Column 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 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type I0001302 DMELEMENT_ID+STOREENT_ID+OBJECT_ID+GROUP_ID Unique Index SQL100520030705500 DMRANKINGITEM_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3595 DMELEMENT_ID DMELEMENT DMELEMENT_ID Cascade _vcc_freeselect_bottom_