コンテンツにスキップ

SnowflakeとBrazeのエンティティ関係

このページでは、メッセージングチャネルごとに、Snowflake Data Sharingテーブル間のエンティティ関係を示します。

各関係図では、チャネルのイベントテーブルを1つのEVENTエンティティにまとめています。このエンティティには、それらのテーブル全体に含まれるすべての列が表示されます。また、チャネルのイベントと結合するキャンペーン、キャンバス、スナップショット、変更ログの各テーブルへのリンクも含まれています。

関係図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_BANNER_*_SHARED"] {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string BANNER_PLACEMENT_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string ABORT_LOG
        string ABORT_TYPE
        string AD_ID
        string AD_ID_TYPE
        boolean AD_TRACKING_ENABLED
        string BROWSER
        string BUTTON_ID
        string CAMPAIGN_NAME
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CARRIER
        string COUNTRY
        string DEVICE_MODEL
        string GENDER
        boolean IS_CONTROL
        boolean IS_UNIQUE
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string OS_VERSION
        string PLATFORM
        string RESOLUTION
        string SDK_VERSION
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

関係テーブル

ABORT_SHARED

// USERS_MESSAGES_BANNER_ABORT_SHARED
// An originally scheduled banner message was aborted for some reason.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "BANNER_PLACEMENT_ID": "Customer specified banner placement ID",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "ABORT_TYPE": "Type of abort. Refer to the abort types reference for a full list of values.",
        "ABORT_LOG": "[PII] Log message describing abort details (up to 128 chars)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier"
    }
}

CLICK_SHARED

// USERS_MESSAGES_BANNER_CLICK_SHARED
// When a user clicks a banner.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "BANNER_PLACEMENT_ID": "Customer specified banner placement ID",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "IS_UNIQUE": "Whether this event was considered 7-day unique when processed",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "BUTTON_ID": "ID of the button clicked, if this click represents a click on a button"
    }
}

DISMISS_SHARED

// USERS_MESSAGES_BANNER_DISMISS_SHARED
// When a user dismisses a banner.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "BANNER_PLACEMENT_ID": "Customer specified banner placement ID",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "IS_UNIQUE": "Whether this event was considered 7-day unique when processed",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "BUTTON_ID": "ID of the button clicked, if this click represents a click on a button"
    }
}

IMPRESSION_SHARED

// USERS_MESSAGES_BANNER_IMPRESSION_SHARED
// When a user views a banner.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "BANNER_PLACEMENT_ID": "Customer specified banner placement ID",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "IS_UNIQUE": "Whether this event was considered 7-day unique when processed",
        "IS_CONTROL": "Control group flag",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier"
    }
}

関係図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_CONTENTCARD_*_SHARED"] {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string CONTENT_CARD_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string ABORT_LOG
        string ABORT_TYPE
        string AD_ID
        string AD_ID_TYPE
        boolean AD_TRACKING_ENABLED
        string BROWSER
        string CAMPAIGN_NAME
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CARRIER
        string COUNTRY
        string DEVICE_MODEL
        string GENDER
        boolean IS_UNIQUE
        string LANGUAGE
        string MESSAGE_EXTRAS
        string MESSAGE_VARIATION_NAME
        string OS_VERSION
        string PLATFORM
        string RESOLUTION
        string SDK_VERSION
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

関係テーブル

ABORT_SHARED

// USERS_MESSAGES_CONTENTCARD_ABORT_SHARED
// An originally scheduled contentcard message was aborted for some reason.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "ABORT_TYPE": "Type of abort. Refer to the abort types reference for a full list of values.",
        "ABORT_LOG": "[PII] Log message describing abort details (up to 128 chars)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

CLICK_SHARED

// USERS_MESSAGES_CONTENTCARD_CLICK_SHARED
// When a user clicks a content card.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CONTENT_CARD_ID": "ID of the card that generated this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "IS_UNIQUE": "Whether this event was considered 7-day unique when processed",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

DISMISS_SHARED

// USERS_MESSAGES_CONTENTCARD_DISMISS_SHARED
// When a user dismisses a content card.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CONTENT_CARD_ID": "ID of the card that generated this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "IS_UNIQUE": "Whether this event was considered 7-day unique when processed",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

IMPRESSION_SHARED

// USERS_MESSAGES_CONTENTCARD_IMPRESSION_SHARED
// When a user views a content card.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CONTENT_CARD_ID": "ID of the card that generated this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "IS_UNIQUE": "Whether this event was considered 7-day unique when processed",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

SEND_SHARED

// USERS_MESSAGES_CONTENTCARD_SEND_SHARED
// When we send a content card to a user.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CONTENT_CARD_ID": "ID of the card that generated this event"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

関係図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_FEATUREFLAG_*_SHARED"] {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string BROWSER
        string CAMPAIGN_NAME
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CARRIER
        string COUNTRY
        string DEVICE_MODEL
        string FEATURE_FLAG_ID_NAME
        string GENDER
        boolean IS_UNIQUE
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string OS_VERSION
        string PLATFORM
        string RESOLUTION
        string SDK_VERSION
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

関係テーブル

IMPRESSION_SHARED

// USERS_MESSAGES_FEATUREFLAG_IMPRESSION_SHARED
// When a user views an feature flag.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_API_ID": "API ID of the app on which this event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "USER_ID": "[PII] Braze user ID of the user who performed this event"
    },
    "native_keys": {
        "FEATURE_FLAG_ID_NAME": "The Feature Flag Rollout identifier",
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "CARRIER": "Carrier of the device",
        "COUNTRY": "[PII] Country of the user",
        "DEVICE_MODEL": "Model of the device",
        "LANGUAGE": "[PII] Language of the user",
        "OS_VERSION": "Version of the operating system of the device",
        "PLATFORM": "Platform of the device",
        "RESOLUTION": "Resolution of the device",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "TIMEZONE": "Time zone of the user",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "IS_UNIQUE": "Whether this event was considered 7-day unique when processed",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

関係図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_INAPPMESSAGE_*_SHARED"] {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string CARD_API_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string ABORT_LOG
        string ABORT_TYPE
        string AD_ID
        string AD_ID_TYPE
        boolean AD_TRACKING_ENABLED
        string BROWSER
        string BUTTON_ID
        string CAMPAIGN_NAME
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CARRIER
        string COUNTRY
        string DEVICE_MODEL
        string GENDER
        string LANGUAGE
        string LOCALE_KEY
        string MESSAGE_EXTRAS
        string MESSAGE_VARIATION_NAME
        string OS_VERSION
        string PLATFORM
        string RESOLUTION
        string SDK_VERSION
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
        string VERSION
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

関係テーブル

ABORT_SHARED

// USERS_MESSAGES_INAPPMESSAGE_ABORT_SHARED
// An originally scheduled inappmessage message was aborted for some reason.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "CARD_API_ID": "API ID of the card",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "VERSION": "Which version of in-app message, legacy or triggered",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "ABORT_TYPE": "Type of abort. Refer to the abort types reference for a full list of values.",
        "ABORT_LOG": "[PII] Log message describing abort details (up to 128 chars)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

CLICK_SHARED

// USERS_MESSAGES_INAPPMESSAGE_CLICK_SHARED
// When a user clicks an in app message.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "CARD_API_ID": "API ID of the card",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "VERSION": "Which version of in-app message, legacy or triggered",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "SEND_ID": "Message send ID this message belongs to",
        "BUTTON_ID": "ID of the button clicked, if this click represents a click on a button"
    }
}

