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 |