WebSphere Commerce database table: APPLY_RESULT

This table contains the result of a mining apply for contracts or accounts. This table is currently not used.


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.
RESULT_ID BIGINT NOT NULL No RESULT_ID external description assigned yet
TYPE_ID INTEGER NOT NULL Reserved for IBM internal use.
SEGMENT_INDEX INTEGER NOT NULL The same SEGMENT_INDEX as in table SEGMENT and can be used to join with that table.
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.
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 time stamp 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
SQL050212031157120 SEGMENTATION_ID+RESULT_ID Primary Key

Feedback