Database Table: APPLY_MEMBER

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.
Indexes:
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
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable