# Adjust schema ERD

Table and field reference for the Fivetran Adjust connector.

## Table & Field Reference

### sk_qualifier

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| adgroup_name | String |  |
| campaign_name | String |  |
| country | String |  |
| created_at | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| ip_address | String |  |
| network_name | String |  |
| os_name | String |  |
| os_version | String |  |
| partner | String |  |
| reftag | String |  |
| sk_app_id | Long |  |
| sk_attribution_signature | String |  |
| sk_campaign_id | Long |  |
| sk_conversion_value | Int |  |
| sk_did_win | Boolean |  |
| sk_fidelity_type | Int |  |
| sk_invalid_signature | Int |  |
| sk_network_id | String |  |
| sk_payload | String |  |
| sk_redownload | Int |  |
| sk_source_app_id | Long |  |
| sk_transaction_id | String |  |
| sk_ts | Instant |  |
| sk_version | Double |  |
| tracker | String |  |
| user_agent | String |  |

### sk_event

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| adgroup_name | String |  |
| campaign_name | String |  |
| count_max | Long |  |
| count_min | Long |  |
| country | String |  |
| created_at | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| event | String |  |
| event_name | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| ip_address | String |  |
| network_name | String |  |
| os_name | String |  |
| os_version | String |  |
| partner | String |  |
| reftag | String |  |
| reporting_currency | String |  |
| reporting_revenue_max | Double |  |
| reporting_revenue_min | Double |  |
| sk_app_id | Long |  |
| sk_attribution_signature | String |  |
| sk_campaign_id | Long |  |
| sk_conversion_value | Int |  |
| sk_did_win | Boolean |  |
| sk_fidelity_type | Int |  |
| sk_invalid_signature | Int |  |
| sk_network_id | String |  |
| sk_payload | String |  |
| sk_redownload | Int |  |
| sk_source_app_id | Long |  |
| sk_transaction_id | String |  |
| sk_ts | Instant |  |
| sk_version | Double |  |
| tracker | String |  |
| user_agent | String |  |

### click

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| android_id | String |  |
| android_id_md_5 | String |  |
| app_id | String |  |
| city | String |  |
| click_attribution_window | Int |  |
| click_referer | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| cost_amount | BigDecimal |  |
| cost_currency | String |  |
| cost_id_md_5 | String |  |
| cost_type | String |  |
| country | String |  |
| country_subdivision | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| fingerprint_attribution_window | Int |  |
| fire_adid | String |  |
| gclid | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| inactive_user_definition | Int |  |
| ip_address | String |  |
| is_reattributed | Int |  |
| is_s_2_s | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| reattribution_attribution_window | Int |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| reporting_cost | BigDecimal |  |
| store | String |  |
| tracker | String |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |

### reinstall

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| android_id | String |  |
| android_id_md_5 | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| att_status | Int |  |
| city | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| country | String |  |
| country_subdivision | String |  |
| cpu_type | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| fire_adid | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| hardware_name | String |  |
| iad_conversion_type | String |  |
| iad_creative_set_id | String |  |
| iad_creative_set_name | String |  |
| iad_keyword_matchtype | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| install_begin_time | Long |  |
| install_finish_time | Long |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_time_spent | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| network_type | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| partner_parameters | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| publisher_parameters | String |  |
| push_token | String |  |
| random | Long |  |
| random_user_id | String |  |
| reattributed_at | Long |  |
| reattributed_at_hour | Long |  |
| referral_time | Long |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| reinstalled_at | Long |  |
| sdk_version | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| time_to_reinstall | Long |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| uninstalled_at | Long |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |
| win_hwid | String |  |
| win_naid | String |  |
| win_udid | String |  |

### att_status_update_ios

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| att_status | Int |  |
| city | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| country | String |  |
| country_subdivision | String |  |
| cpu_type | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| hardware_name | String |  |
| iad_conversion_type | String |  |
| iad_creative_set_id | String |  |
| iad_creative_set_name | String |  |
| iad_keyword_matchtype | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| network_type | String |  |
| os_name | String |  |
| os_version | String |  |
| partner_parameters | String |  |
| platform | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| publisher_parameters | String |  |
| push_token | String |  |
| random_user_id | String |  |
| reattributed_at | Long |  |
| reattributed_at_hour | Long |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| sdk_version | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| user_agent | String |  |

