# 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     |