OFFER_ID_AND_CUSTOMERS
Description
This table stores the relationship between offer IDs and customers.
Columns
| Column Name | Data Type | Description |
| ID | bigint | The unique identifier of the relationship. |
| OFFER_ID | varchar | The ID of the offer. |
| OFFER_ID_AND_CUSTOMERS_ITERA_0 | bigint | The foreign key referencing the ID column of the ITERATION_CAMPAIGN table. |
| OFFER_ID_AND_CUSTOMERS_HJORD_0 | int | The order of the offer in the hierarchy. |
Foreign Key Relationships
- OFFER_ID_AND_CUSTOMERS_ITERA_0 references ITERATION_CAMPAIGN (ID)