Salesforce Marketing Cloud (SFMC) Data Extension schemas for RTDS
Salesforce Marketing Cloud Data Extension schemas for Airship Real-Time Data Streaming events.
See also:
Properties per event
Event properties are listed in a table per event. Name, default value, length, and nullability are listed, as available, for each property.
ATTRIBUTE_OPERATION
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| device_os | | 36 | Yes |
| device_model | | 36 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| app_version | | 36 | Yes |
| carrier | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| locale_variant | | 36 | Yes |
| ua_sdk_version | | 36 | Yes |
| location_enabled | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| delivery_address | | 256 | Yes |
| open_platform_name | | 36 | Yes |
| attribute_action | | 10 | Yes |
| attribute_key | | 255 | Yes |
| attribute_text_value | | 255 | Yes |
| attribute_number_value | | | Yes |
| attribute_date_value | | | Yes |
| attribute_version_value | | 255 | Yes |
| type | | 36 | Yes |
CLOSE
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| session_id | | 36 | Yes |
| type | | 36 | Yes |
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| body_named_user_id | | 128 | Yes |
| change_type | | 36 | Yes |
| channel_id | | 36 | Yes |
| body_contact_id | | 128 | Yes |
| contact_id | | 128 | Yes |
| user_named_user_id | | 128 | Yes |
| type | | 36 | Yes |
CONTROL
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| push_id | | 36 | Yes |
| group_id | | 36 | Yes |
| alerting | FALSE | | Yes |
| type | | 36 | Yes |
| campaigns | | 1000 | Yes |
CUSTOM
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| properties | | 4000 | Yes |
| source | | 11 | Yes |
| name | | 255 | Yes |
| value | | | Yes |
| interaction_type | | 30 | Yes |
| interaction_id | | 255 | Yes |
| customer_id | | 100 | Yes |
| last_delivered_push_id | | 36 | Yes |
| last_delivered_group_id | | 36 | Yes |
| last_delivered_variant_id | | 36 | Yes |
| last_delivered_time | | | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_variant_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| session_id | | 36 | Yes |
| type | | 36 | Yes |
| last_delivered_campaigns | | 1000 | Yes |
FIRST_OPEN
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| type | | 36 | Yes |
FIRST_OPT_IN
| Name | Default Value | Length | Nullable |
|---|
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| type | | 36 | Yes |
| channel | | 36 | Yes |
| delivery_address | | 256 | Yes |
| device_type | | 24 | Yes |
| named_user_id | | 128 | Yes |
| open_platform_name | | 36 | Yes |
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| app_defined_id | | 36 | Yes |
| reporting_context | | 256 | Yes |
| context_state_form_form_identifier | | 36 | Yes |
| context_state_form_response_type | | 255 | Yes |
| context_state_form_submitted | | | Yes |
| context_state_form_type | | 255 | Yes |
| context_state_pager_completed | | | Yes |
| context_state_pager_identifier | | 36 | Yes |
| context_state_pager_page_count | | | Yes |
| context_state_pager_page_identifier | | 36 | Yes |
| context_state_pager_page_index | | | Yes |
| button_id | | 100 | Yes |
| group_id | | 36 | Yes |
| rendered_locale | | 36 | Yes |
| push_id | | 36 | Yes |
| session_id | | 36 | Yes |
| time_sent | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_variant_id | | 36 | Yes |
| type | | 36 | Yes |
IN_APP_EXPERIENCES
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| app_defined_id | | 36 | Yes |
| campaigns | | 256 | Yes |
| event_name | | 255 | Yes |
| group_id | | 36 | Yes |
| push_id | | 36 | Yes |
| session_id | | 36 | Yes |
| survey_type | | 255 | Yes |
| time_sent | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_variant_id | | 36 | Yes |
| variant_id | | 32 | Yes |
| type | | 36 | Yes |
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| app_defined_id | | 36 | Yes |
| reporting_context | | 256 | Yes |
| context_state_form_form_identifier | | 36 | Yes |
| context_state_form_response_type | | 255 | Yes |
| context_state_form_submitted | | | Yes |
| context_state_form_type | | 255 | Yes |
| context_state_pager_completed | | | Yes |
| context_state_pager_identifier | | 36 | Yes |
| context_state_pager_page_count | | | Yes |
| context_state_pager_page_identifier | | 36 | Yes |
| context_state_pager_page_index | | | Yes |
| forms | | 4000 | Yes |
| group_id | | 36 | Yes |
| push_id | | 36 | Yes |
| session_id | | 36 | Yes |
| time_sent | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_variant_id | | 36 | Yes |
| in_app_form_event_type | | 255 | Yes |
| type | | 36 | Yes |
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| app_defined_id | | 36 | Yes |
| reporting_context | | 256 | Yes |
| context_state_form_form_identifier | | 36 | Yes |
| context_state_form_response_type | | 255 | Yes |
| context_state_form_submitted | | | Yes |
| context_state_form_type | | 255 | Yes |
| context_state_pager_completed | | | Yes |
| context_state_pager_identifier | | 36 | Yes |
| context_state_pager_page_count | | | Yes |
| context_state_pager_page_identifier | | 36 | Yes |
| context_state_pager_page_index | | | Yes |
| forms | | 4000 | Yes |
| group_id | | 36 | Yes |
| push_id | | 36 | Yes |
| session_id | | 36 | Yes |
| time_sent | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_variant_id | | 36 | Yes |
| in_app_form_event_type | | 255 | Yes |
| type | | 36 | Yes |
IN_APP_MESSAGE_DISPLAY
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| push_id | | 36 | Yes |
| group_id | | 36 | Yes |
| app_defined_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_variant_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| session_id | | 36 | Yes |
| variant_id | | 32 | Yes |
| campaigns | | 256 | Yes |
| time | | | Yes |
| type | | 36 | Yes |
IN_APP_MESSAGE_EXPIRATION
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| push_id | | 36 | Yes |
| group_id | | 36 | Yes |
| app_defined_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_variant_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| replacing_push_push_id | | 36 | Yes |
| replacing_push_group_id | | 36 | Yes |
| replacing_push_variant_id | | 36 | Yes |
| replacing_push_campaigns | | 256 | Yes |
| time_sent | | | Yes |
| time_expired | | | Yes |
| expiration_type | | 20 | Yes |
| session_id | | 36 | Yes |
| variant_id | | 32 | Yes |
| time | | | Yes |
| type | | 36 | Yes |
IN_APP_MESSAGE_RESOLUTION
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| push_id | | 36 | Yes |
| group_id | | 36 | Yes |
| session_id | | 36 | Yes |
| variant_id | | 32 | Yes |
| app_defined_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_variant_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| campaigns | | 256 | Yes |
| time | | | Yes |
| duration | | 32 | Yes |
| button_id | | 100 | Yes |
| button_group | | 100 | Yes |
| button_description | | 100 | Yes |
| resolution_type | | 14 | Yes |
| type | | 36 | Yes |
IN_APP_PAGE_SWIPE
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| app_defined_id | | 36 | Yes |
| reporting_context | | 256 | Yes |
| context_state_form_form_identifier | | 36 | Yes |
| context_state_form_response_type | | 255 | Yes |
| context_state_form_submitted | | | Yes |
| context_state_form_type | | 255 | Yes |
| context_state_pager_completed | | | Yes |
| context_state_pager_identifier | | 36 | Yes |
| context_state_pager_page_count | | | Yes |
| context_state_pager_page_identifier | | 36 | Yes |
| context_state_pager_page_index | | | Yes |
| from_page_index | | | Yes |
| from_page_identifier | | 36 | Yes |
| group_id | | 36 | Yes |
| rendered_locale | | 36 | Yes |
| pager_identifier | | 36 | Yes |
| push_id | | 36 | Yes |
| session_id | | 36 | Yes |
| time_sent | | | Yes |
| to_page_identifier | | 36 | Yes |
| to_page_index | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_variant_id | | 36 | Yes |
| type | | 36 | Yes |
IN_APP_PAGE_VIEW
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| app_defined_id | | 36 | Yes |
| reporting_context | | 256 | Yes |
| context_state_form_form_identifier | | 36 | Yes |
| context_state_form_response_type | | 255 | Yes |
| context_state_form_submitted | | | Yes |
| context_state_form_type | | 255 | Yes |
| context_state_pager_completed | | | Yes |
| context_state_pager_identifier | | 36 | Yes |
| context_state_pager_page_count | | | Yes |
| context_state_pager_page_identifier | | 36 | Yes |
| context_state_pager_page_index | | | Yes |
| commercial_opted_in | | | Yes |
| group_id | | 36 | Yes |
| rendered_locale | | 36 | Yes |
| page_count | | | Yes |
| page_identifier | | 36 | Yes |
| page_index | | | Yes |
| pager_identifier | | 36 | Yes |
| push_id | | 36 | Yes |
| session_id | | 36 | Yes |
| time_sent | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_variant_id | | 36 | Yes |
| viewed_count | | | Yes |
| type | | 36 | Yes |
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| app_defined_id | | 36 | Yes |
| reporting_context | | 256 | Yes |
| context_state_form_form_identifier | | 36 | Yes |
| context_state_form_response_type | | 255 | Yes |
| context_state_form_submitted | | | Yes |
| context_state_form_type | | 255 | Yes |
| context_state_pager_completed | | | Yes |
| context_state_pager_identifier | | 36 | Yes |
| context_state_pager_page_count | | | Yes |
| context_state_pager_page_identifier | | 36 | Yes |
| context_state_pager_page_index | | | Yes |
| group_id | | 36 | Yes |
| rendered_locale | | 36 | Yes |
| page_count | | | Yes |
| page_identifier | | 36 | Yes |
| page_index | | | Yes |
| pager_identifier | | 36 | Yes |
| push_id | | 36 | Yes |
| session_id | | 36 | Yes |
| time_sent | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_variant_id | | 36 | Yes |
| type | | 36 | Yes |
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| app_defined_id | | 36 | Yes |
| reporting_context | | 256 | Yes |
| context_state_form_form_identifier | | 36 | Yes |
| context_state_form_response_type | | 255 | Yes |
| context_state_form_submitted | | | Yes |
| context_state_form_type | | 255 | Yes |
| context_state_pager_completed | | | Yes |
| context_state_pager_identifier | | 36 | Yes |
| context_state_pager_page_count | | | Yes |
| context_state_pager_page_identifier | | 36 | Yes |
| context_state_pager_page_index | | | Yes |
| commercial_opted_in | | | Yes |
| group_id | | 36 | Yes |
| rendered_locale | | 36 | Yes |
| page_count | | | Yes |
| page_identifier | | 36 | Yes |
| pager_identifier | | 36 | Yes |
| push_id | | 36 | Yes |
| session_id | | 36 | Yes |
| time_sent | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_variant_id | | 36 | Yes |
| viewed_pages | | 4000 | Yes |
| type | | 36 | Yes |
LOCATION
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| latitude | | | Yes |
| longitude | | | Yes |
| foreground | | | Yes |
| session_id | | 36 | Yes |
| type | | 36 | Yes |
MOBILE_ORIGINATED
| Name | Default Value | Length | Nullable |
|---|
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| type | | 36 | Yes |
| event_type | | 36 | Yes |
| msisdn | | 20 | Yes |
| sender | | 20 | Yes |
| inbound_message | | 255 | Yes |
| outbound_message | | | Yes |
| keyword | | 36 | Yes |
| channel | | 36 | Yes |
| delivery_address | | 256 | Yes |
| device_type | | 24 | Yes |
| body_identifiers_sender | | 36 | Yes |
| device_identifiers_sender | | 36 | |
OPEN
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| last_delivered_push_id | | 36 | Yes |
| last_delivered_group_id | | 36 | Yes |
| last_delivered_variant_id | | 36 | Yes |
| last_delivered_time | | | Yes |
| last_delivered_campaigns | | 256 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_variant_id | | 36 | Yes |
| triggering_push_time | | | Yes |
| triggering_push_campaigns | | 256 | Yes |
| session_id | | 36 | Yes |
| type | | 36 | Yes |
PUSH_BODY
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| type | | 36 | Yes |
| push_id | | 36 | Yes |
| payload | | 4000 | Yes |
| trimmed | FALSE | | Yes |
| resource | | 11 | Yes |
| campaigns | | 256 | Yes |
REGION
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| session_id | | 36 | Yes |
| action | | 5 | Yes |
| name | | 255 | Yes |
| region_id | | 36 | Yes |
| source_info_source | | 36 | Yes |
| source_info_region_id | | 36 | Yes |
| type | | 36 | Yes |
| | | |
RICH_DELETE
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| push_id | | 36 | Yes |
| group_id | | 36 | Yes |
| variant_id | | 32 | Yes |
| campaigns | | 256 | Yes |
| time | | | Yes |
| type | | 36 | Yes |
RICH_DELIVERY
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| push_id | | 36 | Yes |
| group_id | | 36 | Yes |
| variant_id | | 32 | Yes |
| campaigns | | 256 | Yes |
| time | | | Yes |
| type | | 36 | Yes |
RICH_READ
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| push_id | | 36 | Yes |
| group_id | | 36 | Yes |
| variant_id | | 32 | Yes |
| campaigns | | 256 | Yes |
| time | | | Yes |
| type | | 36 | Yes |
SCREEN_VIEWED
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| viewed_screen | | 255 | Yes |
| previous_screen | | 255 | Yes |
| duration | | 32 | Yes |
| session_id | | 36 | Yes |
| type | | 36 | Yes |
SEND
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| push_id | | 36 | Yes |
| group_id | | 36 | Yes |
| alerting | FALSE | | Yes |
| type | | 36 | Yes |
| campaigns | | 1000 | Yes |
| context_event_uuid | | 36 | Yes |
| context_interaction_id | | 255 | Yes |
| context_transaction | | 255 | Yes |
| context_triggered_by | | 255 | Yes |
SEND_ABORTED
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| campaigns | | 256 | Yes |
| group_id | | 36 | Yes |
| push_id | | 36 | Yes |
| reason | | 255 | Yes |
| type | | 36 | Yes |
SEND_REJECTED
| Name | Default Value | Length | Nullable |
|---|
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| type | | 36 | Yes |
| campaigns | | 256 | Yes |
| group_id | | 36 | Yes |
| push_id | | 36 | Yes |
| variant_id | | 32 | Yes |
| channel | | 36 | Yes |
| app_version | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| carrier | | 36 | Yes |
| connection_type | | 20 | Yes |
| device_model | | 36 | Yes |
| device_os | | 36 | Yes |
| iana_timezone | | 36 | Yes |
| locale_country_code | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| locale_timezone | | 36 | Yes |
| locale_variant | | 36 | Yes |
| location_enabled | | 36 | Yes |
| location_permission | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| device_type | | 24 | Yes |
| named_user_id | | 128 | Yes |
| status | | 36 | Yes |
SHORT_LINK_CLICK
| Name | Default Value | Length | Nullable |
|---|
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| type | | 36 | Yes |
| campaigns | | 256 | Yes |
| group_id | | 36 | Yes |
| original_url | | | Yes |
| push_id | | 36 | Yes |
| web_user_agent_string | | 256 | Yes |
| channel | | 36 | Yes |
| delivery_address | | 256 | Yes |
| device_type | | 24 | Yes |
| device_identifiers_sender | | 36 | Yes |
SUBSCRIPTION
| Name | Default Value | Length | Nullable |
|---|
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| type | | 36 | Yes |
| event_type | | 36 | Yes |
| address | | 256 | Yes |
| channel | | 36 | Yes |
| delivery_address | | 256 | Yes |
| device_type | | 24 | Yes |
| named_user | | 128 | Yes |
SUBSCRIPTION_LIST
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| type | | 36 | Yes |
| channel | | 36 | Yes |
| delivery_address | | 256 | Yes |
| device_type | | 24 | Yes |
| named_user_id | | 128 | Yes |
| enrolled | | 256 | Yes |
| canceled | | 256 | Yes |
| scope | | 20 | Yes |
TAG_ACTION
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| open_platform_name | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| tag_action | | 255 | Yes |
| tag_class | | 255 | Yes |
| tag_name | 123567 | 255 | Yes |
| type | | 36 | Yes |
TAG_CHANGE
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| decay | | | Yes |
| type | | 36 | Yes |
UNINSTALL
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| device_type | | 24 | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| locale_variant | | 36 | Yes |
| app_version | | 36 | Yes |
| device_model | | 36 | Yes |
| connection_type | | 20 | Yes |
| iana_timezone | | 36 | Yes |
| push_opt_in | FALSE | | Yes |
| locale_country_code | | 36 | Yes |
| device_os | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| location_enabled | | 36 | Yes |
| background_push_enabled | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| location_permission | | 36 | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| decay | | | Yes |
| type | | 36 | Yes |
WEB_CLICK
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| device_type | | 24 | Yes |
| push_opt_in | FALSE | | Yes |
| web_browser_type | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_user_agent_string | | 256 | Yes |
| ua_sdk_version | | 36 | Yes |
| push_id | | 36 | Yes |
| group_id | | 36 | Yes |
| type | | 36 | Yes |
WEB_SESSION
| Name | Default Value | Length | Nullable |
|---|
| app_key | | 22 | Yes |
| id | | 36 | No |
| offset | | 32 | No |
| occurred | Current date | | Yes |
| channel | | 36 | Yes |
| named_user_id | | 128 | Yes |
| device_type | | 24 | Yes |
| connection_type | | 20 | Yes |
| device_model | | 36 | Yes |
| locale_language_code | | 20 | Yes |
| background_push_enabled | FALSE | | Yes |
| push_opt_in | FALSE | | Yes |
| ua_sdk_version | | 36 | Yes |
| locale_timezone | | 36 | Yes |
| iana_timezone | | 36 | Yes |
| carrier | | 36 | Yes |
| locale_country_code | | 36 | Yes |
| location_permission | | 36 | Yes |
| location_enabled | | 36 | Yes |
| device_os | | 36 | Yes |
| app_version | | 36 | Yes |
| locale_variant | | 36 | Yes |
| web_browser_version | | 20 | Yes |
| web_browser_name | | 20 | Yes |
| web_browser_type | | 36 | Yes |
| web_user_agent_string | | 256 | Yes |
| last_delivered_push_id | | 36 | Yes |
| last_delivered_group_id | | 36 | Yes |
| last_delivered_variant_id | | 36 | Yes |
| last_delivered_time | | | Yes |
| last_delivered_campaigns | | 256 | Yes |
| session_id | | 36 | Yes |
| type | | 36 | Yes |
| triggering_push_push_id | | 36 | Yes |
| triggering_push_group_id | | 36 | Yes |
| triggering_push_variant_id | | 36 | Yes |
| triggering_push_time | | 36 | Yes |
| triggering_push_campaigns | | 256 | Yes |
