# Partnerize schema ERD

Table and field reference for the Fivetran Partnerize connector.

## Table & Field Reference

### deal

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| active | Unknown |  |
| advertiser_reference | Unknown |  |
| category | Unknown |  |
| country_iso | Unknown |  |
| coupon_code | Unknown |  |
| description | Unknown |  |
| destination | Unknown |  |
| end_date_time | Unknown |  |
| offer_type | Unknown |  |
| offer_value | Unknown |  |
| start_date_time | Unknown |  |
| terms | Unknown |  |
| title | Unknown |  |

### state_history

| Column | Type | Keys |
| --- | --- | --- |
| transaction_query_state_id | Unknown | PK |
| transaction_query_id | Unknown | PK, FK |
| conversion_expected_commission | Unknown |  |
| conversion_item_id | Unknown |  |
| created_at | Unknown |  |
| notes | Unknown |  |
| state | Unknown |  |
| user_id | Unknown |  |

### action_available

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_transaction_transaction_query_id | Unknown | PK, FK |
| actions_available | Unknown |  |

### campaign_transaction

| Column | Type | Keys |
| --- | --- | --- |
| transaction_query_id | Unknown | PK |
| advertiser_id | Unknown | FK |
| campaign_id | Unknown | FK |
| publisher_id | Unknown | FK |
| agreed_to_latest_network_terms | Unknown |  |
| camref | Unknown |  |
| conversion_currency | Unknown |  |
| conversion_date_time | Unknown |  |
| conversion_id | Unknown |  |
| conversion_reference | Unknown |  |
| conversion_value | Unknown |  |
| created | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| current_state | Unknown |  |
| default_override | Unknown |  |
| expected_commission | Unknown |  |
| hidden_campaign | Unknown |  |
| ignore_cookie_period_rejection | Unknown |  |
| last_modified | Unknown |  |
| name | Unknown |  |
| network_fee | Unknown |  |
| network_id | Unknown |  |
| network_status | Unknown |  |
| note | Unknown |  |
| payment_date | Unknown |  |
| publisher_created_by | Unknown |  |
| publisher_reference | Unknown |  |
| publisher_reporting_timezone | Unknown |  |
| ref_terms_and_conditions_locale_id | Unknown |  |
| reporting_timezone | Unknown |  |
| signup_ip | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| transaction_query_type | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| vertical_id | Unknown |  |
| week_start | Unknown |  |

### impression_explode

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| advertiser_reference | Unknown |  |
| browser_family | Unknown |  |
| browser_major | Unknown |  |
| browser_minor | Unknown |  |
| browser_patch | Unknown |  |
| campaign_name | Unknown |  |
| creative_advertiser_reference | Unknown |  |
| creative_descriptio | Unknown |  |
| creative_id | Unknown |  |
| date_time | Unknown |  |
| device_id | Unknown |  |
| device_name | Unknown |  |
| os_family | Unknown |  |
| os_major | Unknown |  |
| os_minor | Unknown |  |
| os_patch | Unknown |  |
| partner_id | Unknown |  |
| partner_name | Unknown |  |
| partnership_model_id | Unknown |  |
| partnership_model_name | Unknown |  |
| sku | Unknown |  |
| traffic_source_id | Unknown |  |
| traffic_source_name | Unknown |  |
| user_context_id | Unknown |  |
| user_context_name | Unknown |  |

### promotional_commission_publisher

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promotional_commission_id | Unknown | PK, FK |
| name | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promotional_commission_id | Unknown | PK, FK |
| name | Unknown |  |

### promotional_commission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| commission_based_on_field | Unknown |  |
| cookie_period | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| last_modified | Unknown |  |
| last_modified_by | Unknown |  |
| performance_model | Unknown |  |
| performance_value | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |

### transaction_query

| Column | Type | Keys |
| --- | --- | --- |
| transaction_query_reason_id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| created_at | Unknown |  |
| reason | Unknown |  |

### voucher_code_commission_group

| Column | Type | Keys |
| --- | --- | --- |
| commission_group_id | Unknown | PK, FK |
| voucher_code_id | Unknown | PK, FK |

### voucher_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| active | Unknown |  |
| description | Unknown |  |
| end_date_time | Unknown |  |
| on_expiry | Unknown |  |
| on_invalid_user | Unknown |  |
| start_date_time | Unknown |  |
| voucher_code | Unknown |  |

