# Impact Brand schema ERD

Table and field reference for the Fivetran Impact Brand connector.

## Table & Field Reference

### routing_rule_condition_value

| Column | Type | Keys |
| --- | --- | --- |
| value | Unknown | PK |
| routing_rule_condition_routing_rule_id | Unknown | PK, FK |
| routing_rule_condition_variable | Unknown | PK, FK |

### routing_rule_condition

| Column | Type | Keys |
| --- | --- | --- |
| variable | Unknown | PK |
| routing_rule_id | Unknown | PK, FK |
| operator | Unknown |  |

### routing_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| action | Unknown |  |
| created_by | Unknown |  |
| date_created | Unknown |  |
| date_last_updated | Unknown |  |
| last_updated_by | Unknown |  |
| name | Unknown |  |
| rank | Unknown |  |
| redirect_url | Unknown |  |
| source | Unknown |  |
| state | Unknown |  |

### promo_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_partner_id | Unknown | FK |
| campaign_id | Unknown | FK |
| deal_id | Unknown | FK |
| assigned_partner_name | Unknown |  |
| bogo_buy_image_url | Unknown |  |
| bogo_buy_name | Unknown |  |
| bogo_buy_quantity | Unknown |  |
| bogo_buy_scope | Unknown |  |
| bogo_get_discount_amount | Unknown |  |
| bogo_get_discount_currency | Unknown |  |
| bogo_get_discount_percent | Unknown |  |
| bogo_get_discount_type | Unknown |  |
| bogo_get_image_url | Unknown |  |
| bogo_get_name | Unknown |  |
| bogo_get_quantity | Unknown |  |
| bogo_get_scope | Unknown |  |
| campaign_name | Unknown |  |
| code | Unknown |  |
| created_date | Unknown |  |
| credit_policy | Unknown |  |
| deal_categories | Unknown |  |
| deal_default_promo_code | Unknown |  |
| deal_description | Unknown |  |
| deal_end_date | Unknown |  |
| deal_name | Unknown |  |
| deal_products | Json |  |
| deal_restricted_media_partner_groups | Json |  |
| deal_restricted_media_partners | Json |  |
| deal_scope | Unknown |  |
| deal_start_date | Unknown |  |
| deal_state | Unknown |  |
| deal_type | Unknown |  |
| discount_amount | Unknown |  |
| discount_currency | Unknown |  |
| discount_maximum_percent | Unknown |  |
| discount_percent | Unknown |  |
| discount_percent_range_end | Unknown |  |
| discount_percent_range_start | Unknown |  |
| discount_type | Unknown |  |
| end_date | Unknown |  |
| gift | Unknown |  |
| maximum_savings_amount | Unknown |  |
| maximum_savings_currency | Unknown |  |
| minimum_purchase_amount | Unknown |  |
| minimum_purchase_amount_currency | Unknown |  |
| purchase_limit_quantity | Unknown |  |
| rebate_amount | Unknown |  |
| rebate_currency | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |
| synch_ads_promo_codes | Unknown |  |
| type | Unknown |  |

### contact_account

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

### contact_label

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| contact_id | Unknown | PK, FK |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| cellphone_number | Unknown |  |
| cellphone_number_country | Unknown |  |
| editable | Boolean |  |
| email_address | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| profile_image | Unknown |  |
| title | Unknown |  |
| work_phone_number | Unknown |  |
| work_phone_number_country | Unknown |  |

### contract_event_valid_referral

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contract_event_payout_event_type_id | Unknown | FK |
| type | Unknown |  |
| window | Unknown |  |
| window_unit | Unknown |  |

### contract_payout_group_rule_value

| Column | Type | Keys |
| --- | --- | --- |
| value | Unknown | PK |
| contract_payout_group_rule_contract_event_payout_group_id | Unknown | PK, FK |
| contract_payout_group_rule_variable | Unknown | PK, FK |

### contract_payout_group_rule

| Column | Type | Keys |
| --- | --- | --- |
| variable | Unknown | PK |
| contract_event_payout_group_id | Unknown | PK, FK |
| operator | Unknown |  |

### contract_payout_group_limit

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contract_event_payout_group_id | Unknown | PK, FK |
| limit_by | Unknown |  |
| period | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |
| weekend_override_value | Unknown |  |

### contract_event_payout_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_event_payout_event_type_id | Unknown | FK |
| payout_rate | Unknown |  |
| rank | Unknown |  |