### install_update

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| adgroup_name | String |  |
| adid | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| app_name_dashboard | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| attribution_updated_at | Long |  |
| campaign_name | String |  |
| city | String |  |
| click_attribution_window | Int |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| country | String |  |
| country_subdivision | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| impression_based | Int |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| is_s_2_s_engagement_based | Int |  |
| isp | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| network_name | String |  |
| os_name | String |  |
| os_version | String |  |
| outdated_tracker | String |  |
| postal_code | String |  |
| random_user_id | String |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| sdk_version | String |  |
| session_count | Long |  |
| store | String |  |
| timezone | String |  |
| tracker | String |  |
| tracker_name | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| user_agent | String |  |

### update

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| android_id | String |  |
| android_id_md_5 | String |  |
| app_id | String |  |
| app_name | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| att_status | Int |  |
| attribution_updated_at | Long |  |
| city | String |  |
| click_attribution_window | Int |  |
| click_referer | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| country | String |  |
| country_subdivision | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| fire_adid | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| iad_conversion_type | String |  |
| iad_creative_set_id | String |  |
| iad_creative_set_name | String |  |
| iad_keyword_matchtype | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_attribution_window | Int |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| inactive_user_definition | Int |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| is_s_2_s_engagement_based | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| outdated_tracker | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| push_token | String |  |
| random | Long |  |
| random_user_id | String |  |
| reattributed_at | Long |  |
| reattributed_at_hour | Long |  |
| reattribution_attribution_window | Int |  |
| reftag | String |  |
| region | String |  |
| reinstalled_at | Long |  |
| rejection_reason | String |  |
| sdk_version | String |  |
| search_term | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| uninstalled_at | Long |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |
| win_hwid | String |  |
| win_naid | String |  |
| win_udid | String |  |

### impression

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| android_id | String |  |
| android_id_md_5 | String |  |
| app_id | String |  |
| city | String |  |
| connection_type | String |  |
| cost_amount | BigDecimal |  |
| cost_currency | String |  |
| cost_id_md_5 | String |  |
| cost_type | String |  |
| country | String |  |
| country_subdivision | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| fire_adid | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| impression_attribution_window | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| ip_address | String |  |
| is_reattributed | Int |  |
| is_s_2_s | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| reporting_cost | BigDecimal |  |
| store | String |  |
| tracker | String |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |

### san_impression

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| android_id | String |  |
| android_id_md_5 | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| att_status | Int |  |
| city | String |  |
| click_attribution_window | Int |  |
| connection_type | String |  |
| cost_amount | BigDecimal |  |
| cost_currency | String |  |
| cost_id_md_5 | String |  |
| cost_type | String |  |
| country | String |  |
| country_subdivision | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| fingerprint_attribution_window | Int |  |
| fire_adid | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_attribution_window | Int |  |
| inactive_user_definition | Int |  |
| ip_address | String |  |
| is_reattributed | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| partner_parameters | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| push_token | String |  |
| random | Long |  |
| random_user_id | String |  |
| reattribution_attribution_window | Int |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| reporting_cost | BigDecimal |  |
| sdk_version | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |
| win_hwid | String |  |
| win_naid | String |  |
| win_udid | String |  |

### erased_user_gdpr

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| android_id | String |  |
| android_id_md_5 | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| city | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| country | String |  |
| country_subdivision | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| currency | String |  |
| deeplink | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| event | String |  |
| event_name | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| fire_adid | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| partner_parameters | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| publisher_parameters | String |  |
| push_token | String |  |
| random | Long |  |
| random_user_id | String |  |
| reattributed_at | Long |  |
| reattributed_at_hour | Long |  |
| reftag | String |  |
| region | String |  |
| reinstalled_at | Long |  |
| reporting_currency | String |  |
| reporting_revenue | BigDecimal |  |
| revenue | Float |  |
| revenue_float | BigDecimal |  |
| revenue_usd | BigDecimal |  |
| revenue_usd_cents | Int |  |
| sdk_version | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| time_spent | Long |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| uninstalled_at | Long |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |
| win_hwid | String |  |
| win_naid | String |  |
| win_udid | String |  |

### sk_install

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| adgroup_name | String |  |
| campaign_name | String |  |
| country | String |  |
| created_at | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| ip_address | String |  |
| network_name | String |  |
| os_name | String |  |
| os_version | String |  |
| partner | String |  |
| reftag | String |  |
| sk_app_id | Long |  |
| sk_attribution_signature | String |  |
| sk_campaign_id | Long |  |
| sk_conversion_value | Int |  |
| sk_did_win | Boolean |  |
| sk_fidelity_type | Int |  |
| sk_invalid_signature | Int |  |
| sk_network_id | String |  |
| sk_payload | String |  |
| sk_redownload | Int |  |
| sk_source_app_id | Long |  |
| sk_transaction_id | String |  |
| sk_ts | Instant |  |
| sk_version | Double |  |
| tracker | String |  |
| user_agent | String |  |