IMPRESSION_SHARED

// USERS_MESSAGES_INAPPMESSAGE_IMPRESSION_SHARED
// When a user views an in app message.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "CARD_API_ID": "API ID of the card",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "VERSION": "Which version of in-app message, legacy or triggered",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "LOCALE_KEY": "[PII] The key corresponding to the translations (for example 'en-us') used to compose this message (null for default).",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

関係図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_LANDINGPAGE_*_SHARED"] {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string EXTERNAL_USER_ID FK
        string LANDING_PAGE_API_ID FK
        string USER_ID FK
        string LANDING_PAGE_NAME
        boolean LIQUID_ENABLED
        timestamp SF_CREATED_AT
        string TARGET
        integer TIME
    }
  • PK = 主キー
  • FK = 外部キー

関係テーブル

CLICK_SHARED

// USERS_MESSAGES_LANDINGPAGE_CLICK_SHARED
// This event occurs when an end-user clicks on select elements and form fields on a landing page.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "LANDING_PAGE_API_ID": "API ID of the landing page this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "TARGET": "Configured tracking ID for the element that was clicked",
        "LANDING_PAGE_NAME": "Name of the landing page",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

FORMSUBMISSION_SHARED

// USERS_MESSAGES_LANDINGPAGE_FORMSUBMISSION_SHARED
// This event occurs when an end-user completes a form on a landing page and clicks on the button to submit the information.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "LANDING_PAGE_API_ID": "API ID of the landing page this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "LANDING_PAGE_NAME": "Name of the landing page",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

IMPRESSION_SHARED

// USERS_MESSAGES_LANDINGPAGE_IMPRESSION_SHARED
// This event occurs when an end-user's browser loads and displays a landing page.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "LANDING_PAGE_API_ID": "API ID of the landing page this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "LIQUID_ENABLED": "A boolean that indicates whether the landing page contains Liquid and was processed through the Liquid rendering pipeline.",
        "LANDING_PAGE_NAME": "Name of the landing page",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

関係図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_LINE_*_SHARED"] {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string LINE_CHANNEL_ID FK
        string MEDIA_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string NATIVE_LINE_ID FK
        string SUBSCRIPTION_GROUP_API_ID FK
        string USER_ID FK
        string ABORT_LOG
        string ABORT_TYPE
        string CAMPAIGN_NAME
        string CANVAS_STEP_NAME
        boolean IS_SUSPECTED_BOT_CLICK
        string LINE_CHANNEL_NAME
        string MESSAGE_BODY
        string MESSAGE_EXTRAS
        string RETRY_LOG
        string RETRY_TYPE
        string SEND_ID
        timestamp SF_CREATED_AT
        string SHORT_URL
        integer TIME
        string TIMEZONE
        string URL
        string USER_AGENT
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

関係テーブル

ABORT_SHARED

// USERS_MESSAGES_LINE_ABORT_SHARED
// When a scheduled LINE message cannot be delivered, before sending to LINE.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "LINE_CHANNEL_ID": "The LINE Channel ID the message was sent to or received from",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "NATIVE_LINE_ID": "[PII] The user's Line ID from which the message was sent to or received from",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "ABORT_LOG": "[PII] Log message describing abort details (up to 128 chars)",
        "ABORT_TYPE": "Type of abort. Refer to the abort types reference for a full list of values.",
        "LINE_CHANNEL_NAME": "The LINE Channel Name the message was sent to or received from",
        "TIMEZONE": "Time zone of the user",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

CLICK_SHARED

// USERS_MESSAGES_LINE_CLICK_SHARED
// When a user clicks a link in a LINE message where the link's domain matches the click tracking domain.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "NATIVE_LINE_ID": "[PII] The user's Line ID from which the message was sent to or received from",
        "LINE_CHANNEL_ID": "The LINE Channel ID the message was sent to or received from",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "DEVICE_ID": "ID of the device on which the event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "TIMEZONE": "Time zone of the user",
        "LINE_CHANNEL_NAME": "The LINE Channel Name the message was sent to or received from",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "IS_SUSPECTED_BOT_CLICK": "Whether this event was processed as a bot event",
        "SHORT_URL": "Shortened url that was clicked",
        "URL": "URL that the user clicked on",
        "USER_AGENT": "User agent on which the spam report occurred",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

INBOUNDRECEIVE_SHARED

// USERS_MESSAGES_LINE_INBOUNDRECEIVE_SHARED
// When a LINE message is received from a user.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "LINE_CHANNEL_ID": "The LINE Channel ID the message was sent to or received from",
        "MEDIA_ID": "The LINE-generated ID which can be used to retrieve inbound media from LINE",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "NATIVE_LINE_ID": "[PII] The user's Line ID from which the message was sent to or received from",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "LINE_CHANNEL_NAME": "The LINE Channel Name the message was sent to or received from",
        "MESSAGE_BODY": "Typed response from the user",
        "TIMEZONE": "Time zone of the user",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

RETRY_SHARED

// USERS_MESSAGES_LINE_RETRY_SHARED
// This event occurs when a message is deprioritized or frequency capped and will be retried later within the configured retry window.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "LINE_CHANNEL_ID": "The LINE Channel ID the message was sent to or received from",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "NATIVE_LINE_ID": "[PII] The user's Line ID from which the message was sent to or received from",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "RETRY_LOG": "Log message describing retry details",
        "RETRY_TYPE": "Type of retry",
        "LINE_CHANNEL_NAME": "The LINE Channel Name the message was sent to or received from",
        "TIMEZONE": "Time zone of the user",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

SEND_SHARED

// USERS_MESSAGES_LINE_SEND_SHARED
// When a LINE message is sent to LINE.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "LINE_CHANNEL_ID": "The LINE Channel ID the message was sent to or received from",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "NATIVE_LINE_ID": "[PII] The user's Line ID from which the message was sent to or received from",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "LINE_CHANNEL_NAME": "The LINE Channel Name the message was sent to or received from",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "TIMEZONE": "Time zone of the user",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