### contract_payout_adjustment_rule_value

| Column | Type | Keys |
| --- | --- | --- |
| value | Unknown | PK |
| contract_event_payout_adjustment_id | Unknown | PK, FK |
| contract_payout_adjustment_rule_variable | Unknown | PK, FK |

### contract_payout_adjustment_rule

| Column | Type | Keys |
| --- | --- | --- |
| variable | Unknown | PK |
| contract_event_payout_adjustment_id | Unknown | PK, FK |
| operator | Unknown |  |

### contract_event_payout_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_event_payout_event_type_id | Unknown | FK |
| direction | Unknown |  |
| rate | Unknown |  |

### contract_event_payout_tier

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contract_event_payout_event_type_id | Unknown | FK |
| payout_rate | Unknown |  |
| revenue_threshold | Unknown |  |

### contract_event_payout_restriction_rule_value

| Column | Type | Keys |
| --- | --- | --- |
| value | Unknown | PK |
| contract_event_payout_restriction_id | Unknown | PK, FK |
| contract_event_payout_restriction_rule_variable | Unknown | PK, FK |

### contract_event_payout_restriction_rule

| Column | Type | Keys |
| --- | --- | --- |
| variable | Unknown | PK |
| contract_event_payout_restriction_id | Unknown | PK, FK |
| operator | Unknown |  |

### contract_event_payout_restriction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_event_payout_event_type_id | Unknown | FK |

### contract_event_payout_limit

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contract_event_payout_event_type_id | Unknown | FK |
| limit_by | Unknown |  |
| period | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |
| weekend_override_value | Unknown |  |

### contract_event_payout_special_term

| Column | Type | Keys |
| --- | --- | --- |
| terms_name | Unknown | PK |
| contract_event_payout_event_type_id | Unknown | PK, FK |
| terms_content | Unknown |  |
| terms_type | Unknown |  |

### contract_event_payout

| Column | Type | Keys |
| --- | --- | --- |
| event_type_id | Unknown | PK |
| contract_id | Unknown | FK |
| credit_policy | Unknown |  |
| default_payout_rate | Unknown |  |
| event_category | Unknown |  |
| event_type_name | Unknown |  |
| locking_basis | Unknown |  |
| locking_day_offset | Unknown |  |
| locking_month_offset | Unknown |  |
| locking_period | Unknown |  |
| payout_level | Unknown |  |
| payout_schedulingbasis | Unknown |  |
| payout_schedulingperiod | Unknown |  |
| performance_bonus_basis | Unknown |  |
| performance_bonus_period | Unknown |  |
| performance_bonus_type | Unknown |  |

### contract_label

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| contract_id | Unknown | PK, FK |

### contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| partner_id | Unknown | FK |
| brand_signatory | Unknown |  |
| brand_signatory_date | Unknown |  |
| date_created | Unknown |  |
| date_last_updated | Unknown |  |
| end_date | Unknown |  |
| partner_signatory | Unknown |  |
| partner_signatory_date | Unknown |  |
| partner_value_1 | Unknown |  |
| pdf_uri | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| template_terms_action_limit | Unknown |  |
| template_terms_action_limit_period | Unknown |  |
| template_terms_change_notification_period | Unknown |  |
| template_terms_contract_start_slotting_fee | Unknown |  |
| template_terms_currency | Unknown |  |
| template_terms_custom_creative_payer | Unknown |  |
| template_terms_max_return_percentage | Unknown |  |
| template_terms_min_earning_per_click | Unknown |  |
| template_terms_name | Unknown |  |
| template_terms_return_policy | Unknown |  |
| template_terms_spend_limit | Unknown |  |
| template_terms_spend_limit_period | Unknown |  |
| template_terms_template_id | Unknown |  |
| template_terms_version_id | Unknown |  |

