bridge_discount_campaign_to_allowed_origin_type


Description

Maps discount campaigns to their allowed sales channel origin types. One row per (campaign, origin_type) pair. Only origin types listed here are permitted to trigger the campaign discount when a contract is signed.

If a contract is created via a channel not present in this table for the active campaign, the campaign discount is not applied.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
discount_campaign_origin_type_id varchar 256 null

The primary key of this table. Surrogate key derived from (discount_campaign_id, origin_type).
discount_campaign_id int8 19 √ null
dim_discount_campaign.discount_campaign_id Implied Constraint R

The discount campaign whose allowed origin types are listed.
origin_type varchar 256 √ null

The sales channel that is permitted to apply this campaign.

One of: * CONFIGURATION_LINK: Sign-up via a MySports configuration/sharing link. * CONNECT_API: Sign-up via the Magicline Connect API. * EXTERNAL: Sign-up via the public Open API (generic external). * JOB: Automated by a background job (internal). * LANDING_PAGE: Sign-up via a campaign landing page. * MYSPORTS_APP: Sign-up via the MySports mobile app. * MYSPORTS_WEB: Sign-up via the MySports web client. * NOX: Sign-up via the NOX/MySports channel (legacy). * MEMBER_CHATBOT: Sign-up via the member-facing chatbot. * ONLINE_CHECKOUT_PAGE: Sign-up via the online checkout page. * OPEN_API: Sign-up via the public Open API. * PERSONALIZED_OFFER_PAGE: Sign-up via a personalised offer page. * SALES_TOOL: Created by staff using the internal sales tool. * TOUCHPOINT: Triggered via an internal studio touchpoint. * WEBCLIENT: Created via the internal back-office web client.
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