### network

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| auto_approve_publisher | Unknown |  |
| cm_client_id | Unknown |  |
| default_campaign_id | Unknown |  |
| network_application_id | Unknown |  |
| network_contact_email | Unknown |  |
| network_description | Unknown |  |
| network_locale | Unknown |  |
| network_name | Unknown |  |
| network_note | Unknown |  |

### partner_commission_group_publisher

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partner_commission_group_commission_group_id | Unknown | PK, FK |
| added | Unknown |  |
| publisher_name | Unknown |  |

### partner_commission_group

| Column | Type | Keys |
| --- | --- | --- |
| commission_group_id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| active | Unknown |  |
| description | Unknown |  |
| end_date_time | Unknown |  |
| last_modified | Unknown |  |
| name | Unknown |  |
| start_date_time | Unknown |  |

### preferred_partner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| end_date | Unknown |  |
| partner_id | Unknown |  |
| partner_name | Unknown |  |
| partner_status | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |

### click_explode

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| device_id | Unknown | FK |
| advertiser_reference | Unknown |  |
| browser_family | Unknown |  |
| browser_major | Unknown |  |
| browser_minor | Unknown |  |
| browser_patch | Unknown |  |
| campaign_name | Unknown |  |
| click_conversion_rate | Unknown |  |
| country | Unknown |  |
| country_name | Unknown |  |
| creative_advertiser_reference | Unknown |  |
| creative_description | Unknown |  |
| creative_id | Unknown |  |
| date_time | Unknown |  |
| device_name | Unknown |  |
| os_family | Unknown |  |
| os_major | Unknown |  |
| os_minor | Unknown |  |
| os_patch | Unknown |  |
| partner_id | Unknown |  |
| partner_name | Unknown |  |
| partnership_model_id | Unknown |  |
| partnership_model_name | Unknown |  |
| total_clicks | Unknown |  |
| total_clicks_converted | Unknown |  |
| total_unique_clicks | Unknown |  |
| traffic_source_id | Unknown |  |
| traffic_source_name | Unknown |  |
| type | Unknown |  |
| user_context_id | Unknown |  |
| user_context_name | Unknown |  |

### partner_impression

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| advertiser_reference | Unknown |  |
| browser_family | Unknown |  |
| browser_major | Unknown |  |
| browser_minor | Unknown |  |
| browser_patch | Unknown |  |
| campaign_name | Unknown |  |
| country | Unknown |  |
| country_name | Unknown |  |
| creative_advertiser_reference | Unknown |  |
| creative_description | Unknown |  |
| creative_id | Unknown |  |
| date_time | Unknown |  |
| device_id | Unknown |  |
| device_name | Unknown |  |
| os_family | Unknown |  |
| os_major | Unknown |  |
| os_minor | Unknown |  |
| os_patch | Unknown |  |
| partner_id | Unknown |  |
| partner_name | Unknown |  |
| partnership_model_id | Unknown |  |
| partnership_model_name | Unknown |  |
| publisher_reference | Unknown |  |
| sku | Unknown |  |
| total_impressions | Unknown |  |
| traffic_source_id | Unknown |  |
| traffic_source_name | Unknown |  |
| user_context_id | Unknown |  |
| user_context_name | Unknown |  |

### partner_click

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| device_id | Unknown | FK |
| advertiser_reference | Unknown |  |
| browser_family | Unknown |  |
| browser_major | Unknown |  |
| browser_minor | Unknown |  |
| browser_patch | Unknown |  |
| campaign_name | Unknown |  |
| click_conversion_rate | Unknown |  |
| country | Unknown |  |
| country_name | Unknown |  |
| creative_advertiser_reference | Unknown |  |
| creative_description | Unknown |  |
| creative_id | Unknown |  |
| date_time | Unknown |  |
| device_name | Unknown |  |
| os_family | Unknown |  |
| os_major | Unknown |  |
| os_minor | Unknown |  |
| os_patch | Unknown |  |
| partner_id | Unknown |  |
| partner_name | Unknown |  |
| partnership_model_id | Unknown |  |
| partnership_model_name | Unknown |  |
| publisher_reference | Unknown |  |
| total_clicks | Unknown |  |
| total_clicks_converted | Unknown |  |
| total_unique_clicks | Unknown |  |
| traffic_source_id | Unknown |  |
| traffic_source_name | Unknown |  |
| type | Unknown |  |
| user_context_id | Unknown |  |
| user_context_name | Unknown |  |

