AUDIENCE_CHART

Description

This table stores information about audience charts.

Columns

Column Name Data Type Description
ID bigint(20) Primary key, unique identifier for each audience chart.
BUCKET_SIZE_MULTIPLIER int(11) The bucket size multiplier.
CHART_SORT_OPTION varchar(255) The sort option for the chart.
CHART_TYPE varchar(255) The type of the chart.
METRIC_ID varchar(255) The ID of the metric.
TIME_WINDOW varchar(255) The time window for the chart.
AUDIENCE_CHARTS_CAMPAIGN_DRA_0 bigint(20) Foreign key referencing the CAMPAIGN_DRAFT table.
AUDIENCE_CHARTS_HJORDER int(11) The order of the audience chart.
AUDIENCE_CHARTS_CAMPAIGN_MUT_0 bigint(20)

Foreign key referencing the CAMPAIGN_MUTABLE_ELEMENTS

table.

Foreign Key Relationships

  • AUDIENCE_CHARTS_CAMPAIGN_DRA_0 references CAMPAIGN_DRAFT(ID)
  • AUDIENCE_CHARTS_CAMPAIGN_MUT_0 references CAMPAIGN_MUTABLE_ELEMENTS(ID)