EXPERIMENT
Description
This table stores the experiments.
Columns
| Column Name | Data Type | Description |
| ID | bigint | The unique identifier for the experiment. |
| DEPLOYED_TO_BUSINESS_AS_USUAL | bit | Indicates if the experiment is deployed to business as usual. |
| DESCRIPTION | longtext | The description of the experiment. |
| ITERATION_LENGTH_IN_DAYS | smallint | The length of each iteration in days. |
| MAX_NUM_ITERATIONS | smallint | The maximum number of iterations for the experiment. |
| NAME | varchar | The name of the experiment. |
| START_DATE_TIME_INCLUSIVE_IT_0 | datetime | The start date and time of the experiment. |
| STATUS | varchar | The status of the experiment. |
| ROBOT_ID | bigint | The ID of the marketing robot. |
| AUDIENCE_CONDITION_EXPERIMEN_0 | bigint | The ID of the audience condition expression. |
| EXPERIMENT_CONSTRAINT_EXPERI_0 | bigint | The ID of the experiment constraint specification. |
Foreign Key Relationships
- AUDIENCE_CONDITION_EXPERIMEN_0 references AUDIENCE_UEL_EXPRESSION(ID)
- EXPERIMENT_CONSTRAINT_EXPERI_0 references CONSTRAINTS_SPECIFICATION(ID)
- ROBOT_ID references MARKETING_ROBOT(ID)