OFFER_STAGE
Description
This table stores offer stages.
Columns
| Column Name | Data Type | Description |
| ID | bigint | The unique identifier of the offer stage. |
| MESSAGE_STAGE_OFFER_STAGE_ID | bigint | The foreign key referencing the ID column of the MESSAGE_STAGE table. |
| RESPONSE_STAGE_OFFER_STAGE_ID | bigint | The foreign key referencing the ID column of the RESPONSE_STAGE table. |
| THRESHOLD_STAGE_OFFER_STAGE 0 | bigint | The foreign key referencing the ID column of the THRESHOLD_STAGE table. |
| TRIGGER_STAGE_OFFER_STAGE_ID | bigint | The foreign key referencing the ID column of the TRIGGER_STAGE table. |
| STAGES_OFFER_TRACK_ID | bigint | The foreign key referencing the ID column of the OFFER_TRACK table. |
| STAGES_HJORDER | int | The order of the offer stage in the hierarchy. |
Foreign Key Relationships
- MESSAGE_STAGE_OFFER_STAGE_ID references MESSAGE_STAGE (ID)
- RESPONSE_STAGE_OFFER_STAGE_ID references RESPONSE_STAGE (ID)
- THRESHOLD_STAGE_OFFER_STAGE 0 references THRESHOLD_STAGE (ID)
- TRIGGER_STAGE_OFFER_STAGE_ID references TRIGGER_STAGE (ID)
- STAGES_OFFER_TRACK_ID references OFFER_TRACK (ID)