Braze

Explore the interactive ERD

Table & Field Reference

canvas_conversion_event

Column	Type	Keys
`id`	String	PK
`canvas_conversion_behavior_id`	String	FK
`canvas_id`	String	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`user_id`	String	FK
`app_id`	String
`canvas_step_id`	String
`canvas_step_updated_at`	Instant
`event_type`	String
`external_user_id`	String
`time`	Instant
`timezone`	String

whatsapp_event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_message_variation_id`	String	FK
`canvas_step_message_variation_updated_at`	Instant	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`device_id`	String	FK
`message_variation_id`	String	FK
`message_variation_updated_at`	Instant	FK
`user_id`	String	FK
`abort_log`	String
`abort_type`	String
`action`	String
`app_group_id`	String
`catalog_id`	String
`dispatch_id`	String
`event_type`	String
`external_user_id`	String
`flow_id`	String
`from_phone_number`	String
`in_reply_to`	String
`inbound_phone_number`	String
`media_urls`	Json
`message_body`	String
`message_extras`	String
`message_id`	String
`product_id`	String
`provider_error_code`	String
`provider_error_title`	String
`quick_reply_text`	String
`send_id`	String
`short_url`	String
`subscription_group_id`	String
`template_name`	String
`time`	Instant
`timezone`	String
`to_phone_number`	String
`url`	String
`user_agent`	String
`user_phone_number`	String

card_tag

Column	Type	Keys
`card_id`	String	PK
`tag`	String	PK
`card_updated_at`	Instant	FK

card_extra

Column	Type	Keys
`card_id`	String	PK
`key`	String	PK
`card_updated_at`	Instant	FK
`error`	Boolean
`message`	String
`value`	String

user_push_token

Column	Type	Keys
`index`	Int	PK
`user_id`	String	PKFK
`app`	String
`device_id`	String
`notifications_enabled`	Boolean
`platform`	String
`token`	String

webhook_event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_message_variation_id`	String	FK
`canvas_step_message_variation_updated_at`	Instant	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`device_id`	String	FK
`message_variation_id`	String	FK
`message_variation_updated_at`	Instant	FK
`user_id`	String	FK
`abort_log`	String
`abort_type`	String
`app_group_id`	String
`content_length`	Int
`dispatch_id`	String
`endpoint_url`	String
`event_type`	String
`external_user_id`	String
`host`	String
`http_status_code`	Int
`is_terminal`	Boolean
`message_extras`	Json
`raw_response`	String
`retry_count`	Int
`send_id`	String
`time`	Instant
`timezone`	String
`url_path`	String
`webhook_duration`	Int
`webhook_failure_source`	String

whatsapp_flow_response

Column	Type	Keys
`key`	String	PK
`event_id`	String	PKFK
`value`	String

content_card_event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_message_variation_id`	String	FK
`canvas_step_message_variation_updated_at`	Instant	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`device_id`	String	FK
`message_variation_id`	String	FK
`message_variation_updated_at`	Instant	FK
`user_id`	String	FK
`abort_log`	String
`abort_type`	String
`app_group_id`	String
`app_id`	String
`content_card_id`	String
`dispatch_id`	String
`event_type`	String
`external_user_id`	String
`message_extras`	Json
`send_id`	String
`time`	Instant
`timezone`	String

device

Column	Type	Keys
`id`	String	PK
`device_model`	String
`os_version`	String
`platform`	String

canvas_step_progression_event

Column	Type	Keys
`id`	String	PK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`device_id`	String	FK
`next_step_id`	String	FK
`user_id`	String	FK
`app_group_id`	String
`canvas_entry_id`	String
`event_type`	String
`exit_reason`	String
`external_user_id`	String
`is_canvas_entry`	Boolean
`progression_type`	String
`time`	Instant

in_app_message_event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_message_variation_id`	String	FK
`canvas_step_message_variation_updated_at`	Instant	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`device_id`	String	FK
`message_variation_id`	String	FK
`message_variation_updated_at`	Instant	FK
`user_id`	String	FK
`abort_log`	String
`abort_type`	String
`ad_id`	String
`ad_id_type`	String
`ad_tracking_enabled`	Boolean
`app_group_id`	String
`app_id`	String
`browser`	String
`button_id`	String
`card_id`	String
`card_updated_at`	Instant
`carrier`	String
`dispatch_id`	String
`event_type`	String
`external_user_id`	String
`resolution`	String
`send_id`	String
`time`	Instant
`timezone`	String
`version`	String

canvas_variation