関係図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_LIVEACTIVITY_*_SHARED"] {
        string ID PK
        string ACTIVITY_ID FK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string ACTIVITY_ATTRIBUTES_TYPE
        string LIVE_ACTIVITY_EVENT_OUTCOME
        string LIVE_ACTIVITY_EVENT_TYPE
        string PUSH_TO_START_TOKEN
        timestamp SF_CREATED_AT
        integer TIME
        string UPDATE_TOKEN
    }
  • PK = 主キー
  • FK = 外部キー

関係テーブル

PUSHTOSTARTTOKENCHANGE_SHARED

// USERS_BEHAVIORS_LIVEACTIVITY_PUSHTOSTARTTOKENCHANGE_SHARED
// Live Activity Push To Start Token Change Events.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "ACTIVITY_ATTRIBUTES_TYPE": "Live Activity attribute type",
        "PUSH_TO_START_TOKEN": "Live Activity push to start token",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "IOS_PUSH_TOKEN_APNS_GATEWAY": "APNS gateway of the push token, only applies to iOS push tokens, 1 for development, 2 for production",
        "PUSH_TOKEN_STATE_CHANGE_TYPE": "A description of the push token state change type",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

UPDATETOKENCHANGE_SHARED

// USERS_BEHAVIORS_LIVEACTIVITY_UPDATETOKENCHANGE_SHARED
// Live Activity Update Token Change Events.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "ACTIVITY_ID": "Live Activity identifier",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "UPDATE_TOKEN": "Live Activity update token",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "IOS_PUSH_TOKEN_APNS_GATEWAY": "APNS gateway of the push token, only applies to iOS push tokens, 1 for development, 2 for production",
        "PUSH_TOKEN_STATE_CHANGE_TYPE": "A description of the push token state change type",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

OUTCOME_SHARED

// USERS_MESSAGES_LIVEACTIVITY_OUTCOME_SHARED
// Live Activity Outcome Events.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "ACTIVITY_ID": "Live Activity identifier",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "ACTIVITY_ATTRIBUTES_TYPE": "Live Activity attribute type",
        "PUSH_TO_START_TOKEN": "Live Activity push to start token",
        "UPDATE_TOKEN": "Live Activity update token",
        "LIVE_ACTIVITY_EVENT_TYPE": "Event type of Live Activity. One of ['start', 'update', 'end']",
        "LIVE_ACTIVITY_EVENT_OUTCOME": "Outcome of Live Activity event",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

SEND_SHARED

// USERS_MESSAGES_LIVEACTIVITY_SEND_SHARED
// Live Activity Send Events.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "ACTIVITY_ID": "Live Activity identifier",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "ACTIVITY_ATTRIBUTES_TYPE": "Live Activity attribute type",
        "PUSH_TO_START_TOKEN": "Live Activity push to start token",
        "UPDATE_TOKEN": "Live Activity update token",
        "LIVE_ACTIVITY_EVENT_TYPE": "Event type of Live Activity. One of ['start', 'update', 'end']",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

関係図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_PUSHNOTIFICATION_*_SHARED"] {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string ABORT_LOG
        string ABORT_TYPE
        string AD_ID
        string AD_ID_TYPE
        boolean AD_TRACKING_ENABLED
        string BROWSER
        string BUTTON_ACTION_TYPE
        string BUTTON_STRING
        string CAMPAIGN_NAME
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CARRIER
        string CLICK_URL
        string COUNTRY
        string DEVICE_MODEL
        string GENDER
        boolean IS_ARCHIVED
        string IS_SAMPLED
        string LANGUAGE
        string LOCALE_KEY
        string MESSAGE_EXTRAS
        string MESSAGE_VARIATION_NAME
        string OS_VERSION
        string PLATFORM
        string PUSH_TOKEN
        string RESOLUTION
        string RETRY_LOG
        string RETRY_TYPE
        string SDK_VERSION
        string SEND_ID
        timestamp SF_CREATED_AT
        string SLIDE_ACTION_TYPE
        string SLIDE_ID
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_COSTEP_SEND_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_ID FK
        string CANVAS_VARIATION_API_ID FK
        string CONTENT_OPTIMIZER_STEP_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COMBINATION_TOKEN
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_COSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COMBINATION_TOKEN
        string CONVERSION_TYPE
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_COSTEP_SEND_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_COSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

関係テーブル

TOKENSTATECHANGE_SHARED

// USERS_BEHAVIORS_PUSHNOTIFICATION_TOKENSTATECHANGE_SHARED
// Push Notification Token State Change Events.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "PUSH_TOKEN_DEVICE_ID": "Device id of the push token"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "TIME_MS": "Time in millisecond when the event happened",
        "PLATFORM": "Platform of the device",
        "PUSH_TOKEN": "Push token of the event",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PUSH_TOKEN_CREATED_AT": "UNIX timestamp at which the push token was created",
        "PUSH_TOKEN_UPDATED_AT": "UNIX timestamp at which the push token was last updated",
        "WEB_PUSH_TOKEN_USER_AUTH": "User auth of the push token, only applies to web push tokens",
        "WEB_PUSH_TOKEN_PUBLIC_KEY": "Public key of the push token, only applies to web push tokens",
        "IOS_PUSH_TOKEN_APNS_GATEWAY": "APNS gateway of the push token, only applies to iOS push tokens, 1 for development, 2 for production",
        "PUSH_TOKEN_STATE_CHANGE_TYPE": "A description of the push token state change type",
        "WEB_PUSH_TOKEN_VAPID_PUBLIC_KEY": "VAPID public key of the push token, only applies to web push tokens",
        "PUSH_TOKEN_PROVISIONALLY_OPTED_IN": "Provisionally opted in flag of the push token",
        "PUSH_TOKEN_FOREGROUND_PUSH_DISABLED": "Foreground push disabled flag of the push token",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

ABORT_SHARED

// USERS_MESSAGES_PUSHNOTIFICATION_ABORT_SHARED
// An originally scheduled pushnotification message was aborted for some reason.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "PLATFORM": "Platform of the device",
        "ABORT_TYPE": "Type of abort. Refer to the abort types reference for a full list of values.",
        "ABORT_LOG": "[PII] Log message describing abort details (up to 128 chars)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

BOUNCE_SHARED

// USERS_MESSAGES_PUSHNOTIFICATION_BOUNCE_SHARED
// When a push notification bounces.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "PUSH_TOKEN": "Push token of the event",
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "PLATFORM": "Platform of the device",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