### ads

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| deal_id | Unknown | FK |
| ad_code_template | Unknown |  |
| ad_type | Unknown |  |
| allow_deep_linking | Unknown |  |
| banner_alternative_tag | Unknown |  |
| bogo_buy_image_url | Unknown |  |
| bogo_buy_name | Unknown |  |
| bogo_buy_quantity | Unknown |  |
| bogo_buy_scope | Unknown |  |
| bogo_get_discount_amount | Unknown |  |
| bogo_get_discount_currency | Unknown |  |
| bogo_get_discount_percent | Unknown |  |
| bogo_get_discount_type | Unknown |  |
| bogo_get_image_url | Unknown |  |
| bogo_get_name | Unknown |  |
| bogo_get_quantity | Unknown |  |
| bogo_get_scope | Unknown |  |
| campaign_name | Unknown |  |
| coupon_allow_custom_promo_code | Unknown |  |
| coupon_link_name | Unknown |  |
| custom_ad_serving_url | Unknown |  |
| customisation_charge | Unknown |  |
| deal_categories | Unknown |  |
| deal_default_promo_code | Unknown |  |
| deal_description | Unknown |  |
| deal_end_date | Unknown |  |
| deal_name | Unknown |  |
| deal_products | Json |  |
| deal_restricted_media_partner_groups | Json |  |
| deal_restricted_media_partners | Json |  |
| deal_scope | Unknown |  |
| deal_start_date | Unknown |  |
| deal_state | Unknown |  |
| deal_type | Unknown |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| discount_currency | Unknown |  |
| discount_maximum_percent | Unknown |  |
| discount_percent | Unknown |  |
| discount_percent_range_end | Unknown |  |
| discount_percent_range_start | Unknown |  |
| discount_type | Unknown |  |
| get_html_code_type | Unknown |  |
| gift | Unknown |  |
| iab_ad_unit | Unknown |  |
| labels | Unknown |  |
| landing_page | Unknown |  |
| languages | Unknown |  |
| limited_time_end_date | Unknown |  |
| limited_time_start_date | Unknown |  |
| link_text | Unknown |  |
| maximum_savings_amount | Unknown |  |
| maximum_savings_currency | Unknown |  |
| minimum_purchase_amount | Unknown |  |
| minimum_purchase_amount_currency | Unknown |  |
| mobile_fallbacks_anoride | Unknown |  |
| mobile_fallbacks_ios | Unknown |  |
| mobile_ready | Unknown |  |
| name | Unknown |  |
| phone_tracking | Unknown |  |
| promo_code_tracking | Unknown |  |
| purchase_limit_quantity | Unknown |  |
| rebate_amount | Unknown |  |
| rebate_currency | Unknown |  |
| restricted_media_partner_groups | Json |  |
| restricted_media_partners | Json |  |
| season | Unknown |  |
| synch_ads_promo_codes | Unknown |  |
| third_party_servable_ad_creative_height | Unknown |  |
| third_party_servable_ad_creative_width | Unknown |  |
| top_seller | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| actions | Unknown |  |
| assignee_account | Unknown |  |
| assignee_user_email_address | Unknown |  |
| assignee_user_username | Unknown |  |
| attachments | Json |  |
| created_by_email_address | Unknown |  |
| created_by_username | Unknown |  |
| date_created | Unknown |  |
| date_last_updated | Unknown |  |
| details_description | Unknown |  |
| details_resolution_id | Unknown |  |
| details_resolution_name | Unknown |  |
| details_state | Unknown |  |
| details_subtype_id | Unknown |  |
| details_subtype_name | Unknown |  |
| details_summary | Unknown |  |
| details_type | Unknown |  |
| details_urgent | Unknown |  |
| due_date | Unknown |  |
| last_updated_by_email_address | Unknown |  |
| last_updated_by_username | Unknown |  |
| reference | Unknown |  |
| total_actions | Unknown |  |
| total_comments | Unknown |  |

### task_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| task_id | Unknown | FK |
| attachments | Json |  |
| comment | Unknown |  |
| commenter | Unknown |  |

### campaign_primary_category

| Column | Type | Keys |
| --- | --- | --- |
| primary_sub_category | Unknown | PK |
| campaign_id | Unknown | PK, FK |

### campaign_company_contact

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| email_address | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| phone_number | Unknown |  |

### campaign_shipping_region