### brand_campaign

| Column | Type | Keys |
| --- | --- | --- |
| advertiser_id | Unknown | PK, FK |
| campaign_id | Unknown | PK, FK |
| allow_deep_linking | Unknown |  |
| allow_third_party_pixel | Unknown |  |
| app_android_fingerprint | Unknown |  |
| app_ios_bundle | Unknown |  |
| app_ios_prefix | Unknown |  |
| app_tracking_integration_mapping | Unknown |  |
| app_tracking_provider | Unknown |  |
| app_tracking_provider_tracking_link | Unknown |  |
| append_url_parameters | Unknown |  |
| associated_campaigns | Unknown |  |
| auto_approve_publisher | Unknown |  |
| auto_rejected_ips | Unknown |  |
| automated_invoicing_date | Unknown |  |
| automated_invoicing_po_number | Unknown |  |
| basket_value_cap | Unknown |  |
| budget_summary_interval | Unknown |  |
| budget_summary_start_time | Unknown |  |
| campaign_icon | Unknown |  |
| campaign_invoice_locale | Unknown |  |
| campaign_languages | Unknown |  |
| campaign_logo | Unknown |  |
| campaign_notes | Unknown |  |
| commission_by_meta | Unknown |  |
| commission_by_meta_label | Unknown |  |
| consolidate_invoices | Unknown |  |
| conversion_hiatus_period | Unknown |  |
| conversion_type | Unknown |  |
| cookie_period | Unknown |  |
| cookie_status | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| creative_prepend | Unknown |  |
| deeplink_method | Unknown |  |
| default_currency | Unknown |  |
| default_mobile_destination | Unknown |  |
| default_override | Unknown |  |
| deferred_lead_submission | Unknown |  |
| description | Unknown |  |
| destination_url | Unknown |  |
| dont_consolidate | Unknown |  |
| dont_invoice | Unknown |  |
| finance_contact_email | Unknown |  |
| force_approve_period | Unknown |  |
| hash_ip_addresses | Unknown |  |
| hidden_campaign | Unknown |  |
| ignore_cookie_period_rejections | Unknown |  |
| invalid_voucher_conversion_metric_id | Unknown |  |
| invoice_address_1 | Unknown |  |
| invoice_address_2 | Unknown |  |
| invoice_address_3 | Unknown |  |
| invoice_address_4 | Unknown |  |
| invoice_address_country | Unknown |  |
| invoice_address_postcode | Unknown |  |
| invoice_company | Unknown |  |
| invoice_contact | Unknown |  |
| invoice_only | Unknown |  |
| ip_tracking_time | Unknown |  |
| is_cpc | Unknown |  |
| is_cpc_default | Unknown |  |
| last_modified | Unknown |  |
| lead_confirmation_url_fail | Unknown |  |
| lead_confirmation_url_success | Unknown |  |
| meta_field_values_field_limit | Unknown |  |
| meta_field_values_total_limit | Unknown |  |
| multiple_conversions_per_click | Unknown |  |
| network_fee | Unknown |  |
| pay_publisher_directly | Unknown |  |
| payment_date | Unknown |  |
| prepend_url_string | Unknown |  |
| recurring_payment_setup | Unknown |  |
| reporting_timezone | Unknown |  |
| secure_tracking | Unknown |  |
| short_link_subdomain | Unknown |  |
| status | Unknown |  |
| test_mode | Unknown |  |
| title | Unknown |  |
| tq_auto_approve | Unknown |  |
| tq_enabled | Unknown |  |
| tracking_method | Unknown |  |
| tracking_subdomain | Unknown |  |
| unique_conversion_refs | Unknown |  |
| vertical_id | Unknown |  |
| week_start | Unknown |  |

### platform_communication

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conditions | Json |  |
| disabled | Unknown |  |
| event_id | Unknown |  |
| from_name | Unknown |  |
| name | Unknown |  |
| reply_to_email | Unknown |  |
| subject | Unknown |  |
| updated_at | Unknown |  |

### product_feed

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| active | Unknown |  |
| dynamic | Unknown |  |
| fetch_frequency | Unknown |  |
| filesize | Unknown |  |
| last_processed | Unknown |  |
| location | Unknown |  |
| location_local | Unknown |  |
| name | Unknown |  |
| updated | Unknown |  |

