OFFER_BENEFIT
Description
This table stores offer benefits.
Columns
| Column Name | Data Type | Description |
| ID | bigint | The unique identifier of the offer benefit. |
| SUB_TYPE | varchar | The sub-type of the offer benefit. |
| TYPE | varchar | The type of the offer benefit. |
| UNIT | varchar | The unit of the offer benefit. |
| VALIDITY_PERIOD_IN_DAYS | double | The validity period of the offer benefit in days. |
| VALUE | smallint | The value of the offer benefit. |
| REWARDS_EXPERIMENT_OFFER_ID | bigint | The foreign key referencing the ID column of the EXPERIMENT_OFFER table. |
| REWARDS_HJORDER | int | The order of the rewards offer in the hierarchy. |
| BENEFITS_EXPERIMENT_OFFER_ID | bigint | The foreign key referencing the ID column of the EXPERIMENT_OFFER table. |
| BENEFITS_HJORDER | int | The order of the benefits offer in the hierarchy. |
Foreign Key Relationships
- REWARDS_EXPERIMENT_OFFER_ID references EXPERIMENT_OFFER (ID)
- BENEFITS_EXPERIMENT_OFFER_ID references EXPERIMENT_OFFER (ID)