| Column | Type | Keys |
| --- | --- | --- |
| shipping_region | Unknown | PK |
| campaign_id | Unknown | PK, FK |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| categories_additional_category | Unknown |  |
| categories_additional_sub_categories | Json |  |
| categories_primary_category | Unknown |  |
| direct_tracking_settings_session_window_length | Unknown |  |
| direct_tracking_settings_unidentified_name | Unknown |  |
| display_future_ads | Unknown |  |
| display_servicing_agency | Unknown |  |
| gateway_tracking_settings_campaign_tracking_template | Unknown |  |
| gateway_tracking_settings_deep_link_domains | Unknown |  |
| gateway_tracking_settings_deep_linking | Unknown |  |
| gateway_tracking_settings_default_landing_page | Unknown |  |
| gateway_tracking_settings_media_partner_tracking_template | Unknown |  |
| gateway_tracking_settings_ssl_support | Unknown |  |
| gateway_tracking_settings_third_party_gateway_query_string_parameters | Unknown |  |
| gateway_tracking_settings_third_party_gateway_url | Unknown |  |
| gateway_tracking_settings_unique_click_window_length | Unknown |  |
| gateway_tracking_settings_unique_click_window_type | Unknown |  |
| gift_card_payouts | Unknown |  |
| identity_matching | Unknown |  |
| impression_tracking | Unknown |  |
| list_in_marketplace | Unknown |  |
| long_description | Unknown |  |
| mobile_ready_ads | Unknown |  |
| name | Unknown |  |
| promo_code_tracking | Unknown |  |
| rating | Unknown |  |
| resources_additional_related_links | Json |  |
| resources_company_homepage | Unknown |  |
| resources_example_landing_page | Unknown |  |
| resources_information_page | Unknown |  |
| search_keywords | Unknown |  |
| short_description | Unknown |  |
| site_definition | Unknown |  |
| state | Unknown |  |
| third_party_impression_pixel | Unknown |  |
| tracking_domain | Unknown |  |
| trademark_bidding | Unknown |  |
| view_through_crediting | Unknown |  |

### exception_action_tracker

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

### exception_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| created_date | Unknown |  |
| deactivation_date | Unknown |  |
| items_uri | Unknown |  |
| name | Unknown |  |
| number_of_items | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| attachments | Json |  |
| content | Unknown |  |
| creation_date | Unknown |  |
| creator | Unknown |  |
| media_id | Unknown |  |
| media_name | Unknown |  |
| modification_date | Unknown |  |
| type | Unknown |  |

### deal_product

| Column | Type | Keys |
| --- | --- | --- |
| product_name | Unknown | PK |
| deal_id | Unknown | PK, FK |
| product_after_price_amount | Unknown |  |
| product_after_price_currency | Unknown |  |
| product_before_price_amount | Unknown |  |
| product_before_price_currency | Unknown |  |
| product_image_url | Unknown |  |

### deal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| bogo_buy_image_url | Unknown |  |
| bogo_buy_name | Unknown |  |
| bogo_buy_quantity | Unknown |  |
| bogo_buy_scope | Unknown |  |
| bogo_get_discount_amount | Unknown |  |
| bogo_get_discount_currency | Unknown |  |
| bogo_get_discount_percent | Unknown |  |
| bogo_get_discount_type | Unknown |  |
| bogo_get_image_url | Unknown |  |
| bogo_get_name | Unknown |  |
| bogo_get_quantity | Unknown |  |
| bogo_get_scope | Unknown |  |
| categories | Unknown |  |
| default_promo_code | Unknown |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| discount_currency | Unknown |  |
| discount_maximum_percent | Unknown |  |
| discount_percent | Unknown |  |
| discount_percent_range_end | Unknown |  |
| discount_percent_range_start | Unknown |  |
| discount_type | Unknown |  |
| end_date | Unknown |  |
| gift | Unknown |  |
| maximum_savings_amount | Unknown |  |
| maximum_savings_currency | Unknown |  |
| minimum_purchase_amount | Unknown |  |
| minimum_purchase_amount_currency | Unknown |  |
| name | Unknown |  |
| purchase_limit_quantity | Unknown |  |
| rebate_amount | Unknown |  |
| rebate_currency | Unknown |  |
| restricted_media_partner_groups | Json |  |
| restricted_media_partners | Json |  |
| scope | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |
| synch_ads_promo_codes | Unknown |  |
| type | Unknown |  |

### ftp_submission

| Column | Type | Keys |
| --- | --- | --- |
| batch_id | Unknown | PK |
| account_id | Unknown |  |
| completion_date | Unknown |  |
| errors_uri | Unknown |  |
| file_name | Unknown |  |
| status | Unknown |  |
| submission_date | Unknown |  |
| total_errors | Unknown |  |
| total_records | Unknown |  |
| type | Unknown |  |

### performance_by_day

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK |
| date_display | Instant | PK |
| action_cost | Unknown |  |
| actions | Unknown |  |
| calls | Unknown |  |
| clickc_cost | Unknown |  |
| clicks | Unknown |  |
| cpc | Unknown |  |
| cpc_cost | Unknown |  |
| date_sort | Unknown |  |
| impressions | Unknown |  |
| media_count | Unknown |  |
| other_cost | Unknown |  |
| revenue | Unknown |  |
| total_cost | Unknown |  |

