CAMPAIGN_SUMMARY

Description

This table stores the summary information of a campaign, including the audience size, campaign ID, creator username, creation date and time, deployed status, description, start and end date and time, project ID, and version.

Columns

Column Name Data Type Description
ID bigint The unique identifier of the campaign summary.
AUDIENCE_SIZE bigint The size of the target audience for the campaign.
CAMPAIGN_ID bigint The ID of the campaign.
CREATED_BY_USERNAME varchar The username of the creator of the campaign.
CREATION_DATE_TIME_ITEM datetime The date and time when the campaign was created.
DEPLOYED bit Indicates whether the campaign has been deployed.
DESCRIPTION longtext The description of the campaign.
END_DATE_TIME_INCLUSIVE_ITEM datetime The end date and time of the campaign.
NAME varchar The name of the campaign.
PROJECT_ID bigint The ID of the project the campaign belongs to.
START_DATE_TIME_INCLUSIVE_IT_0 datetime The start date and time of the campaign.
VERSION bigint The version of the campaign.

Primary Key

  • ID