### communication_campaign

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| communication_id | Unknown | PK, FK |
| campaign | Unknown |  |

### communication

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| from_email | Unknown |  |
| from_name | Unknown |  |
| last_updated | Unknown |  |
| name | Unknown |  |
| preview_url | Unknown |  |
| recipient_count | Unknown |  |
| reply_to_email | Unknown |  |
| send_date | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| timezone | Unknown |  |
| type | Unknown |  |

### brand

| Column | Type | Keys |
| --- | --- | --- |
| advertiser_id | Unknown | PK |
| account_name | Unknown |  |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| address_3 | Unknown |  |
| address_4 | Unknown |  |
| advertiser_icon | Unknown |  |
| allowed_deep_linking_domain | Unknown |  |
| budget_summary_interval | Unknown |  |
| budget_summary_start_time | Unknown |  |
| company_name | Unknown |  |
| contact_email | Unknown |  |
| country | Unknown |  |
| current_balance | Unknown |  |
| default_currency | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| payment_currency | Unknown |  |
| phone | Unknown |  |
| postcode | Unknown |  |
| pre_payment | Unknown |  |
| signup_ip | Unknown |  |
| status | Unknown |  |
| vat_number | Unknown |  |

### conversion_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| conversion_id | Unknown | PK, FK |
| invoice_id | Unknown | FK |
| approved_at | Unknown |  |
| category | Unknown |  |
| display_to_publisher | Unknown |  |
| item_commission | Unknown |  |
| item_publisher_commission | Unknown |  |
| item_status | Unknown |  |
| item_status_id | Unknown |  |
| item_value | Unknown |  |
| last_update | Unknown |  |
| meta_data_gclid | Unknown |  |
| reject_reason | Unknown |  |
| sku | Unknown |  |
| voucher_codes | Json |  |

### conversion

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK |
| id | Unknown | PK |
| device_id | Unknown | FK |
| publisher_id | Unknown | FK |
| ref_device_id | Unknown | FK |
| advertiser_reference | Unknown |  |
| campaign_title | Unknown |  |
| click_id | Unknown |  |
| click_last_ip | Unknown |  |
| click_last_used | Unknown |  |
| click_set_ip | Unknown |  |
| click_set_time | Unknown |  |
| click_status | Unknown |  |
| click_type | Unknown |  |
| clickref | Unknown |  |
| conversion_lag | Unknown |  |
| conversion_reference | Unknown |  |
| conversion_time | Unknown |  |
| conversion_type | Unknown |  |
| conversion_value_commission | Unknown |  |
| conversion_value_conversion_status | Unknown |  |
| conversion_value_id | Unknown |  |
| conversion_value_publisher_commission | Unknown |  |
| conversion_value_value | Unknown |  |
| country | Unknown |  |
| creative_id | Unknown |  |
| creative_type | Unknown |  |
| currency | Unknown |  |
| currency_conversion_rate | Unknown |  |
| currency_original | Unknown |  |
| customer_reference | Unknown |  |
| customer_type | Unknown |  |
| end_date | Unknown |  |
| last_modified | Unknown |  |
| meta_data_commission_category | Unknown |  |
| meta_data_customer_country | Unknown |  |
| meta_data_dispute_date | Unknown |  |
| meta_data_event_date | Unknown |  |
| meta_data_event_name | Unknown |  |
| meta_data_event_organizer | Unknown |  |
| meta_data_event_series | Unknown |  |
| meta_data_tuid | Unknown |  |
| publisher_name | Unknown |  |
| ref_conversion_metric | Unknown |  |
| ref_conversion_metric_id | Unknown |  |
| ref_device | Unknown |  |
| ref_partnership_model | Unknown |  |
| ref_partnership_model_id | Unknown |  |
| ref_traffic_source | Unknown |  |
| ref_traffic_source_id | Unknown |  |
| ref_user_context | Unknown |  |
| ref_user_context_id | Unknown |  |
| referer_ip | Unknown |  |
| source_referer | Unknown |  |
| specific_creative_id | Unknown |  |
| start_date | Unknown |  |
| was_disputed | Unknown |  |

### publisher_participating_partner_website