### tracking_value_promo_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| tracking_value_request_id | Unknown | PK, FK |

### tracking_value_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| deal_id | Unknown | FK |
| media_partner_id | Unknown | FK |
| additional_instructions | Unknown |  |
| bogo_buy_image_url | Unknown |  |
| bogo_buy_name | Unknown |  |
| bogo_buy_quantity | Unknown |  |
| bogo_buy_scope | Unknown |  |
| bogo_get_discount_amount | Unknown |  |
| bogo_get_discount_currency | Unknown |  |
| bogo_get_discount_percent | Unknown |  |
| bogo_get_discount_type | Unknown |  |
| bogo_get_image_url | Unknown |  |
| bogo_get_name | Unknown |  |
| bogo_get_quantity | Unknown |  |
| bogo_get_scope | Unknown |  |
| campaign_name | Unknown |  |
| date_completed | Unknown |  |
| date_needed | Unknown |  |
| date_placed | Unknown |  |
| deal_categories | Unknown |  |
| deal_default_promo_code | Unknown |  |
| deal_description | Unknown |  |
| deal_end_date | Unknown |  |
| deal_name | Unknown |  |
| deal_products | Json |  |
| deal_restricted_media_partner_groups | Json |  |
| deal_restricted_media_partners | Json |  |
| deal_scope | Unknown |  |
| deal_start_date | Unknown |  |
| deal_state | Unknown |  |
| deal_type | Unknown |  |
| discount_amount | Unknown |  |
| discount_currency | Unknown |  |
| discount_maximum_percent | Unknown |  |
| discount_percent | Unknown |  |
| discount_percent_range_end | Unknown |  |
| discount_percent_range_start | Unknown |  |
| discount_type | Unknown |  |
| gift | Unknown |  |
| maximum_savings_amount | Unknown |  |
| maximum_savings_currency | Unknown |  |
| media_partner_name | Unknown |  |
| minimum_purchase_amount | Unknown |  |
| minimum_purchase_amount_currency | Unknown |  |
| number_requested | Unknown |  |
| phone_numbers | Json |  |
| processing_comments | Unknown |  |
| purchase_limit_quantity | Unknown |  |
| rebate_amount | Unknown |  |
| rebate_currency | Unknown |  |
| request_type | Unknown |  |
| state | Unknown |  |
| synch_ads_promo_codes | Unknown |  |
| unique_urls | Json |  |

### partner_group_media_partner

| Column | Type | Keys |
| --- | --- | --- |
| partner_group_id | Unknown | PK, FK |
| partner_id | Unknown | PK, FK |

### partner_group

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

### action_locking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ad_id | Unknown | FK |
| campaign_id | Unknown | FK |
| media_partner_id | Unknown | FK |
| action_tracker_id | Unknown |  |
| action_tracker_name | Unknown |  |
| amount | Unknown |  |
| caller_id | String |  |
| campaign_name | Unknown |  |
| cleared_date | String |  |
| client_cost | Unknown |  |
| creation_date | Unknown |  |
| currency | Unknown |  |
| customer_area | Unknown |  |
| customer_city | Unknown |  |
| customer_country | Unknown |  |
| customer_id | Unknown |  |
| customer_post_code | String |  |
| customer_region | Unknown |  |
| customer_status | String |  |
| delta_amount | Unknown |  |
| delta_payout | Unknown |  |
| event_code | String |  |
| event_date | Unknown |  |
| intended_amount | Unknown |  |
| intended_payout | Unknown |  |
| ip_address | Unknown |  |
| locking_date | Unknown |  |
| media_partner_name | Unknown |  |
| note | String |  |
| o_id | Unknown |  |
| payout | Unknown |  |
| promo_code | Unknown |  |
| referring_date | Unknown |  |
| referring_domain | Unknown |  |
| referring_type | Unknown |  |
| shared_id | Unknown |  |
| state | Unknown |  |

### action_inquery_comment

| Column | Type | Keys |
| --- | --- | --- |
| user_name | Unknown | PK |
| action_inquery_id | Unknown | PK, FK |
| comment | Unknown |  |
| date | Unknown |  |