Column	Type	Keys
`canvas_id`	String	PK
`id`	String	PK
`name`	String	PK
`canvas_updated_at`	Instant	FK

campaign_variation_analytics

Column	Type	Keys
`channel`	String	PK
`campaign_id`	String	PKFK
`time`	Instant	PKFK
`variation_api_id`	String	PKFK
`body_clicks`	Int
`bounces`	Int
`clicks`	Int
`conversions`	Int
`conversions_1`	Int
`conversions_1_by_send_time`	Int
`conversions_2`	Int
`conversions_2_by_send_time`	Int
`conversions_3`	Int
`conversions_3_by_send_time`	Int
`conversions_by_send_time`	Int
`delivered`	Int
`delivery_failed`	Int
`direct_opens`	Int
`enrolled`	Int
`errors`	Int
`failed`	Int
`help`	Int
`machine_amp_open`	Int
`machine_open`	Int
`opens`	Int
`opt_out`	Int
`read`	Int
`rejected`	Int
`reported_spam`	Int
`revenue`	Double
`sent`	Int
`sent_to_carrier`	Int
`total_clicks`	Int
`total_dismissals`	Int
`total_impressions`	Int
`total_opens`	Int
`unique_clicks`	Int
`unique_dismissals`	Int
`unique_impressions`	Int
`unique_opens`	Int
`unique_recipients`	Int
`unsubscribes`	Int

canvas_experiment_step_entry_event

Column	Type	Keys
`id`	String	PK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`user_id`	String	FK
`event_type`	String
`experiment_split_id`	String
`experiment_split_name`	String
`experiment_step_id`	String
`external_user_id`	String
`in_control_group`	Boolean
`time`	Instant

canvas_conversion_behavior

Column	Type	Keys
`id`	String	PK
`canvas_id`	String	PKFK
`canvas_updated_at`	Instant	FK
`conversion_behavior`	String
`conversion_behavior_index`	Int

location_event

Column	Type	Keys
`id`	String	PK
`device_id`	String	FK
`user_id`	String	FK
`alt_accuracy`	String
`altitude`	String
`app_id`	String
`event_type`	String
`external_user_id`	String
`latitude`	String
`ll_accuracy`	String
`longitude`	String
`time`	Instant

canvas_experiment_step_conversion_event

Column	Type	Keys
`id`	String	PK
`canvas_conversion_behavior_id`	String	FK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`user_id`	String	FK
`app_id`	String
`event_type`	String
`experiment_split_id`	String
`experiment_split_name`	String
`experiment_step_id`	String
`external_user_id`	String
`time`	Instant

campaign_conversion_behavior

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	PKFK
`campaign_updated_at`	Instant	FK
`conversion_behavior`	String
`conversion_behavior_index`	String
`updated_at`	Instant

newsfeed_impression_event

Column	Type	Keys
`id`	String	PK
`device_id`	String	FK
`user_id`	String	FK
`app_id`	String
`event_type`	String
`external_user_id`	String
`time`	Instant

message_variation

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`canvas_step_id`	String	FK
`canvas_step_updated_at`	Instant	FK
`action`	String
`alert`	String
`body`	String
`channel`	String
`extras`	Json
`from`	String
`headers`	String
`image_url`	String
`large_image_url`	String
`method`	String
`name`	String
`preheader`	String
`reply_to`	String
`subject`	String
`title`	String
`type`	String
`url`	String

canvas_entry_event

Column	Type	Keys
`id`	String	PK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_updated_at`	String	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`user_id`	String	FK
`event_type`	String
`external_user_id`	String
`in_control_group`	String
`time`	Instant
`timezone`	String

email_event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_message_variation_id`	String	FK
`canvas_step_message_variation_updated_at`	Instant	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`device_id`	String	FK
`message_variation_id`	String	FK
`message_variation_updated_at`	Instant	FK
`user_id`	String	FK
`abort_log`	String
`abort_type`	String
`app_group_id`	String
`bounce_reason`	String
`dispatch_id`	String
`email_address`	String
`esp`	String
`event_type`	String
`external_user_id`	String
`from_domain`	String
`ip_pool`	String
`is_amp`	Boolean
`is_drop`	Boolean
`is_suspected_bot_click`	Boolean
`link_alias`	String
`link_id`	String
`machine_open`	String
`message_extras`	Json
`send_id`	String
`sending_ip`	String
`suspected_bot_click_reason`	Json
`time`	Instant
`timezone`	String
`url`	String
`user_agent`	String

canvas_exit_event

Column	Type	Keys
`id`	String	PK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`user_id`	String	FK
`app_group_id`	String
`event_type`	String
`external_user_id`	String
`time`	Instant