| Column | Type | Keys |
| --- | --- | --- |
| website_id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| publisher_id | Unknown | PK, FK |
| active | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| description | Unknown |  |
| meta | Json |  |
| primaries | Unknown |  |
| website_country | Unknown |  |
| website_name | Unknown |  |
| website_type | Unknown |  |
| website_type_name | Unknown |  |
| website_url | Unknown |  |
| website_vertical | Unknown |  |
| website_vertical_name | Unknown |  |

### publisher_participating_partner_database

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| publisher_participating_partner_publisher_id | Unknown | PK, FK |
| active | Unknown |  |
| creation_method | Unknown |  |
| database_name | Unknown |  |
| female | Unknown |  |
| male | Unknown |  |
| max_age | Unknown |  |
| min_age | Unknown |  |
| size | Unknown |  |

### publisher_participating_partner_legal_entity

| Column | Type | Keys |
| --- | --- | --- |
| publisher_id | Unknown | PK |
| ref_legal_entity_id | Unknown | PK |
| publisher_participating_partner_publisher_id | Unknown | PK, FK |
| associated_date | Unknown |  |
| publisher_contract_id | Unknown |  |

### publisher_participating_partner_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| publisher_participating_partner_publisher_id | Unknown | PK, FK |
| groups | Unknown |  |

### publisher_participating_partner

| Column | Type | Keys |
| --- | --- | --- |
| publisher_id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| network_id | Unknown | FK |
| abn | Unknown |  |
| account_name | Unknown |  |
| campaign_approved | Unknown |  |
| campaign_custom_terms_and_conditions_id | Unknown |  |
| campaign_custom_terms_and_conditions_title | Unknown |  |
| campaign_overload | Json |  |
| campaign_select | Unknown |  |
| campaign_status | Unknown |  |
| camref | Unknown |  |
| company_division | Unknown |  |
| company_logo | Unknown |  |
| company_name | Unknown |  |
| contact_email | Unknown |  |
| contact_locale | Unknown |  |
| contact_name | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| default_currency | Unknown |  |
| description | Unknown |  |
| foreign_identifier | Unknown |  |
| gst_registered | Unknown |  |
| im_provider | Unknown |  |
| im_username | Unknown |  |
| is_affiliate_user | Unknown |  |
| is_company | Unknown |  |
| is_foreign_network | Unknown |  |
| is_lead_user | Unknown |  |
| is_us_registered | Unknown |  |
| meta | Json |  |
| network_meta_data | Json |  |
| network_note | Unknown |  |
| network_status | Unknown |  |
| operating_country | Unknown |  |
| opt_in | Unknown |  |
| phone | Unknown |  |
| phone_area | Unknown |  |
| promotional_method | Unknown |  |
| promotional_method_name | Unknown |  |
| reference_id | Unknown |  |
| reporting_identifier | Unknown |  |
| reporting_timezone | Unknown |  |
| signup_ip | Unknown |  |
| terms_and_conditions_id | Unknown |  |
| tin_number | Unknown |  |
| tracking_link | Unknown |  |
| uk_vat_registered | Unknown |  |
| us_tax_state | Unknown |  |
| vat_number | Unknown |  |
| vertical | Unknown |  |
| vertical_name | Unknown |  |
| week_start | Unknown |  |

### conversation_explode

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| advertiser_reference | Unknown |  |
| average_commission | Unknown |  |
| average_order_size | Unknown |  |
| average_order_value | Unknown |  |
| average_partner_commission | Unknown |  |
| average_roas | Unknown |  |
| browser_family | Unknown |  |
| browser_major | Unknown |  |
| browser_minor | Unknown |  |
| browser_patch | Unknown |  |
| campaign_name | Unknown |  |
| category | Unknown |  |
| conversion_metric_id | Unknown |  |
| conversion_rejection_rate | Unknown |  |
| conversion_type_name | Unknown |  |
| country | Unknown |  |
| country_name | Unknown |  |
| creative_advertiser_reference | Unknown |  |
| creative_descriptio | Unknown |  |
| creative_id | Unknown |  |
| currency | Unknown |  |
| customer_reference | Unknown |  |
| customer_type | Unknown |  |
| date_time | Unknown |  |
| device_id | Unknown |  |
| device_name | Unknown |  |
| e_cpa | Unknown |  |
| os_family | Unknown |  |
| os_major | Unknown |  |
| os_minor | Unknown |  |
| os_patch | Unknown |  |
| partner_id | Unknown |  |
| partner_name | Unknown |  |
| partnership_model_id | Unknown |  |
| partnership_model_name | Unknown |  |
| percentage_average_partner_commission | Unknown |  |
| percentage_commission | Unknown |  |
| percentage_order_value | Unknown |  |
| percentage_partner_commission | Unknown |  |
| sku | Unknown |  |
| total_commission | Unknown |  |
| total_conversion_items | Unknown |  |
| total_conversions | Unknown |  |
| total_order_value | Unknown |  |
| total_partner_commission | Unknown |  |
| total_roas | Unknown |  |
| traffic_source_id | Unknown |  |
| traffic_source_name | Unknown |  |
| type | Unknown |  |
| user_context_id | Unknown |  |
| user_context_name | Unknown |  |
| voucher_code | Unknown |  |
| voucher_status | Unknown |  |
| voucher_status_name | Unknown |  |

