Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: 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 Name Column 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 categorySTOREENT_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 = UnknownTIMECREATED 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 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type SQL100520030705660 DMRANKINGSTAT_ID Primary Key I0001303 STOREENT_ID+DMELEMENT_ID+GROUP_ID+TIMECREATED Non-Unique Index _vcc_freeselect_bottom_