Reference > Database > WebSphere Commerce database tables > D


WebSphere Commerce database table: DMUSERBHVR

A customer's behavior within a site, and within a marketing activity.

Column Name Column Type Description
PERSONALIZATIONID VARCHAR(30) NOT NULL The unique personalization identifier of a customer.
STOREENT_ID INTEGER NOT NULL DEFAULT 0 The identifier of the store.
BEHAVIOR CLOB The XML definition of a customer's online behavior.
ACTION CLOB The XML definition the Actions which a customer should not repeat.
EVENT CLOB The XML definition of the marketing activities a customer should not repeat, and the Triggers for which the customer is waiting.
LASTUPDATED TIMESTAMP The time which the customer's user behavior entry was last updated.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030329260 PERSONALIZATIONID+STOREENT_ID Primary Key

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search