ccdw_dim_campaign
This table describes various marketing campaigns.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
campaign_id (PK) | INTEGER | PK | Unique identifier for a campaign. | Yes |
ncampaign_id | VARCHAR | Natural key of the campaign, representing the ID of the campaign in the source system. | Yes | |
description | VARCHAR | Description of the campaign. | No | |
is_continuous | BOOLEAN | Boolean indicating if the campaign is continuous. | No | |
valid_from | TIMESTAMP | Start date and time when the campaign is valid. | No | |
valid_to | TIMESTAMP | End date and time when the campaign is valid. | No |