INFLUENCEDOPEN_SHARED

// USERS_MESSAGES_PUSHNOTIFICATION_INFLUENCEDOPEN_SHARED
// When a user opens the app after receiving a notification without clicking on the notification.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

IOSFOREGROUND_SHARED

// USERS_MESSAGES_PUSHNOTIFICATION_IOSFOREGROUND_SHARED
// When a user receives a push notification while the app is open.
// This event is not supported by the Swift SDK and is deprecated in the Obj-C SDK.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

OPEN_SHARED

// USERS_MESSAGES_PUSHNOTIFICATION_OPEN_SHARED
// When a user opens a push notification or clicks a push notification button (including a CLOSE button that does NOT open the app).

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DEVICE_ID": "ID of the device on which the event occurred"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "RESOLUTION": "Resolution of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "BUTTON_STRING": "Identifier (button_string) of the push notification button clicked. null if not from a button click",
        "BUTTON_ACTION_TYPE": "Action type of the push notification button, null if not from a button click. One of ['uri', 'deep_link', 'none', 'close']",
        "SLIDE_ACTION_TYPE": "Action type of the push carousel slide",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "SEND_ID": "Message send ID this message belongs to",
        "SLIDE_ID": "Slide identifier of the push carousel slide user clicks on"
    }
}

RETRY_SHARED

// USERS_MESSAGES_PUSHNOTIFICATION_RETRY_SHARED
// This event occurs when a message is deprioritized or frequency capped and will be retried later within the configured retry window.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "PLATFORM": "Platform of the device",
        "RETRY_TYPE": "Type of retry",
        "RETRY_LOG": "Log message describing retry details",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

SEND_SHARED

// USERS_MESSAGES_PUSHNOTIFICATION_SEND_SHARED
// When we send a push notification to a user.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "PUSH_TOKEN": "Push token of the event",
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "PLATFORM": "Platform of the device",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "IS_SAMPLED": "Indicates whether the push send was sampled and expected a delivery event",
        "LOCALE_KEY": "[PII] The key corresponding to the translations (for example 'en-us') used to compose this message (null for default).",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CLICK_URL": "The rendered click action URL associated with the push notification, if one was set",
        "IS_ARCHIVED": "Whether a rendered copy of this message was archived to your configured message archiving destination.",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

関係図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_RCS_*_SHARED"] {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string SUBSCRIPTION_GROUP_API_ID FK
        string USER_ID FK
        string ABORT_LOG
        string ABORT_TYPE
        string ACTION
        string CAMPAIGN_NAME
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CATEGORY
        string ELEMENT_LABEL
        string ELEMENT_TYPE
        string ERROR
        string FROM_RCS_SENDER
        string INTERACTION_TYPE
        boolean IS_SMS_FALLBACK
        boolean IS_SUSPECTED_BOT_CLICK
        array MEDIA_URLS
        string MESSAGE_BODY
        string MESSAGE_EXTRAS
        string MESSAGE_VARIATION_NAME
        string PROVIDER_ERROR_CODE
        string SEND_ID
        timestamp SF_CREATED_AT
        string SHORT_URL
        array SUSPECTED_BOT_CLICK_REASON
        integer TIME
        string TO_PHONE_NUMBER
        string TO_RCS_SENDER
        string URL
        string USER_AGENT
        string USER_PHONE_NUMBER
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_COSTEP_SEND_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_ID FK
        string CANVAS_VARIATION_API_ID FK
        string CONTENT_OPTIMIZER_STEP_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COMBINATION_TOKEN
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_COSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COMBINATION_TOKEN
        string CONVERSION_TYPE
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_COSTEP_SEND_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_COSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

関係テーブル

ABORT_SHARED

// USERS_MESSAGES_RCS_ABORT_SHARED
// An event that is created when an RCS send is interrupted due to an error detected within Braze and the message is dropped.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "ABORT_LOG": "[PII] Log message describing abort details (up to 128 chars)",
        "ABORT_TYPE": "Type of abort. Refer to the abort types reference for a full list of values.",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

CLICK_SHARED

// USERS_MESSAGES_RCS_CLICK_SHARED
// An event that is created when the end user interacts with an RCS message in a way that involves tapping or clicking on a UI element.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "IS_SUSPECTED_BOT_CLICK": "Whether this event was processed as a bot event",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "SHORT_URL": "Shortened url that was clicked",
        "SUSPECTED_BOT_CLICK_REASON": "Why this event was classified as a bot",
        "USER_AGENT": "User agent on which the spam report occurred",
        "USER_PHONE_NUMBER": "[PII] The user's phone number from which the message was received",
        "INTERACTION_TYPE": "The type of interaction that generated the click. Example string values: Text URL, Reply, OpenURL",
        "ELEMENT_LABEL": "Optional details about the clicked element, such as the text of a suggested reply or button",
        "ELEMENT_TYPE": "Specifies if an interaction_type that is common across suggestions and buttons came from a suggestion or button. Examples: Suggestion, Button",
        "URL": "URL that the user clicked on",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

DELIVERY_SHARED

// USERS_MESSAGES_RCS_DELIVERY_SHARED
// An event that is created when an RCS message is successfully delivered to an end user's mobile device.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "FROM_RCS_SENDER": "The RCS sender ID or agent name used to send the message",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

INBOUNDRECEIVE_SHARED

// USERS_MESSAGES_RCS_INBOUNDRECEIVE_SHARED
// An event that is created when Braze receives an RCS message that originates from the end user.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "ACTION": "Action taken in response to this message. (for example Subscribed, Unsubscribed or None).",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "MEDIA_URLS": "Media URLs from the user",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "USER_PHONE_NUMBER": "[PII] The user's phone number from which the message was received",
        "MESSAGE_BODY": "Typed response from the user",
        "TO_RCS_SENDER": "The inbound RCS sender that the message was sent to",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

READ_SHARED

// USERS_MESSAGES_RCS_READ_SHARED
// An event that is created when the end user opens an RCS message on their device, indicating that they have seen/read the message content.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

REJECTION_SHARED

// USERS_MESSAGES_RCS_REJECTION_SHARED
// An event that is created when an RCS message fails to be delivered to an end user's mobile device due to intervention by the carrier.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "ERROR": "Error name",
        "FROM_RCS_SENDER": "The RCS sender ID or agent name used to send the message",
        "IS_SMS_FALLBACK": "Indicates if SMS fallback was attempted for this rejected RCS message. It is linked/paired to the SMS Delivery event",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "PROVIDER_ERROR_CODE": "Error code from the provider",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

SEND_SHARED

