ITERATION_RESULT

Description

This table stores information about the iteration results.

Columns

Column Name Data Type Description
ID bigint The unique identifier of the iteration result.
EXPERIMENT_ID bigint The ID of the experiment.
ITERATION_INDEX smallint The index of the iteration.
ROBOT_ID bigint The ID of the marketing robot.
CAMPAIGN_ITERATION_RESULT_ID bigint The ID of the campaign iteration result.
CUSTOMER_SEGMENTATION_TREE_I_0 bigint The ID of the customer segmentation tree.
STATISTICS ITERATION_RESULT_0 bigint The ID of the iteration statistics.

Foreign Key Relationships

  • CAMPAIGN_ITERATION_RESULT_ID references ITERATION_CAMPAIGN (ID)
  • CUSTOMER_SEGMENTATION_TREE_I_0 references CUSTOMER_SEGMENTATION_TREE (ID)
  • STATISTICS ITERATION_RESULT_0 references ITERATION_STATISTICS (ID)
  • EXPERIMENT_ID references EXPERIMENT (ID)
  • ROBOT_ID references MARKETING_ROBOT (ID)

Constraints

  • PRIMARY KEY (ID)
  • UNIQUE KEY (ROBOT_ID, EXPERIMENT_ID, ITERATION_INDEX)