### tracker

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| adgroup_name | String |  |
| app_name_dashboard | String |  |
| campaign_name | String |  |
| creative_name | String |  |
| network_name | String |  |
| tracker_name | String |  |

### install

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| android_id | String |  |
| android_id_md_5 | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| att_status | Int |  |
| city | String |  |
| click_attribution_window | Int |  |
| click_referer | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| cost_amount | BigDecimal |  |
| cost_currency | String |  |
| cost_id_md_5 | String |  |
| cost_type | String |  |
| country | String |  |
| country_subdivision | String |  |
| cpu_type | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| fingerprint_attribution_window | Int |  |
| fire_adid | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| hardware_name | String |  |
| iad_conversion_type | String |  |
| iad_creative_set_id | String |  |
| iad_creative_set_name | String |  |
| iad_keyword_matchtype | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_attribution_window | Int |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| install_begin_time | Long |  |
| install_finish_time | Long |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| is_s_2_s_engagement_based | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| network_type | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| partner_parameters | String |  |
| platform | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| publisher_parameters | String |  |
| push_token | String |  |
| random_user_id | String |  |
| referral_time | Long |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| rejection_reason | String |  |
| reporting_cost | BigDecimal |  |
| sdk_version | String |  |
| search_term | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |
| win_hwid | String |  |
| win_naid | String |  |
| win_udid | String |  |

### ad_revenue

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| ad_impressions_count | Long |  |
| ad_mediation_platform | String |  |
| ad_revenue_network | String |  |
| ad_revenue_payload | String |  |
| ad_revenue_placement | String |  |
| ad_revenue_unit | String |  |
| adid | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| conversion_duration | Long |  |
| country | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| currency | String |  |
| deeplink | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| gps_adid_md_5 | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| is_organic | Int |  |
| label | String |  |
| language | String |  |
| match_type | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| push_token | String |  |
| random_user_id | String |  |
| reftag | String |  |
| reporting_revenue | BigDecimal |  |
| revenue | Float |  |
| revenue_float | BigDecimal |  |
| revenue_usd | BigDecimal |  |
| revenue_usd_cents | Int |  |
| third_party_sharing_disabled | Int |  |
| timezone | String |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| user_agent | String |  |
| web_uuid | String |  |

### session

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| android_id | String |  |
| android_id_md_5 | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| att_status | Int |  |
| city | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| country | String |  |
| country_subdivision | String |  |
| cpu_type | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| fire_adid | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| hardware_name | String |  |
| iad_conversion_type | String |  |
| iad_creative_set_id | String |  |
| iad_creative_set_name | String |  |
| iad_keyword_matchtype | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_time_spent | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| network_type | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| partner_parameters | String |  |
| platform | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| publisher_parameters | String |  |
| push_token | String |  |
| random_user_id | String |  |
| reattributed_at | Long |  |
| reattributed_at_hour | Long |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| reinstalled_at | Long |  |
| rejection_reason | String |  |
| sdk_version | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| uninstalled_at | Long |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |
| win_hwid | String |  |
| win_naid | String |  |
| win_udid | String |  |

### san_click

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| android_id | String |  |
| android_id_md_5 | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| att_status | Int |  |
| city | String |  |
| click_attribution_window | Int |  |
| connection_type | String |  |
| cost_amount | BigDecimal |  |
| cost_currency | String |  |
| cost_id_md_5 | String |  |
| cost_type | String |  |
| country | String |  |
| country_subdivision | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| fingerprint_attribution_window | Int |  |
| fire_adid | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_attribution_window | Int |  |
| inactive_user_definition | Int |  |
| ip_address | String |  |
| is_reattributed | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| partner_parameters | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| push_token | String |  |
| random | Long |  |
| random_user_id | String |  |
| reattribution_attribution_window | Int |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| reporting_cost | BigDecimal |  |
| sdk_version | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |
| win_hwid | String |  |
| win_naid | String |  |
| win_udid | String |  |

### reattribution_update

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| random | String | PK |
| tracker_id | String | FK |
| adgroup_name | String |  |
| adid | String |  |
| adwords_campaign_id | String |  |
| adwords_campaign_name | String |  |
| adwords_campaign_type | String |  |
| adwords_network_subtype | String |  |
| adwords_network_type | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| app_name_dashboard | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| attribution_updated_at | Long |  |
| campaign_name | String |  |
| city | String |  |
| click_attribution_window | Int |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| country | String |  |
| country_subdivision | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| impression_based | Int |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | String |  |
| is_reattributed | Int |  |
| is_s_2_s_engagement_based | Int |  |
| isp | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| network_name | String |  |
| os_name | String |  |
| os_version | String |  |
| outdated_tracker | String |  |
| partner_parameters | String |  |
| postal_code | String |  |
| publisher_parameters | String |  |
| random_user_id | String |  |
| reattributed_at | Long |  |
| reattributed_at_hour | Long |  |
| reftag | String |  |
| region | String |  |
| sdk_version | String |  |
| session_count | Long |  |
| store | String |  |
| timezone | String |  |
| tracker | String |  |
| tracker_name | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| user_agent | String |  |