// USERS_MESSAGES_RCS_SEND_SHARED
// An event that is created when an RCS messages is sent out of Braze's systems to our last-mile delivery partners.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CATEGORY": "Keyword category name, only populated for auto-reply messages: 'opt-in', 'opt-out', 'help', or custom value",
        "FROM_RCS_SENDER": "The RCS sender ID or agent name used to send the message",
        "MESSAGE_EXTRAS": "A JSON string of the tagged key-value pairs during liquid rendering",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

関係図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_SMS_*_SHARED"] {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string SUBSCRIPTION_GROUP_API_ID FK
        string SUBSCRIPTION_GROUP_ID FK
        string USER_ID FK
        string ABORT_LOG
        string ABORT_TYPE
        string ACTION
        string CAMPAIGN_NAME
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CATEGORY
        string COUNTRY
        string ERROR
        string FROM_PHONE_NUMBER
        string GENDER
        string INBOUND_PHONE_NUMBER
        boolean IS_ARCHIVED
        boolean IS_SMS_FALLBACK
        boolean IS_SUSPECTED_BOT_CLICK
        string LANGUAGE
        array MEDIA_URLS
        string MESSAGE_BODY
        string MESSAGE_EXTRAS
        string MESSAGE_VARIATION_NAME
        string PROVIDER_ERROR_CODE
        string RETRY_LOG
        string RETRY_TYPE
        string SEND_ID
        timestamp SF_CREATED_AT
        string SHORT_URL
        array SUSPECTED_BOT_CLICK_REASON
        integer TIME
        string TIMEZONE
        string TO_PHONE_NUMBER
        string URL
        string USER_AGENT
        string USER_PHONE_NUMBER
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_COSTEP_SEND_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_ID FK
        string CANVAS_VARIATION_API_ID FK
        string CONTENT_OPTIMIZER_STEP_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COMBINATION_TOKEN
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_COSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COMBINATION_TOKEN
        string CONVERSION_TYPE
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_COSTEP_SEND_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_COSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

関係テーブル

ABORT_SHARED

// USERS_MESSAGES_SMS_ABORT_SHARED
// An originally scheduled SMS message was aborted.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "ABORT_TYPE": "Type of abort. Refer to the abort types reference for a full list of values.",
        "ABORT_LOG": "[PII] Log message describing abort details (up to 128 chars)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

CARRIERSEND_SHARED

// USERS_MESSAGES_SMS_CARRIERSEND_SHARED
// When a SMS message is sent to carrier.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "FROM_PHONE_NUMBER": "Phone number used to send in e.164 format (for example +14155552671)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

DELIVERYFAILURE_SHARED

// USERS_MESSAGES_SMS_DELIVERYFAILURE_SHARED
// When Braze is unable to deliver the SMS message to the SMS service provider.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "ERROR": "Error name",
        "PROVIDER_ERROR_CODE": "Error code from the SMS provider",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "IS_SMS_FALLBACK": "Indicates if SMS fallback was attempted for this rejected RCS message. It is linked/paired to the SMS Delivery event",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

DELIVERY_SHARED

// USERS_MESSAGES_SMS_DELIVERY_SHARED
// When a SMS message is delivered.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "FROM_PHONE_NUMBER": "Phone number used to send in e.164 format (for example +14155552671)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "IS_SMS_FALLBACK": "Indicates if SMS fallback was attempted for this rejected RCS message. It is linked/paired to the SMS Delivery event",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

INBOUNDRECEIVE_SHARED

// USERS_MESSAGES_SMS_INBOUNDRECEIVE_SHARED
// When a SMS message is received from a user.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "SUBSCRIPTION_GROUP_ID": "BSON ID of subscription group",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "USER_PHONE_NUMBER": "[PII] The user's phone number from which the message was received",
        "INBOUND_PHONE_NUMBER": "The inbound number that the message was sent to",
        "ACTION": "Action taken in response to this message. (for example Subscribed, Unsubscribed or None).",
        "MESSAGE_BODY": "Typed response from the user",
        "MEDIA_URLS": "Media URLs from the user",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

REJECTION_SHARED

// USERS_MESSAGES_SMS_REJECTION_SHARED
// When a SMS message is not delivered to a user.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "FROM_PHONE_NUMBER": "Phone number used to send in e.164 format (for example +14155552671)",
        "ERROR": "Error name",
        "PROVIDER_ERROR_CODE": "Error code from the SMS provider",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "IS_SMS_FALLBACK": "Indicates if SMS fallback was attempted for this rejected RCS message. It is linked/paired to the SMS Delivery event",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

RETRY_SHARED

// USERS_MESSAGES_SMS_RETRY_SHARED
// This event occurs when a message is deprioritized or frequency capped and will be retried later within the configured retry window.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "RETRY_TYPE": "Type of retry",
        "RETRY_LOG": "Log message describing retry details",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

SEND_SHARED

// USERS_MESSAGES_SMS_SEND_SHARED
// When a SMS message is sent.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "CATEGORY": "Keyword category name, only populated for auto-reply messages: 'opt-in', 'opt-out', 'help', or custom value",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "IS_ARCHIVED": "Whether a rendered copy of this message was archived to your configured message archiving destination.",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

SHORTLINKCLICK_SHARED

// USERS_MESSAGES_SMS_SHORTLINKCLICK_SHARED
// When a user clicks a Braze shortened URL included in an SMS message.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "TIMEZONE": "Time zone of the user",
        "URL": "URL that the user clicked on",
        "SHORT_URL": "Shortened url that was clicked",
        "USER_AGENT": "User agent on which the spam report occurred",
        "USER_PHONE_NUMBER": "[PII] The user's phone number from which the message was received",
        "IS_SUSPECTED_BOT_CLICK": "Whether this event was processed as a bot event",
        "SUSPECTED_BOT_CLICK_REASON": "Array of reasons why this event was classified as a bot",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

リレーションシップ図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_SURVEY_*_SHARED"] {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CANVAS_API_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string LANDING_PAGE_API_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string QUESTION_ID FK
        string QUESTION_REPORTING_ID FK
        string RESPONSE_ID FK
        string SURVEY_ID FK
        string SURVEY_SESSION_ID FK
        string USER_ID FK
        string AD_ID
        string AD_ID_TYPE
        boolean AD_TRACKING_ENABLED
        string ANSWER_LONG_STRING
        string ANSWER_MULTIPLE_STRINGS
        boolean ANSWER_SINGLE_BOOLEAN
        float ANSWER_SINGLE_NUMBER
        string ANSWER_SINGLE_STRING
        string ANSWER_TYPE
        string BROWSER
        string CAMPAIGN_NAME
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CARRIER
        string COUNTRY
        string DEVICE_MODEL
        string GENDER
        string LANDING_PAGE_NAME
        string MESSAGE_EXTRAS
        string MESSAGE_VARIATION_NAME
        string OS_VERSION
        string PLATFORM
        string SDK_VERSION
        timestamp SF_CREATED_AT
        string SURVEY_COMPLETION_STATUS
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

