EXPERIMENT_OFFER
Description
This table stores the offers for each experiment.
Columns
| Column Name | Data Type | Description |
| ID | bigint | The unique identifier for each record in the table. |
| ACTION | varchar | The action associated with the offer. |
| CATEGORY | varchar | The category of the offer. |
| COST | double | The cost of the offer. |
| DESCRIPTION | longtext | The description of the offer. |
| END_DATE_TIME_EXCLUSIVE_ITEM | datetime | The end date and time of the offer. |
| MESSAGE | longtext | The message of the offer. |
| OFFER_ID | varchar | The ID of the offer. |
| PRICE | double | The price of the offer. |
| START_DATE_TIME_INCLUSIVE_IT_0 | datetime | The start date and time of the offer. |
| STATUS | varchar | The status of the offer. |
| SUB_CATEGORY | varchar | The sub-category of the offer. |
| VALIDITY_PERIOD_IN_DAYS | double | The validity period of the offer in days. |
Constraints
- PRIMARY KEY (ID)
- UNIQUE KEY (OFFER_ID)