### metric

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| count | Unknown |  |
| last_raised_at | Unknown |  |
| metric | Unknown |  |
| type | Unknown |  |

### campaign_promotional_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| iso | Unknown |  |
| name | Unknown |  |

### campaign_commission

| Column | Type | Keys |
| --- | --- | --- |
| commission_id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| active | Unknown |  |
| advertiser_reference | Unknown |  |
| category | Unknown |  |
| commission_category | Unknown |  |
| commission_rate | Unknown |  |
| commission_value | Unknown |  |
| conversion_type | Unknown |  |
| cookie_period | Unknown |  |
| cookie_status | Unknown |  |
| country | Unknown |  |
| customer_reference | Unknown |  |
| customer_type | Unknown |  |
| end_date_time | Unknown |  |
| event_date | Unknown |  |
| event_name | Unknown |  |
| event_organizer | Unknown |  |
| event_series | Unknown |  |
| last_modified | Unknown |  |
| last_modified_by | Unknown |  |
| override | Unknown |  |
| override_type | Unknown |  |
| promotion | Unknown |  |
| reference_id | Unknown |  |
| reference_type | Unknown |  |
| sale_type | Unknown |  |
| sku | Unknown |  |
| start_date_time | Unknown |  |
| update_description | Unknown |  |
| vertical | Unknown |  |

### campaign_overload

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| publisher_id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| is_cpc | Unknown |  |