segment

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`analytics_tracking_enabled`	Boolean
`created_at`	Instant
`description`	String
`error`	Boolean
`message`	String
`name`	String
`text_description`	String

user

Column	Type	Keys
`id`	String	PK
`attributed_ad`	String
`attributed_adgroup`	String
`attributed_campaign`	String
`attributed_source`	String
`country`	String
`created_at`	Instant
`dob`	Instant
`email`	String
`email_subscribe`	String
`external_id`	String
`first_name`	String
`gender`	String
`home_city`	String
`language`	String
`last_name`	String
`phone`	String
`push_subscribe`	String
`time_zone`	String
`total_revenue`	Float

campaign_analytics

Column	Type	Keys
`time`	Instant	PK
`campaign_id`	String	PKFK
`conversions`	Int
`conversions_1`	Int
`conversions_1_by_send_time`	Int
`conversions_2`	Int
`conversions_2_by_send_time`	Int
`conversions_3`	Int
`conversions_3_by_send_time`	Int
`conversions_by_send_time`	Int
`revenue`	Double
`unique_recipients`	Int

attribution_event

Column	Type	Keys
`id`	String	PK
`user_id`	String	FK
`event_type`	String
`external_user_id`	String
`source`	String
`time`	Instant

segment_tag

Column	Type	Keys
`tag`	String	PK
`segment_id`	String	PKFK

subscription_event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`message_variation_id`	String	FK
`message_variation_updated_at`	Instant	FK
`user_id`	String	FK
`app_group_id`	String
`app_id`	String
`channel`	String
`email_address`	String
`event_type`	String
`external_user_id`	String
`phone_number`	String
`send_id`	String
`state_change_source`	String
`subscription_group_id`	String
`subscription_status`	String
`time`	Instant
`timezone`	String

sms_event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_message_variation_id`	String	FK
`canvas_step_message_variation_updated_at`	Instant	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`message_variation_id`	String	FK
`message_variation_updated_at`	Instant	FK
`user_id`	String	FK
`abort_log`	String
`abort_type`	String
`action`	String
`app_group_id`	String
`dispatch_id`	String
`error`	String
`event_type`	String
`external_user_id`	String
`from_phone_number`	String
`inbound_phone_number`	String
`is_sms_fallback`	Boolean
`is_suspected_bot_click`	Boolean
`message_body`	String
`message_extras`	Json
`provider_error_code`	String
`short_url`	String
`subscription_group_api_id`	String
`subscription_group_id`	String
`suspected_bot_click_reason`	Json
`time`	Instant
`timezone`	String
`to_phone_number`	String
`url`	String
`user_agent`	String
`user_phone_number`	String

uninstall_event

Column	Type	Keys
`id`	String	PK
`user_id`	String	FK
`app_id`	String
`event_type`	String
`external_user_id`	String
`time`	Instant

canvas_step

Column	Type	Keys
`id`	String	PK
`canvas_id`	String	FK
`canvas_updated_at`	Instant	FK
`channel_android_push`	Boolean
`channel_content_cards`	Boolean
`channel_email`	Boolean
`channel_in_app_message`	Boolean
`channel_ios_push`	Boolean
`channel_sms`	Boolean
`channel_web_push`	Boolean
`channel_webhook`	Boolean
`name`	String

push_notification_event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_message_variation_id`	String	FK
`canvas_step_message_variation_updated_at`	Instant	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`device_id`	String	FK
`message_variation_id`	String	FK
`message_variation_updated_at`	Instant	FK
`user_id`	String	FK
`abort_log`	String
`abort_type`	String
`app_group_id`	String
`app_id`	String
`dispatch_id`	String
`event_type`	String
`external_user_id`	String
`message_extras`	Json
`send_id`	String
`time`	Instant
`timezone`	String

canvas_step_seq

Column	Type	Keys
`canvas_step_seq`	String	PK
`canvas_id`	String	PKFK
`canvas_updated_at`	Instant	FK

campaign

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`archived`	Boolean
`channel_android_push`	Boolean
`channel_content_cards`	Boolean
`channel_email`	Boolean
`channel_in_app_message`	Boolean
`channel_ios_push`	Boolean
`channel_sms`	Boolean
`channel_web_push`	Boolean
`channel_webhook`	Boolean
`created_at`	Instant
`draft`	Boolean
`enabled`	Boolean
`error`	Boolean
`first_sent`	String
`is_api_campaign`	Boolean
`last_sent`	String
`message`	String
`name`	String
`schedule_type`	String

campaign_conversion_event

