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 |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034836560 | SEGMENTATION_ID, RESULT_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 |
---|---|---|---|---|