リレーションシップテーブル

RESPONSE_SHARED

// USERS_MESSAGES_SURVEY_RESPONSE_SHARED
// Survey responses submitted by end users.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "SURVEY_ID": "UUID of the survey to which this response belongs.",
        "QUESTION_ID": "UUID of the question to which this response belongs.",
        "DEVICE_ID": "[PII] ID of the device on which the event occurred",
        "SURVEY_SESSION_ID": "Unique identifier to group all responses from a single survey session",
        "LANDING_PAGE_API_ID": "API ID of the landing page this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "RESPONSE_ID": "Unique identifier represent the response",
        "APP_API_ID": "API ID of the app on which this event occurred",
        "QUESTION_REPORTING_ID": "The reporting identifier for the survey question"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "SDK_VERSION": "Version of the Braze SDK in use during the event",
        "PLATFORM": "Platform of the device",
        "OS_VERSION": "Version of the operating system of the device",
        "DEVICE_MODEL": "Model of the device",
        "CARRIER": "Carrier of the device",
        "BROWSER": "Device browser - extracted from user_agent - on which the open occurred",
        "AD_ID_TYPE": "One of ['ios_idfa', 'google_ad_id', 'windows_ad_id', 'roku_ad_id']",
        "AD_TRACKING_ENABLED": "Whether advertising tracking is enabled for the device",
        "ANSWER_SINGLE_STRING": "[PII] The raw response when response_type is single_string",
        "ANSWER_SINGLE_BOOLEAN": "[PII] The raw response when response_type is single_boolean",
        "ANSWER_TYPE": "Answer type of the event, one of ['single_int', 'single_string', 'single_boolean']",
        "ANSWER_LONG_STRING": "[PII] The raw response when response_type is free_form_text",
        "ANSWER_MULTIPLE_STRINGS": "[PII] The raw response when answer_type is multiple_string.",
        "SURVEY_COMPLETION_STATUS": "One of ['completed', 'incomplete']",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "LANDING_PAGE_NAME": "Name of the landing page",
        "ANSWER_SINGLE_NUMBER": "[PII] The raw response when answer_type is single_number",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "AD_ID": "[PII] Advertising identifier"
    }
}

リレーションシップ図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_WEBHOOK_*_SHARED"] {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string ABORT_LOG
        string ABORT_TYPE
        string CAMPAIGN_NAME
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        integer CONTENT_LENGTH
        string COUNTRY
        string ENDPOINT_URL
        string GENDER
        string HOST
        integer HTTP_STATUS_CODE
        boolean IS_TERMINAL
        string LANGUAGE
        string MESSAGE_EXTRAS
        string MESSAGE_VARIATION_NAME
        string RAW_RESPONSE
        integer RETRY_COUNT
        string RETRY_LOG
        string RETRY_TYPE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
        string URL_PATH
        integer WEBHOOK_DURATION
        string WEBHOOK_FAILURE_SOURCE
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

リレーションシップテーブル

ABORT_SHARED

// USERS_MESSAGES_WEBHOOK_ABORT_SHARED
// An originally scheduled webhook message was aborted for some reason.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "ABORT_TYPE": "Type of abort. Refer to the abort types reference for a full list of values.",
        "ABORT_LOG": "[PII] Log message describing abort details (up to 128 chars)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

FAILURE_SHARED

