ccdw_dim_promotion
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. | No | |
valid_to | TIMESTAMP | End date and time when the promotion is valid. | No |