This table describes various promotions.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
promotion_id (PK) |
INTEGER | PK | Unique identifier for a promotion. | Yes |
npromotion_id |
VARCHAR | Natural key of the promotion, representing the ID of the promotion in the source system. | Yes | |
display_name |
VARCHAR | User-friendly display name for the promotion. | No | |
promotion_class |
VARCHAR | Type or class of the promotion (for example, shipping, order, product). | No | |
is_continuous |
BOOLEAN | Boolean indicating if the promotion is continuous. | No | |
valid_from |
TIMESTAMP | Start date and time when the promotion is valid. Populated for promotions created or updated after February 2025. | No | |
valid_to |
TIMESTAMP | End date and time when the promotion is valid. Populated for promotions created or updated after February 2025. | No |