WebSphere Commerce database table: APPLY_MEMBER

This table contains the output from WebSphere Commerce Analyzer after the mining model is applied to members and the WebSphere Commerce Analyzer sample closed-loop script is run.


Column Description(s):
Column NameColumn TypeDescription
SEGMENTATION_ID INTEGER NOT NULL The mining model ID number from WebSphere Commerce Analyzer. This number is used in DB2 Intelligent Miner to differentiate between mining models.
SEGMENT_INDEX INTEGER NOT NULL The segment ID within the specified model. Each model can contain several segments.
SCORE DOUBLE NOT NULL A value between 0.0 and 1.0 representing how well the member meets the model and segment requirements, as defined in WebSphere Commerce Analyzer. 1.0 is a perfect match.
MEMBER_ID BIGINT NOT NULL The MEMBER_ID from the USERREG table.
SUB_ID BIGINT NOT NULL A product, category, or order ID indicator. Valid values are: 1 - PRODUCT_ID 2 - CATEGORY_ID 3 - ORDER_ID
TYPE_ID INTEGER NOT NULL The type of the output data. 1 is member versus product, 2 is member versus category, 3 is member versus order.
CONFIDENCE DOUBLE The confidence of the apply
SCORE2 DOUBLE Reserved for IBM internal use.
SEGMENT_INDEX2 INTEGER Reserved for IBM internal use.
LAST_UPDATED TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP The timestamp of the last update to the record.
LAST_UPDATED_ID INTEGER NOT NULL DEFAULT 0 The ID of the application that last updated the record.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031156950 MEMBER_ID+SUB_ID+SEGMENTATION_ID Primary Key
I0000272 SEGMENTATION_ID+SEGMENT_INDEX+SCORE Non-Unique Index

Feedback