### action_inquery

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| action_id | Unknown | FK |
| campaign_id | Unknown | FK |
| media_partner_id | Unknown | FK |
| action_uri | Unknown |  |
| auto_approval_date | Unknown |  |
| campaign_name | Unknown |  |
| creation_date | Unknown |  |
| expected_payout | Unknown |  |
| final_payout | Unknown |  |
| inquiry_type | Unknown |  |
| media_partner_name | Unknown |  |
| order_id | Unknown |  |
| reject_reason | Unknown |  |
| resolution_date | Unknown |  |
| resolution_deadline_date | Unknown |  |
| resolution_status | Unknown |  |
| tracking_link | Unknown |  |
| transaction_amount | Unknown |  |
| transaction_date | Unknown |  |

### action_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ad_id | Unknown | FK |
| campaign_id | Unknown | FK |
| media_partner_id | Unknown | FK |
| action_tracker_id | Unknown |  |
| action_tracker_name | Unknown |  |
| amount | Unknown |  |
| caller_id | String |  |
| campaign_name | Unknown |  |
| cleared_date | String |  |
| client_cost | Unknown |  |
| creation_date | Unknown |  |
| currency | Unknown |  |
| customer_area | Unknown |  |
| customer_city | Unknown |  |
| customer_country | Unknown |  |
| customer_id | Unknown |  |
| customer_post_code | String |  |
| customer_region | Unknown |  |
| customer_status | String |  |
| delta_amount | Unknown |  |
| delta_payout | Unknown |  |
| event_code | String |  |
| event_date | Unknown |  |
| intended_amount | Unknown |  |
| intended_payout | Unknown |  |
| ip_address | Unknown |  |
| locking_date | Unknown |  |
| media_partner_name | Unknown |  |
| note | String |  |
| o_id | Unknown |  |
| payout | Unknown |  |
| promo_code | Unknown |  |
| referring_date | Unknown |  |
| referring_domain | Unknown |  |
| referring_type | Unknown |  |
| shared_id | Unknown |  |
| state | Unknown |  |

### performance_by_partner

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK |
| media | Unknown | PK |
| action_cost | Unknown |  |
| actions | Unknown |  |
| calls | Unknown |  |
| click_cost | Unknown |  |
| clicks | Unknown |  |
| country | Unknown |  |
| cpc | Unknown |  |
| cpc_cost | Unknown |  |
| impressions | Unknown |  |
| mediatype | Unknown |  |
| other_cost | Unknown |  |
| platform | Unknown |  |
| relationship | Unknown |  |
| revenue | Unknown |  |
| state | Unknown |  |
| total_cost | Unknown |  |

### partner_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partner_id | Unknown | PK, FK |
| dlu | Unknown |  |
| doe | Unknown |  |
| name | Unknown |  |
| platform | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### partner_promotional_category

| Column | Type | Keys |
| --- | --- | --- |
| promotional_category | Unknown | PK |
| partner_id | Unknown | PK, FK |

### partner_program_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK |
| partner_program_id | Unknown | PK, FK |
| group_name | Unknown |  |

### partner_program

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partner_id | Unknown | PK, FK |
| contract_id | Unknown | FK |
| contract_name | Unknown |  |
| expiration_date | Unknown |  |
| join_date | Unknown |  |
| name | Unknown |  |

### partner_contact_phone

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| partner_contact_email | Unknown | FK |
| partner_contact_partner_id | Unknown | FK |
| country | Unknown |  |
| number | Unknown |  |
| type | Unknown |  |

### partner_contact

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| partner_id | Unknown | PK, FK |
| first_name | Unknown |  |
| is_primary | Boolean |  |
| labels | Json |  |
| last_name | Unknown |  |

### partner_linked_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partner_id | Unknown | PK, FK |
| date | Unknown |  |
| reason | Unknown |  |

