This table contains the result of a mining apply for contracts or accounts. This table is currently not used.
Column Description(s):
Column Name | Column Type | Description |
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 Name | Indexed Column Names | Index Type |
SQL050212031157120 |
SEGMENTATION_ID+RESULT_ID |
Primary Key |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.