The table contains the output from WebSphere Commerce Analyzer after applying the mining model to members and running the WebSphere Commerce Analyzer sample closed-loop script.
Column Name | Column Type | Column Description |
---|---|---|
CONFIDENCE | DOUBLE NULL |
The confidence of the apply |
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. |
MEMBER_ID | BIGINT NOT NULL |
The MEMBER_ID from the USERREG 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. |
SCORE2 | DOUBLE NULL |
Reserved for IBM internal use. |
SEGMENTATION_ID | INTEGER NOT NULL |
The model ID number from WebSphere Commerce Analyzer. |
SEGMENT_INDEX | INTEGER NOT NULL |
The segment ID (within the specified model). Each model can contain several segments. |
SEGMENT_INDEX2 | INTEGER NULL |
Reserved for IBM internal use. |
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000272 | SEGMENTATION_ID, SEGMENT_INDEX, SCORE | Non-Unique Index |
SQL030416034836180 | MEMBER_ID, SUB_ID, SEGMENTATION_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|