// USERS_MESSAGES_WEBHOOK_FAILURE_SHARED
// A webhook message was delivered but failed with an error response from the endpoint.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "USER_ID": "[PII] Braze user ID of the user who performed this event"
    },
    "native_keys": {
        "HTTP_STATUS_CODE": "HTTP status code of the response",
        "ENDPOINT_URL": "The endpoint url being requested",
        "CONTENT_LENGTH": "Content length of the response",
        "HOST": "The host for the request",
        "RAW_RESPONSE": "Truncated raw response from endpoint",
        "RETRY_COUNT": "The number of retries attempted",
        "TIME": "UNIX timestamp at which the event happened",
        "URL_PATH": "The path of the url being requested",
        "WEBHOOK_DURATION": "Total duration of this request in milliseconds",
        "WEBHOOK_FAILURE_SOURCE": "To tell whether an error was created by Braze or by the endpoint itself. The source field could be External Endpoint, Treat no status code to host unreachable",
        "IS_TERMINAL": "Whether this event was the terminal attempt in a send",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

RETRY_SHARED

// USERS_MESSAGES_WEBHOOK_RETRY_SHARED
// This event occurs when a message is deprioritized or frequency capped and will be retried later within the configured retry window.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "RETRY_TYPE": "Type of retry",
        "RETRY_LOG": "Log message describing retry details",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

SEND_SHARED

// USERS_MESSAGES_WEBHOOK_SEND_SHARED
// When we send a webhook for a user.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "GENDER": "[PII] Gender of the user",
        "COUNTRY": "[PII] Country of the user",
        "TIMEZONE": "Time zone of the user",
        "LANGUAGE": "[PII] Language of the user",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

リレーションシップ図

---
config:
  layout: elk
  elk:
    mergeEdges: true
    nodePlacementStrategy: LINEAR_SEGMENTS
---
erDiagram
    EVENT["USERS_MESSAGES_WHATSAPP_*_SHARED"] {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string CATALOG_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string FLOW_ID FK
        string MESSAGE_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string PRODUCT_ID FK
        string SUBSCRIPTION_GROUP_API_ID FK
        string USER_ID FK
        string ABORT_LOG
        string ABORT_TYPE
        string ACTION
        string BSUID
        string CAMPAIGN_NAME
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string FLOW_RESPONSE_JSON
        string FROM_PHONE_NUMBER
        string INBOUND_PHONE_NUMBER
        string IN_REPLY_TO
        array MEDIA_URLS
        string MESSAGE_BODY
        string MESSAGE_EXTRAS
        string MESSAGE_VARIATION_NAME
        string PROVIDER_ERROR_CODE
        string PROVIDER_ERROR_TITLE
        string QUICK_REPLY_TEXT
        string RETRY_LOG
        string RETRY_TYPE
        string SEND_ID
        timestamp SF_CREATED_AT
        string SHORT_URL
        string TEMPLATE_NAME
        integer TIME
        string TIMEZONE
        string TO_PHONE_NUMBER
        string URL
        string USER_AGENT
        string USER_PHONE_NUMBER
    }

    CHANGELOGS_CAMPAIGN_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array ACTIONS
    }
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }

    USERS_CAMPAIGNS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CAMPAIGN_API_ID FK
        string CAMPAIGN_ID FK
        string DEVICE_ID FK
        string DISPATCH_ID FK
        string EXTERNAL_USER_ID FK
        string MESSAGE_VARIATION_API_ID FK
        string USER_ID FK
        string CAMPAIGN_NAME
        string COUNTRY
        string GENDER
        string LANGUAGE
        string MESSAGE_VARIATION_NAME
        string SEND_ID
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    USERS_CANVAS_ENTRY_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string COUNTRY
        string GENDER
        boolean IN_CONTROL_GROUP
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED {
        string ID PK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string EXPERIMENT_SPLIT_NAME
        boolean IN_CONTROL_GROUP
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_FREQUENCYCAP_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CHANNEL
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string REASON
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED {
        string ID PK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DESTINATION_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_STEP_TYPE
        string CANVAS_VARIATION_NAME
        string DESTINATION_NAME
        string DESTINATION_TYPE
        string DESTINATION_VARIANT_TYPE
        string DESTINATION_VARIATION_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }

    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string EXPERIMENT_SPLIT_API_ID FK
        string EXPERIMENT_STEP_API_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string EXPERIMENT_SPLIT_NAME
        timestamp SF_CREATED_AT
        integer TIME
    }
    USERS_CANVAS_CONVERSION_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string CANVAS_NAME
        string CANVAS_STEP_NAME
        string CANVAS_VARIATION_NAME
        string CONVERSION_BEHAVIOR
        integer CONVERSION_BEHAVIOR_INDEX
        string COUNTRY
        string GENDER
        string LANGUAGE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }
    USERS_CANVAS_REVENUE_SHARED {
        string ID PK
        string APP_API_ID FK
        string APP_GROUP_API_ID FK
        string APP_GROUP_ID FK
        string CANVAS_API_ID FK
        string CANVAS_ID FK
        string CANVAS_STEP_API_ID FK
        string CANVAS_STEP_MESSAGE_VARIATION_API_ID FK
        string CANVAS_VARIATION_API_ID FK
        string DEVICE_ID FK
        string EXTERNAL_USER_ID FK
        string USER_ID FK
        string COUNTRY
        string GENDER
        string LANGUAGE
        integer REVENUE
        timestamp SF_CREATED_AT
        integer TIME
        string TIMEZONE
    }

    CHANGELOGS_CANVAS_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array CONVERSION_BEHAVIORS
        array VARIATIONS
    }
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }
    SNAPSHOTS_CANVAS_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
        array ACTIONS
    }
    SNAPSHOTS_CANVAS_VARIATION_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string API_ID
        string NAME
    }
    SNAPSHOTS_EXPERIMENT_STEP_SHARED {
        string ID FK
        integer TIME
        string APP_GROUP_ID
        string TYPE
        string API_STEP_ID
        array EXPERIMENT_SPLITS
        array CONVERSION_BEHAVIORS
        string NAME
    }

    %% Relationships for Group Labels
    GROUP_1["Campaign Snapshots and Log"] { }
    CHANGELOGS_CAMPAIGN_SHARED ||--o{ GROUP_1 : joins
    SNAPSHOTS_CAMPAIGN_MESSAGE_VARIATION_SHARED ||--o{ GROUP_1 : joins
    GROUP_1 ||--o{ EVENT : joins

    GROUP_2["Campaign Events"] { }
    USERS_CAMPAIGNS_CONVERSION_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_ENROLLINCONTROL_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_FREQUENCYCAP_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_REVENUE_SHARED ||--o{ GROUP_2 : joins
    USERS_CAMPAIGNS_UNIQUERECEIPT_SHARED ||--o{ GROUP_2 : joins
    GROUP_2 ||--o{ EVENT : joins

    GROUP_3["Canvas Events"] { }
    USERS_CANVAS_ENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXPERIMENTSTEP_SPLITENTRY_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_MATCHEDAUDIENCE_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_EXIT_PERFORMEDEVENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_FREQUENCYCAP_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_NOTSENT_SHARED ||--o{ GROUP_3 : joins
    USERS_CANVAS_SENDTODESTINATION_SENT_SHARED ||--o{ GROUP_3 : joins
    GROUP_3 ||--o{ EVENT : joins

    GROUP_4["Canvas Conversions"] { }
    USERS_CANVAS_EXPERIMENTSTEP_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_CONVERSION_SHARED ||--o{ GROUP_4 : joins
    USERS_CANVAS_REVENUE_SHARED ||--o{ GROUP_4 : joins
    GROUP_4 ||--o{ EVENT : joins

    GROUP_5["Canvas Snapshots and Log"] { }
    CHANGELOGS_CANVAS_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_FLOW_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_STEP_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_CANVAS_VARIATION_SHARED ||--o{ GROUP_5 : joins
    SNAPSHOTS_EXPERIMENT_STEP_SHARED ||--o{ GROUP_5 : joins
    GROUP_5 ||--o{ EVENT : joins
  • PK = 主キー
  • FK = 外部キー

リレーションシップテーブル

ABORT_SHARED

// USERS_MESSAGES_WHATSAPP_ABORT_SHARED
// When a scheduled WhatsApp message cannot be delivered, before sending to Meta.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DISPATCH_ID": "ID of the dispatch this message belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "TIMEZONE": "Time zone of the user",
        "ABORT_TYPE": "Type of abort. Refer to the abort types reference for a full list of values.",
        "ABORT_LOG": "[PII] Log message describing abort details (up to 128 chars)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "BSUID": "The WhatsApp Business-Scoped User ID of the user from which the message was received.",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

CLICK_SHARED

// USERS_MESSAGES_WHATSAPP_CLICK_SHARED
// When a user clicks a link or button in a WhatsApp message where the link's domain matches the click tracking domain.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "TIMEZONE": "Time zone of the user",
        "URL": "URL that the user clicked on",
        "SHORT_URL": "Shortened url that was clicked",
        "USER_AGENT": "User agent on which the spam report occurred",
        "USER_PHONE_NUMBER": "[PII] The user's phone number from which the message was received",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

DELIVERY_SHARED

// USERS_MESSAGES_WHATSAPP_DELIVERY_SHARED
// When a WhatsApp message is delivered to the end user.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "FLOW_ID": "The unique ID of the Flow in the WhatsApp Manager. Present if the user is responding to a WhatsApp Flow.",
        "MESSAGE_ID": "The unique ID generated by Meta for this message"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "TIMEZONE": "Time zone of the user",
        "FROM_PHONE_NUMBER": "Phone number used to send in e.164 format (for example +14155552671)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "TEMPLATE_NAME": "[PII] Name of the template in the WhatsApp manager. Present if sending a Template Message",
        "BSUID": "The WhatsApp Business-Scoped User ID of the user from which the message was received.",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

FAILURE_SHARED

// USERS_MESSAGES_WHATSAPP_FAILURE_SHARED
// When a WhatsApp message cannot be delivered, after sending to Meta.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "MESSAGE_ID": "The unique ID generated by Meta for this message",
        "FLOW_ID": "The unique ID of the Flow in the WhatsApp Manager. Present if the user is responding to a WhatsApp Flow."
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "TIMEZONE": "Time zone of the user",
        "FROM_PHONE_NUMBER": "Phone number used to send in e.164 format (for example +14155552671)",
        "PROVIDER_ERROR_CODE": "Error code from WhatsApp",
        "PROVIDER_ERROR_TITLE": "Description of error from WhatsApp",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "TEMPLATE_NAME": "[PII] Name of the template in the WhatsApp manager. Present if sending a Template Message",
        "BSUID": "The WhatsApp Business-Scoped User ID of the user from which the message was received.",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

INBOUNDRECEIVE_SHARED

// USERS_MESSAGES_WHATSAPP_INBOUNDRECEIVE_SHARED
// When a WhatsApp message is received from a user.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CATALOG_ID": "Catalog ID of a product if a product is referenced in the inbound message. Otherwise, empty.",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "PRODUCT_ID": "ID of the product purchased",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "FLOW_ID": "The unique ID of the Flow in the WhatsApp Manager. Present if the user is responding to a WhatsApp Flow.",
        "MESSAGE_ID": "The unique ID generated by Meta for this message"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "ACTION": "Action taken in response to this message. (for example Subscribed, Unsubscribed or None).",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "INBOUND_PHONE_NUMBER": "The inbound number that the message was sent to",
        "MEDIA_URLS": "Media URLs from the user",
        "MESSAGE_BODY": "Typed response from the user",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "QUICK_REPLY_TEXT": "Text of button pressed by the user",
        "TIMEZONE": "Time zone of the user",
        "USER_PHONE_NUMBER": "[PII] The user's phone number from which the message was received",
        "FLOW_RESPONSE_JSON": "[PII] The form values the user responded with. Present if the user is responding to a WhatsApp Flow.",
        "IN_REPLY_TO": "The message_id of the message this message was replying to",
        "BSUID": "The WhatsApp Business-Scoped User ID of the user from which the message was received.",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

READ_SHARED

// USERS_MESSAGES_WHATSAPP_READ_SHARED
// When a WhatsApp message is read by the user.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "MESSAGE_ID": "The unique ID generated by Meta for this message",
        "FLOW_ID": "The unique ID of the Flow in the WhatsApp Manager. Present if the user is responding to a WhatsApp Flow."
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "TIMEZONE": "Time zone of the user",
        "FROM_PHONE_NUMBER": "Phone number used to send in e.164 format (for example +14155552671)",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "TEMPLATE_NAME": "[PII] Name of the template in the WhatsApp manager. Present if sending a Template Message",
        "BSUID": "The WhatsApp Business-Scoped User ID of the user from which the message was received.",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}

RETRY_SHARED

// USERS_MESSAGES_WHATSAPP_RETRY_SHARED
// This event occurs when a message is deprioritized or frequency capped and will be retried later within the configured retry window.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "DISPATCH_ID": "ID of the dispatch this message belongs to"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "TIMEZONE": "Time zone of the user",
        "RETRY_TYPE": "Type of retry",
        "RETRY_LOG": "Log message describing retry details",
        "CAMPAIGN_NAME": "Name of the campaign",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "BSUID": "The WhatsApp Business-Scoped User ID of the user from which the message was received.",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe"
    }
}

SEND_SHARED

// USERS_MESSAGES_WHATSAPP_SEND_SHARED
// When a WhatsApp message is sent to Meta.

{
    "primary_key": {
        "ID": "Globally unique ID for this event"
    },
    "foreign_keys": {
        "APP_GROUP_API_ID": "API ID of the app group this user belongs to",
        "APP_GROUP_ID": "BSON ID of the app group this user belongs to",
        "EXTERNAL_USER_ID": "[PII] External ID of the user",
        "USER_ID": "[PII] Braze user ID of the user who performed this event",
        "CAMPAIGN_API_ID": "API ID of the campaign this event belongs to",
        "CAMPAIGN_ID": "BSON ID of the campaign this event belongs to",
        "CANVAS_API_ID": "API ID of the Canvas this event belongs to",
        "CANVAS_ID": "BSON ID of the Canvas this event belongs to",
        "CANVAS_STEP_API_ID": "API ID of the Canvas step this event belongs to",
        "CANVAS_STEP_MESSAGE_VARIATION_API_ID": "API ID of the Canvas step message variation this user received",
        "CANVAS_VARIATION_API_ID": "API ID of the Canvas variation this event belongs to",
        "DEVICE_ID": "ID of the device on which the event occurred",
        "DISPATCH_ID": "ID of the dispatch this message belongs to",
        "MESSAGE_VARIATION_API_ID": "API ID of the message variation this user received",
        "SUBSCRIPTION_GROUP_API_ID": "Subscription group API ID",
        "FLOW_ID": "The unique ID of the Flow in the WhatsApp Manager. Present if the user is responding to a WhatsApp Flow.",
        "MESSAGE_ID": "The unique ID generated by Meta for this message"
    },
    "native_keys": {
        "TIME": "UNIX timestamp at which the event happened",
        "CAMPAIGN_NAME": "Name of the campaign",
        "CANVAS_NAME": "Name of the Canvas",
        "CANVAS_STEP_NAME": "Name of the Canvas step",
        "CANVAS_VARIATION_NAME": "Name of the Canvas variation this user received",
        "FROM_PHONE_NUMBER": "Phone number used to send in e.164 format (for example +14155552671)",
        "MESSAGE_EXTRAS": "[PII] A JSON string of the tagged key-value pairs during liquid rendering",
        "MESSAGE_VARIATION_NAME": "Name of the message variation",
        "TIMEZONE": "Time zone of the user",
        "TO_PHONE_NUMBER": "[PII] Phone number of the user receiving the message in e.164 format (for example +14155552671)",
        "TEMPLATE_NAME": "[PII] Name of the template in the WhatsApp manager. Present if sending a Template Message",
        "BSUID": "The WhatsApp Business-Scoped User ID of the user from which the message was received.",
        "SF_CREATED_AT": "when this event was picked up by the Snowpipe",
        "SEND_ID": "Message send ID this message belongs to"
    }
}
New Stuff!