EXPERIMENT_AUDIENCE_AND_CONSTRAINTS

Description

This table stores the audience conditions and constraints for each experiment.

Columns

Column Name Data Type Description
ID bigint The unique identifier for each record in the table.
EXPERIMENT_ID bigint The ID of the experiment associated with the audience condition and constraint.
ROBOT_ID bigint The ID of the robot associated with the audience condition and constraint.
AUDIENCE_CONDITION_EXPERIMEN_1 bigint The ID of the audience condition associated with the experiment.
CONSTRAINT_WITH_OFFER_IDS_EX_0 bigint The ID of the constraint with offer IDs associated with the experiment.

Foreign Key Relationships

  • AUDIENCE_CONDITION_EXPERIMEN_1 references MARKETING_ROBOT_AUDIENCE_CON_0 (ID)
  • CONSTRAINT_WITH_OFFER_IDS_EX_0 references EXPERIMENT_CONSTRAINT_WITH_O_0 (ID)