Column	Type	Keys
`id`	String	PK
`campaign_conversion_behavior_id`	String	FK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`user_id`	String	FK
`app_id`	String
`conversion_behavior_index`	String
`event_type`	String
`external_user_id`	String
`message_variation_id`	String
`message_variation_updated_at`	Instant
`send_id`	String
`time`	Instant
`timezone`	String

canvas_tag

Column	Type	Keys
`canvas_id`	String	PK
`tag`	String	PK
`canvas_updated_at`	Instant	FK

custom_event

Column	Type	Keys
`id`	String	PK
`device_id`	String	FK
`user_id`	String	FK
`app_id`	String
`event_type`	String
`external_user_id`	String
`name`	String
`properties`	String
`time`	Instant
`timezone`	String

user_alias

Column	Type	Keys
`label`	String	PK
`name`	String	PK
`user_id`	String	FK

newsfeed_card_event

Column	Type	Keys
`id`	String	PK
`card_id`	String	FK
`card_updated_at`	Instant	FK
`device_id`	String	FK
`user_id`	String	FK
`abort_log`	String
`abort_type`	String
`app_group_id`	String
`app_id`	String
`browser`	String
`carrier`	String
`event_type`	String
`external_user_id`	String
`resolution`	String
`time`	Instant
`timezone`	String

purchase_event

Column	Type	Keys
`id`	String	PK
`device_id`	String	FK
`user_id`	String	FK
`app_id`	String
`currency`	String
`event_type`	String
`external_user_id`	String
`price`	String
`product_id`	String
`properties`	String
`time`	Instant

user_device

Column	Type	Keys
`index`	Int	PK
`user_id`	String	PKFK
`ad_tracking_enabled`	Boolean
`carrier`	String
`device_id`	String
`google_ad_id`	String
`idfa`	String
`idfv`	String
`model`	String
`os`	String
`roku_ad_id`	String

canvas

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`archived`	Boolean
`channel_android_push`	Boolean
`channel_content_cards`	Boolean
`channel_email`	Boolean
`channel_in_app_message`	Boolean
`channel_ios_push`	Boolean
`channel_sms`	Boolean
`channel_web_push`	Boolean
`channel_webhook`	Boolean
`created_at`	Instant
`draft`	Boolean
`enabled`	Boolean
`error`	Boolean
`first_entry`	Instant
`last_entry`	Instant
`message`	String
`name`	String
`schedule_type`	String

campaign_enrollment_event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`user_id`	String	FK
`event_type`	String
`external_user_id`	String
`message_variation_id`	String
`message_variation_updated_at`	Instant
`send_id`	String
`time`	Instant
`timezone`	String

campaign_tag

Column	Type	Keys
`tag`	String	PK
`campaign_id`	String	PKFK
`campaign_updated_at`	Instant	FK

banner_event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`campaign_updated_at`	Instant	FK
`canvas_id`	String	FK
`canvas_step_id`	String	FK
`canvas_step_updated_at`	Instant	FK
`canvas_updated_at`	Instant	FK
`canvas_variation_id`	String	FK
`device_id`	String	FK
`message_variation_id`	String	FK
`message_variation_updated_at`	Instant	FK
`user_id`	String	FK
`abort_log`	String
`abort_type`	String
`ad_id`	String
`ad_id_type`	String
`ad_tracking_enabled`	Boolean
`app_group_id`	String
`app_id`	String
`banner_placement_id`	String
`browser`	String
`button_id`	String
`carrier`	String
`country`	String
`device_model`	String
`event_type`	String
`external_user_id`	String
`gender`	String
`language`	String
`os_version`	String
`platform`	String
`resolution`	String
`sdk_version`	String
`time`	Instant
`timezone`	String

random_bucket_number_event

Column	Type	Keys
`id`	String	PK
`user_id`	String	FK
`app_group_id`	String
`event_type`	String
`external_user_id`	String
`prev_random_bucket_number`	Int
`random_bucket_number`	Int
`time`	Instant

segment_member

Column	Type	Keys
`segment_id`	String	PKFK
`user_id`	String	PKFK

card

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`archived`	Boolean
`created_at`	Instant
`description`	String
`draft`	Boolean
`end_at`	Instant
`error`	Boolean
`image_url`	String
`message`	String
`name`	String
`publish_at`	String
`title`	String

session_event

Column	Type	Keys
`id`	String	PK
`device_id`	String	FK
`user_id`	String	FK
`app_id`	String
`duration`	String
`event_type`	String
`external_user_id`	String
`session_id`	String
`time`	String
`timezone`	String