CAMPAIGN_OFFER
Description
This table stores the offers associated with a campaign, including their configuration, channel, name, type, and other related information.
Columns
| Column Name | Data Type | Description |
| ID | bigint | The unique identifier of the campaign offer. |
| ACTION_BASED_OFFER_CONFIGURA_1 | bigint | The ID of the action-based offer configuration associated with the offer. |
| AUTO_PROVISIONED_OFFER_CONFI_1 | bigint | The ID of the auto-provisioned offer configuration associated with the offer. |
| MESSAGE_ONLY_OFFER_CONFIGURA_1 | bigint | The ID of the message-only offer configuration associated with the offer. |
| OPT_IN_OFFER_CONFIGURATION_O_0 | bigint | The ID of the opt-in offer configuration associated with the offer. |
| CHANNEL | varchar | The channel through which the offer is delivered. |
| NAME | varchar | The name of the offer. |
| TYPE | varchar | The type of the offer. |
| SIDE_EFFECT_CAMPAIGN_OFFER_ID | bigint | The ID of the side effect campaign offer associated with the offer. |
| OFFERS_CAMPAIGN_DRAFT_ID | bigint | The ID of the campaign draft the offer belongs to. |
| OFFERS_HJORDER | int | The order of the offer within the campaign. |
| OFFERS_CAMPAIGN_IMMUTABLE_EL_0 | bigint | The ID of the campaign immutable element associated with the offer. |
Foreign Key Relationships
- SIDE_EFFECT_CAMPAIGN_OFFER_ID references SIDE_EFFECT_WITH_TUPLE_ATTRI_0(ID)
- OPT_IN_OFFER_CONFIGURATION_O_0 references OPT_IN_OFFER_CONFIGURATION(ID)
- MESSAGE_ONLY_OFFER_CONFIGURA_1 references MESSAGE_ONLY_OFFER_CONFIGURA_0(ID)
- AUTO_PROVISIONED_OFFER_CONFI_1 references AUTO_PROVISIONED_OFFER_CONFI_0(ID)
- ACTION_BASED_OFFER_CONFIGURA_1 references ACTION_BASED_OFFER_CONFIGURA_0(ID)
- OFFERS_CAMPAIGN_IMMUTABLE_EL_0 references CAMPAIGN_IMMUTABLE_ELEMENTS(ID)
- OFFERS_CAMPAIGN_DRAFT_ID references CAMPAIGN_DRAFT(ID)