dim_campaign


Description

Campaign dimension

Columns

Column Type Size Nulls Auto Default Children Parents Comments
campaign_id varchar 256 null
dim_contract_voucher_definition.campaign_id dim_contract_voucher_definition_campaign_id_fkey R
fct_contract_voucher.campaign_id fct_contract_voucher_campaign_id_fkey R
fct_lead_lifetime.campaign_id fct_lead_lifetime_campaign_id_fkey R

Primary key for campaign
name varchar 256 √ null

Campaign name
description varchar 256 √ null

Campaign description
external_identifier varchar 256 √ null

External identifier for the campaign
archived bool 1 √ null

Permanently removed but kept for historic relations
created_date_time timestamptz 35 √ null

Timestamp when the campaign was created
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).

Relationships

Close relationships within degrees of separation