Database Table: APPLY_RESULT

This table contains the result of a mining apply for contracts or accounts.

Column Name Column Type Column Description
CONFIDENCE DOUBLE
NULL
The confidence of the apply.
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.
RESULT_ID BIGINT
NOT NULL
A contract ID, account ID, and so forth for the segmentation scoring result. See TYPE_ID for specific types. The foreign key relationship is not explicitly created to CONTRACT and ACCOUNT tables, but data is related that way.
SCORE DOUBLE
NOT NULL
The resulting score from the mining segmentation.
SCORE2 DOUBLE
NULL
Reserved for IBM internal use.
SEGMENTATION_ID INTEGER
NOT NULL
The ID of a segmentation model. This ID is the same as in the SEGMENTATION table.
SEGMENT_INDEX INTEGER
NOT NULL
The same SEGMENT_INDEX as in table SEGMENT and can be used to join with that table.
SEGMENT_INDEX2 INTEGER
NULL
Reserved for IBM internal use.
TYPE_ID INTEGER
NOT NULL
The type of entity that this result is for. Valid values are: 1 Account 2 Contract IDs 0 through 100 Reserved by IBM
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034836560 SEGMENTATION_ID, RESULT_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