### partner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_manager | Unknown |  |
| address_address_1 | Unknown |  |
| address_address_2 | Unknown |  |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| created_by | Unknown |  |
| currency | Unknown |  |
| date_created | Unknown |  |
| date_last_updated | Unknown |  |
| description | Unknown |  |
| indirect_tax_country | Unknown |  |
| indirect_tax_number | Unknown |  |
| last_updated_by | Unknown |  |
| name | Unknown |  |
| partner_type | Unknown |  |
| partner_values_value_1 | Unknown |  |
| partner_values_value_2 | Unknown |  |
| partner_values_value_3 | Unknown |  |
| phone_country | Unknown |  |
| phone_number | Unknown |  |
| promoting_country | Unknown |  |
| promotional_method | Unknown |  |
| state | Unknown |  |
| timezone | Unknown |  |
| website | Unknown |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| invoice_id | Unknown | PK, FK |
| actions | Unknown |  |
| campaign_name | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| event_month_year | Unknown |  |
| net_item_amount | Unknown |  |
| paid_date | Unknown |  |
| status | Unknown |  |
| total_item_amount | Unknown |  |
| vat_item_amount | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_date | Unknown |  |
| currency | Unknown |  |
| media_id | Unknown |  |
| media_name | Unknown |  |
| pdf | Unknown |  |
| total_amount | Unknown |  |
| total_vat_amount | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| company_name | Unknown | PK |
| billing_address_address_line_1 | Unknown |  |
| billing_address_address_line_2 | Unknown |  |
| billing_address_city | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_postal_code | Unknown |  |
| billing_address_state | Unknown |  |
| commercial_contact_cell_phone_number | Unknown |  |
| commercial_contact_cell_phone_number_country | Unknown |  |
| commercial_contact_email | Unknown |  |
| commercial_contact_name | Unknown |  |
| commercial_contact_user_id | Unknown |  |
| commercial_contact_work_phone_number | Unknown |  |
| commercial_contact_work_phone_number_country | Unknown |  |
| corporate_address_address_line_1 | Unknown |  |
| corporate_address_address_line_2 | Unknown |  |
| corporate_address_city | Unknown |  |
| corporate_address_country | Unknown |  |
| corporate_address_postal_code | Unknown |  |
| corporate_address_state | Unknown |  |
| currency | Unknown |  |
| ein_ssn_foreign_tax_id | Unknown |  |
| financial_contact_cell_phone_number | Unknown |  |
| financial_contact_cell_phone_number_country | Unknown |  |
| financial_contact_email | Unknown |  |
| financial_contact_name | Unknown |  |
| financial_contact_user_id | Unknown |  |
| financial_contact_work_phone_number | Unknown |  |
| financial_contact_work_phone_number_country | Unknown |  |
| indirect_tax_number | Unknown |  |
| industry_industry_id | Unknown |  |
| industry_industry_name | Unknown |  |
| minimum_contact_rating | Unknown |  |
| organization_type | Unknown |  |
| primary_phone_number | Unknown |  |
| primary_phone_number_country | Unknown |  |
| primary_promotional_method | Unknown |  |
| promotional_methods | Unknown |  |
| registered_for_indirect_tax | Unknown |  |
| secondary_phone_number | Unknown |  |
| secondary_phone_number_country | Unknown |  |
| technical_contact_cell_phone_number | Unknown |  |
| technical_contact_cell_phone_number_country | Unknown |  |
| technical_contact_email | Unknown |  |
| technical_contact_name | Unknown |  |
| technical_contact_user_id | Unknown |  |
| technical_contact_work_phone_number | Unknown |  |
| technical_contact_work_phone_number_country | Unknown |  |
| timezone | Unknown |  |
| website | Unknown |  |

### adv_performance_by_ad_media_date

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| actions | Unknown |  |
| actions_cost | Unknown |  |
| ad_id | Unknown |  |
| ad_name | Unknown |  |
| ad_type | Unknown |  |
| calls | Unknown |  |
| click_cost | Unknown |  |
| clicks | Unknown |  |
| client_cost | Unknown |  |
| cpc | Unknown |  |
| cpc_cost | Unknown |  |
| date | Unknown |  |
| impressions | Unknown |  |
| landing_page | Unknown |  |
| media | Unknown |  |
| media_id | Unknown |  |
| raw_impressions | Unknown |  |
| revenue | Unknown |  |
| total_cost | Unknown |  |
| viewable_impressions | Unknown |  |

## Relationships