### reattribution

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| android_id | String |  |
| android_id_md_5 | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| att_status | Int |  |
| city | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| country | String |  |
| country_subdivision | String |  |
| cpu_type | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| fire_adid | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| hardware_name | String |  |
| iad_conversion_type | String |  |
| iad_creative_set_id | String |  |
| iad_creative_set_name | String |  |
| iad_keyword_matchtype | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| inactive_user_definition | Int |  |
| install_begin_time | Long |  |
| install_finish_time | Long |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| is_s_2_s_engagement_based | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| network_type | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| partner_parameters | String |  |
| platform | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| publisher_parameters | String |  |
| push_token | String |  |
| random | Long |  |
| random_user_id | String |  |
| reattributed_at | Long |  |
| reattributed_at_hour | Long |  |
| reattribution_attribution_window | Int |  |
| referral_time | Long |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| reinstalled_at | Long |  |
| rejection_reason | String |  |
| sdk_version | String |  |
| search_term | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| uninstalled_at | Long |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |
| win_hwid | String |  |
| win_naid | String |  |
| win_udid | String |  |

### uninstall

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| app_id | String |  |
| app_name | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| conversion_duration | Long |  |
| country | String |  |
| created_at | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| iad_conversion_type | String |  |
| iad_creative_set_id | String |  |
| iad_creative_set_name | String |  |
| iad_keyword_matchtype | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| label | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| push_token | String |  |
| random | Long |  |
| random_user_id | String |  |
| reattributed_at | Long |  |
| reattributed_at_hour | Long |  |
| reftag | String |  |
| reinstalled_at | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| time_to_uninstall | Long |  |
| tracker | String |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| uninstalled_at | Long |  |
| user_agent | String |  |
| web_uuid | String |  |

### reattribution_reinstall

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| android_id | String |  |
| android_id_md_5 | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| att_status | Int |  |
| city | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| country | String |  |
| country_subdivision | String |  |
| cpu_type | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| deeplink | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| fire_adid | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| hardware_name | String |  |
| iad_conversion_type | String |  |
| iad_creative_set_id | String |  |
| iad_creative_set_name | String |  |
| iad_keyword_matchtype | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| inactive_user_definition | Int |  |
| install_begin_time | Long |  |
| install_finish_time | Long |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| network_type | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| partner_parameters | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| publisher_parameters | String |  |
| push_token | String |  |
| random | Long |  |
| random_user_id | String |  |
| reattributed_at | Long |  |
| reattributed_at_hour | Long |  |
| reattribution_attribution_window | Int |  |
| referral_time | Long |  |
| referrer | String |  |
| reftag | String |  |
| region | String |  |
| reinstalled_at | Long |  |
| rejection_reason | String |  |
| sdk_version | String |  |
| search_term | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| time_to_reinstall | Long |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| uninstalled_at | Long |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |
| win_hwid | String |  |
| win_naid | String |  |
| win_udid | String |  |

### in_app_event

