CAMPAIGN_PRODUCT

Description

This table stores the products associated with a campaign, including their category, cost to budget ratio, fulfillment product ID, name, and product ID.

Columns

Column Name Data Type Description
ID bigint The unique identifier of the campaign product.
CATEGORY varchar The category of the product.
COST_TO_BUDGET double The cost to budget ratio of the product.
FULFILLMENT_PRODUCT_ID varchar The ID of the fulfillment product associated with the campaign product.
NAME varchar The name of the product.
PRODUCT_ID varchar The ID of the product.

Primary Key

  • ID

Unique Keys

  • NAME, PRODUCT_ID