- routing_rule_condition_value(routing_rule_condition_variable) → routing_rule_condition(variable)
- routing_rule_condition_value(routing_rule_condition_routing_rule_id) → routing_rule_condition(routing_rule_id)
- routing_rule_condition(routing_rule_id) → routing_rule(id)
- routing_rule(campaign_id) → campaign(id)
- promo_code(deal_id) → deal(id)
- promo_code(campaign_id) → campaign(id)
- promo_code(assigned_partner_id) → partner(id)
- contact_account(contact_id) → contact(id)
- contact_label(contact_id) → contact(id)
- contact(campaign_id) → campaign(id)
- contract_event_valid_referral(contract_event_payout_event_type_id) → contract_event_payout(event_type_id)
- contract_payout_group_rule_value(contract_payout_group_rule_variable) → contract_payout_group_rule(variable)
- contract_payout_group_rule_value(contract_payout_group_rule_contract_event_payout_group_id) → contract_payout_group_rule(contract_event_payout_group_id)
- contract_payout_group_rule(contract_event_payout_group_id) → contract_event_payout_group(id)
- contract_payout_group_limit(contract_event_payout_group_id) → contract_event_payout_group(id)
- contract_event_payout_group(contract_event_payout_event_type_id) → contract_event_payout(event_type_id)
- contract_payout_adjustment_rule_value(contract_payout_adjustment_rule_variable) → contract_payout_adjustment_rule(variable)
- contract_payout_adjustment_rule_value(contract_event_payout_adjustment_id) → contract_payout_adjustment_rule(contract_event_payout_adjustment_id)
- contract_payout_adjustment_rule(contract_event_payout_adjustment_id) → contract_event_payout_adjustment(id)
- contract_event_payout_adjustment(contract_event_payout_event_type_id) → contract_event_payout(event_type_id)
- contract_event_payout_tier(contract_event_payout_event_type_id) → contract_event_payout(event_type_id)
- contract_event_payout_restriction_rule_value(contract_event_payout_restriction_rule_variable) → contract_event_payout_restriction_rule(variable)
- contract_event_payout_restriction_rule_value(contract_event_payout_restriction_id) → contract_event_payout_restriction_rule(contract_event_payout_restriction_id)
- contract_event_payout_restriction_rule(contract_event_payout_restriction_id) → contract_event_payout_restriction(id)
- contract_event_payout_restriction(contract_event_payout_event_type_id) → contract_event_payout(event_type_id)
- contract_event_payout_limit(contract_event_payout_event_type_id) → contract_event_payout(event_type_id)
- contract_event_payout_special_term(contract_event_payout_event_type_id) → contract_event_payout(event_type_id)
- contract_event_payout(contract_id) → contract(id)
- contract_label(contract_id) → contract(id)
- contract(partner_id) → partner(id)
- contract(campaign_id) → campaign(id)
- ads(deal_id) → deal(id)
- ads(campaign_id) → campaign(id)
- task_comment(task_id) → task(id)
- campaign_primary_category(campaign_id) → campaign(id)
- campaign_company_contact(campaign_id) → campaign(id)
- campaign_shipping_region(campaign_id) → campaign(id)
- exception_action_tracker(id) → action_locking(id)
- exception_action_tracker(exception_list_id) → exception_list(id)
- exception_list(campaign_id) → campaign(id)
- note(campaign_id) → campaign(id)
- deal_product(deal_id) → deal(id)
- deal(campaign_id) → campaign(id)
- tracking_value_promo_code(id) → promo_code(id)
- tracking_value_promo_code(tracking_value_request_id) → tracking_value_request(id)
- tracking_value_request(deal_id) → deal(id)
- tracking_value_request(campaign_id) → campaign(id)
- tracking_value_request(media_partner_id) → partner(id)
- partner_group_media_partner(partner_id) → partner(id)
- partner_group_media_partner(partner_group_id) → partner_group(id)
- partner_group(campaign_id) → campaign(id)
- action_locking(campaign_id) → campaign(id)
- action_locking(ad_id) → ads(id)
- action_locking(media_partner_id) → partner(id)
- action_inquery_comment(action_inquery_id) → action_inquery(id)
- action_inquery(campaign_id) → campaign(id)
- action_inquery(action_id) → action_locking(id)
- action_inquery(media_partner_id) → partner(id)
- action_event(campaign_id) → campaign(id)
- action_event(ad_id) → ads(id)
- action_event(media_partner_id) → partner(id)
- partner_property(partner_id) → partner(id)
- partner_promotional_category(partner_id) → partner(id)
- partner_program_group(partner_program_id) → partner_program(id)
- partner_program(contract_id) → contract(id)
- partner_program(partner_id) → partner(id)
- partner_contact_phone(partner_contact_email) → partner_contact(email)
- partner_contact_phone(partner_contact_partner_id) → partner_contact(partner_id)
- partner_contact(partner_id) → partner(id)
- partner_linked_account(partner_id) → partner(id)
- invoice_line_item(campaign_id) → campaign(id)
- invoice_line_item(invoice_id) → invoice(id)
- adv_performance_by_ad_media_date(campaign_id) → campaign(id)