| Column | Type | Keys |
| --- | --- | --- |
| nonce | String | PK |
| tracker_id | String | FK |
| adid | String |  |
| android_id | String |  |
| android_id_md_5 | String |  |
| api_level | String |  |
| app_id | String |  |
| app_name | String |  |
| app_version | String |  |
| app_version_raw | String |  |
| app_version_short | String |  |
| att_status | Int |  |
| city | String |  |
| click_time | Long |  |
| click_time_hour | Long |  |
| connection_type | String |  |
| conversion_duration | Long |  |
| country | String |  |
| country_subdivision | String |  |
| cpu_type | String |  |
| created_at | Long |  |
| created_at_hour | Long |  |
| created_at_milli | Long |  |
| creative_name | String |  |
| currency | String |  |
| deeplink | String |  |
| device_manufacturer | String |  |
| device_name | String |  |
| device_type | String |  |
| engagement_time | Long |  |
| engagement_time_hour | Long |  |
| environment | String |  |
| event | String |  |
| event_name | String |  |
| fb_account_id | String |  |
| fb_ad_objective_name | String |  |
| fb_adgroup_id | String |  |
| fb_adgroup_name | String |  |
| fb_campaign_group_id | String |  |
| fb_campaign_group_name | String |  |
| fb_campaign_id | String |  |
| fb_campaign_name | String |  |
| fb_platform_position | String |  |
| fire_adid | String |  |
| first_tracker | String |  |
| first_tracker_name | String |  |
| gclid | String |  |
| google_ads_adgroup_id | String |  |
| google_ads_campaign_id | String |  |
| google_ads_campaign_name | String |  |
| google_ads_campaign_type | String |  |
| google_ads_creative_id | String |  |
| google_ads_keyword | String |  |
| google_ads_matchtype | String |  |
| google_ads_network_subtype | String |  |
| google_ads_network_type | String |  |
| google_ads_placement | String |  |
| google_ads_video_id | String |  |
| gps_adid | String |  |
| gps_adid_md_5 | String |  |
| hardware_name | String |  |
| iad_conversion_type | String |  |
| iad_creative_set_id | String |  |
| iad_creative_set_name | String |  |
| iad_keyword_matchtype | String |  |
| idfa | String |  |
| idfa_md_5 | String |  |
| idfa_md_5_hex | String |  |
| idfa_or_android_id | String |  |
| idfa_or_gps_adid | String |  |
| idfa_or_gps_adid_or_fire_adid | String |  |
| idfa_upper | String |  |
| idfv | String |  |
| impression_based | Int |  |
| impression_time | Long |  |
| impression_time_hour | Long |  |
| installed_at | Long |  |
| installed_at_hour | Long |  |
| ip_address | String |  |
| is_organic | Int |  |
| is_reattributed | Int |  |
| is_s_2_s | Int |  |
| isp | String |  |
| label | String |  |
| language | String |  |
| last_session_time | Long |  |
| last_tracker | String |  |
| last_tracker_name | String |  |
| lifetime_session_count | Long |  |
| mac_md_5 | String |  |
| mac_sha_1 | String |  |
| match_type | String |  |
| mcc | String |  |
| mnc | String |  |
| network_type | String |  |
| oaid | String |  |
| oaid_md_5 | String |  |
| os_name | String |  |
| os_version | String |  |
| partner_parameters | String |  |
| platform | String |  |
| postal_code | String |  |
| proxy_ip_address | String |  |
| publisher_parameters | String |  |
| push_token | String |  |
| random | Long |  |
| random_user_id | String |  |
| reattributed_at | Long |  |
| reattributed_at_hour | Long |  |
| reftag | String |  |
| region | String |  |
| reinstalled_at | Long |  |
| reporting_currency | String |  |
| reporting_revenue | BigDecimal |  |
| revenue | Float |  |
| revenue_float | BigDecimal |  |
| revenue_usd | BigDecimal |  |
| revenue_usd_cents | Int |  |
| sdk_version | String |  |
| session_count | Long |  |
| store | String |  |
| third_party_sharing_disabled | Int |  |
| time_spent | Long |  |
| timezone | String |  |
| tracker | String |  |
| tracking_enabled | Int |  |
| tracking_limited | Int |  |
| tweet_id | String |  |
| twitter_line_item_id | String |  |
| uninstalled_at | Long |  |
| user_agent | String |  |
| web_uuid | String |  |
| win_adid | String |  |
| win_hwid | String |  |
| win_naid | String |  |
| win_udid | String |  |

## Relationships

- sk_qualifier(tracker_id) → tracker(_fivetran_id)
- sk_event(tracker_id) → tracker(_fivetran_id)
- click(tracker_id) → tracker(_fivetran_id)
- reinstall(tracker_id) → tracker(_fivetran_id)
- att_status_update_ios(tracker_id) → tracker(_fivetran_id)
- install_update(tracker_id) → tracker(_fivetran_id)
- update(tracker_id) → tracker(_fivetran_id)
- impression(tracker_id) → tracker(_fivetran_id)
- san_impression(tracker_id) → tracker(_fivetran_id)
- erased_user_gdpr(tracker_id) → tracker(_fivetran_id)
- sk_install(tracker_id) → tracker(_fivetran_id)
- install(tracker_id) → tracker(_fivetran_id)
- ad_revenue(tracker_id) → tracker(_fivetran_id)
- session(tracker_id) → tracker(_fivetran_id)
- san_click(tracker_id) → tracker(_fivetran_id)
- reattribution_update(tracker_id) → tracker(_fivetran_id)
- reattribution(tracker_id) → tracker(_fivetran_id)
- uninstall(tracker_id) → tracker(_fivetran_id)
- reattribution_reinstall(tracker_id) → tracker(_fivetran_id)
- in_app_event(tracker_id) → tracker(_fivetran_id)