### campaign_currency_conversion

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| active | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| from_currency | Unknown |  |
| to_currency | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| advertiser_name | Unknown |  |
| allow_deep_linking | Unknown |  |
| allow_third_party_pixel | Unknown |  |
| app_android_fingerprint | Unknown |  |
| app_ios_bundle | Unknown |  |
| app_ios_prefix | Unknown |  |
| app_tracking_integration_mapping | Unknown |  |
| app_tracking_provider | Unknown |  |
| app_tracking_provider_tracking_link | Unknown |  |
| append_url_parameter | Unknown |  |
| associated_campaign | Unknown |  |
| auto_approve_publisher | Unknown |  |
| auto_rejected_ips | Unknown |  |
| automated_invoicing_date | Unknown |  |
| automated_invoicing_po_number | Unknown |  |
| basket_value_cap | Unknown |  |
| budget_summary_interval | Unknown |  |
| budget_summary_start_time | Unknown |  |
| campaign_currency_conversions | Unknown |  |
| campaign_icon | Unknown |  |
| campaign_invoice_locale | Unknown |  |
| campaign_language | Unknown |  |
| campaign_logo | Unknown |  |
| campaign_notes | Unknown |  |
| campaign_overload | Unknown |  |
| commission_by_meta | Unknown |  |
| commission_by_meta_label | Unknown |  |
| consolidate_invoice | Unknown |  |
| conversion_hiatus_period | Unknown |  |
| conversion_type | Unknown |  |
| cookie_period | Unknown |  |
| cookie_status | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| creative_prepend | Unknown |  |
| deeplink_method | Unknown |  |
| default_commission_rate | Unknown |  |
| default_commission_value | Unknown |  |
| default_currency | Unknown |  |
| default_mobile_destination | Unknown |  |
| default_override | Unknown |  |
| deferred_lead_submission | Unknown |  |
| destination_url | Unknown |  |
| dont_consolidate | Unknown |  |
| dont_invoice | Unknown |  |
| finance_contact_email | Unknown |  |
| force_approve_period | Unknown |  |
| hash_ip_address | Unknown |  |
| hidden_campaign | Unknown |  |
| ignore_cookie_period_rejection | Unknown |  |
| invalid_voucher_conversion_metric_id | Unknown |  |
| invoice_address_1 | Unknown |  |
| invoice_address_2 | Unknown |  |
| invoice_address_3 | Unknown |  |
| invoice_address_4 | Unknown |  |
| invoice_address_country | Unknown |  |
| invoice_address_postcode | Unknown |  |
| invoice_company | Unknown |  |
| invoice_contact | Unknown |  |
| invoice_only | Unknown |  |
| ip_tracking_time | Unknown |  |
| is_cpc | Unknown |  |
| is_cpc_default | Unknown |  |
| last_modified | Unknown |  |
| lead_confirmation_url_fail | Unknown |  |
| lead_confirmation_url_success | Unknown |  |
| meta_field_values_field_limit | Unknown |  |
| meta_field_values_total_limit | Unknown |  |
| multiple_conversions_per_click | Unknown |  |
| network_fee | Unknown |  |
| pay_publisher_directly | Unknown |  |
| payment_date | Unknown |  |
| prepend_url_string | Unknown |  |
| recurring_payment_setup | Unknown |  |
| reporting_timezone | Unknown |  |
| secure_tracking | Unknown |  |
| short_link_subdomain | Unknown |  |
| status | Unknown |  |
| test_mode | Unknown |  |
| title | Unknown |  |
| tq_auto_approve | Unknown |  |
| tq_enabled | Unknown |  |
| tracking_method | Unknown |  |
| tracking_subdomain | Unknown |  |
| unique_conversion_ref | Unknown |  |
| vertical_id | Unknown |  |
| vertical_name | Unknown |  |
| week_start | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| average_conversion_age | Unknown |  |
| creation_date | Unknown |  |
| currency | Unknown |  |
| download | Unknown |  |
| invoice_net_value | Unknown |  |
| invoice_reference | Unknown |  |
| invoice_total_value | Unknown |  |
| invoice_vat_value | Unknown |  |
| invoiced | Unknown |  |
| item_download | Unknown |  |
| merchant_invoice_id | Unknown |  |
| paid_currency | Unknown |  |
| payment_date | Unknown |  |
| payment_due_by_date | Unknown |  |
| payment_reference | Unknown |  |
| pdf_generated | Unknown |  |
| publisher_commission | Unknown |  |
| publisher_override | Unknown |  |
| report_generated | Unknown |  |
| set_end_date | Unknown |  |
| set_start_date | Unknown |  |
| set_timezone | Unknown |  |
| status | Unknown |  |
| vat_rate | Unknown |  |

### voucher_commission_groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### voucher_commission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| end_date | Unknown |  |
| group_limit_id | Unknown |  |
| group_limit_name | Unknown |  |
| last_modified | Unknown |  |
| last_modified_by | Unknown |  |
| meta_fields | Json |  |
| performance_model | Unknown |  |
| performance_value | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |

### device

| Column | Type | Keys |
| --- | --- | --- |
| ref_device_id | Unknown | PK |
| description | Unknown |  |
| key | Unknown |  |
| skip_invoice | Unknown |  |
| skip_override | Unknown |  |
| skip_selfbill | Unknown |  |
| title | Unknown |  |

### incident

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| deleted_at | Unknown |  |
| metric | Unknown |  |
| occurred_at | Unknown |  |
| partner_id | Unknown |  |
| partner_name | Unknown |  |
| status | Unknown |  |
| time_window | Unknown |  |
| type | Unknown |  |

