Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMEMSPOTSTATS
Statistics for an e-MarketingSpot within a marketing activity.
Column Name Column Type Description DMACTIVITY_ID INTEGER NOT NULL The identifier of a marketing activity. EMSPOT_ID INTEGER NOT NULL The identifier of a e-MarketingSpot which is populated by the marketing activity. STOREENT_ID INTEGER NOT NULL DEFAULT 0 The identifier of the store. VIEWS INTEGER DEFAULT 0 The number of times customers have viewed the e-MarketingSpot in the context of the marketing activity. CLICKS INTEGER DEFAULT 0 The number of times customers have clicked the e-MarketingSpot in the context of the marketing activity. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030327800 DMACTIVITY_ID+EMSPOT_ID+STOREENT_ID Primary Key I0001155 EMSPOT_ID Non-Unique Index _vcc_freeselect_bottom_