### partner_conversion

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| advertiser_reference | Unknown |  |
| average_order_size | Unknown |  |
| average_order_value | Unknown |  |
| average_partner_commission | Unknown |  |
| browser_family | Unknown |  |
| browser_major | Unknown |  |
| browser_minor | Unknown |  |
| browser_patch | Unknown |  |
| campaign_name | Unknown |  |
| category | Unknown |  |
| conversion_metric_id | Unknown |  |
| conversion_metric_name | Unknown |  |
| conversion_rejection_rate | Unknown |  |
| conversion_status | Unknown |  |
| conversion_type_id | Unknown |  |
| conversion_type_name | Unknown |  |
| country | Unknown |  |
| country_name | Unknown |  |
| creative_advertiser_reference | Unknown |  |
| creative_description | Unknown |  |
| creative_id | Unknown |  |
| currency | Unknown |  |
| customer_type | Unknown |  |
| date_time | Unknown |  |
| device_id | Unknown |  |
| device_name | Unknown |  |
| os_family | Unknown |  |
| os_major | Unknown |  |
| os_minor | Unknown |  |
| os_patch | Unknown |  |
| partner_id | Unknown |  |
| partner_name | Unknown |  |
| partnership_model_id | Unknown |  |
| partnership_model_name | Unknown |  |
| percentage_average_partner_commission | Unknown |  |
| percentage_order_value | Unknown |  |
| percentage_partner_commission | Unknown |  |
| publisher_reference | Unknown |  |
| sku | Unknown |  |
| total_conversion_items | Unknown |  |
| total_conversions | Unknown |  |
| total_order_value | Unknown |  |
| total_partner_commission | Unknown |  |
| traffic_source_id | Unknown |  |
| traffic_source_name | Unknown |  |
| type | Unknown |  |
| user_context_id | Unknown |  |
| user_context_name | Unknown |  |
| voucher_code | Unknown |  |
| voucher_status | Unknown |  |
| voucher_status_name | Unknown |  |

## Relationships

- deal(campaign_id) → campaign(id)
- state_history(transaction_query_id) → campaign_transaction(transaction_query_id)
- action_available(campaign_transaction_transaction_query_id) → campaign_transaction(transaction_query_id)
- campaign_transaction(campaign_id) → campaign(id)
- campaign_transaction(publisher_id) → publisher_participating_partner(publisher_id)
- campaign_transaction(advertiser_id) → brand(advertiser_id)
- impression_explode(campaign_id) → campaign(id)
- promotional_commission_publisher(promotional_commission_id) → promotional_commission(id)
- groups(promotional_commission_id) → promotional_commission(id)
- promotional_commission(campaign_id) → campaign(id)
- transaction_query(campaign_id) → campaign(id)
- voucher_code_commission_group(commission_group_id) → partner_commission_group(commission_group_id)
- voucher_code_commission_group(voucher_code_id) → voucher_code(id)
- voucher_code(campaign_id) → campaign(id)
- partner_commission_group_publisher(partner_commission_group_commission_group_id) → partner_commission_group(commission_group_id)
- partner_commission_group(campaign_id) → campaign(id)
- click_explode(campaign_id) → campaign(id)
- click_explode(device_id) → device(ref_device_id)
- partner_impression(campaign_id) → campaign(id)
- partner_click(campaign_id) → campaign(id)
- partner_click(device_id) → device(ref_device_id)
- brand_campaign(advertiser_id) → brand(advertiser_id)
- brand_campaign(campaign_id) → campaign(id)
- product_feed(campaign_id) → campaign(id)
- communication_campaign(communication_id) → communication(id)
- conversion_item(invoice_id) → invoice(id)
- conversion_item(conversion_id) → conversion(id)
- conversion_item(campaign_id) → conversion(campaign_id)
- conversion(publisher_id) → publisher_participating_partner(publisher_id)
- conversion(ref_device_id) → device(ref_device_id)
- conversion(device_id) → device(ref_device_id)
- publisher_participating_partner_website(publisher_id) → publisher_participating_partner(publisher_id)
- publisher_participating_partner_website(campaign_id) → publisher_participating_partner(campaign_id)
- publisher_participating_partner_database(publisher_participating_partner_publisher_id) → publisher_participating_partner(publisher_id)
- publisher_participating_partner_legal_entity(publisher_participating_partner_publisher_id) → publisher_participating_partner(publisher_id)
- publisher_participating_partner_group(publisher_participating_partner_publisher_id) → publisher_participating_partner(publisher_id)
- publisher_participating_partner(network_id) → network(id)
- publisher_participating_partner(campaign_id) → campaign(id)
- conversation_explode(campaign_id) → campaign(id)
- metric(campaign_id) → campaign(id)
- campaign_promotional_country(campaign_id) → campaign(id)
- campaign_commission(campaign_id) → campaign(id)
- campaign_overload(campaign_id) → campaign(id)
- campaign_currency_conversion(campaign_id) → campaign(id)
- campaign(advertiser_id) → brand(advertiser_id)
- invoice(campaign_id) → campaign(id)
- incident(campaign_id) → campaign(id)
- partner_conversion(campaign_id) → campaign(id)