# Everflow schema ERD

Table and field reference for the Fivetran Everflow connector.

## Table & Field Reference

### affiliate_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_id | Unknown | FK |
| account_status | Unknown |  |
| cell_phone | Unknown |  |
| currency_id | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| instant_messaging_id | Unknown |  |
| instant_messaging_identifier | Unknown |  |
| language_id | Unknown |  |
| last_name | Unknown |  |
| relationship_affiliate_account_status | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| timezone_id | Unknown |  |
| title | Unknown |  |
| work_phone | Unknown |  |

### offer_ruleset_postal_code

| Column | Type | Keys |
| --- | --- | --- |
| network_id | Unknown | PK |
| network_targeting_postal_code_id | Unknown | PK |
| offer_id | Unknown | PK, FK |
| label | Unknown |  |
| match_type | Unknown |  |
| postal_code | Unknown |  |
| targeting_type | Unknown |  |

### offer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| network_offer_group_id | Unknown | FK |
| category | Unknown |  |
| channels | Unknown |  |
| currency_id | Unknown |  |
| daily_click_cap | Unknown |  |
| daily_conversion_cap | Unknown |  |
| daily_payout_cap | Unknown |  |
| daily_revenue_cap | Unknown |  |
| destination_url | Unknown |  |
| encoded_value | Unknown |  |
| global_click_cap | Unknown |  |
| global_conversion_cap | Unknown |  |
| global_payout_cap | Unknown |  |
| global_revenue_cap | Unknown |  |
| is_force_terms_and_conditions | Unknown |  |
| labels | Json |  |
| monthly_click_cap | Unknown |  |
| monthly_conversion_cap | Unknown |  |
| monthly_payout_cap | Unknown |  |
| monthly_revenue_cap | Unknown |  |
| name | Unknown |  |
| network_advertiser_name | Unknown |  |
| network_id | Unknown |  |
| offer_status | Unknown |  |
| optimized_thumbnail_url | Unknown |  |
| payout | Unknown |  |
| payout_amount | Unknown |  |
| payout_percentage | Unknown |  |
| payout_type | Unknown |  |
| project_id | Unknown |  |
| remaining_daily_click_cap | Unknown |  |
| remaining_daily_conversion_cap | Unknown |  |
| remaining_daily_payout_cap | Unknown |  |
| remaining_daily_revenue_cap | Unknown |  |
| remaining_global_click_cap | Unknown |  |
| remaining_global_conversion_cap | Unknown |  |
| remaining_global_payout_cap | Unknown |  |
| remaining_global_revenue_cap | Unknown |  |
| remaining_monthly_click_cap | Unknown |  |
| remaining_monthly_conversion_cap | Unknown |  |
| remaining_monthly_payout_cap | Unknown |  |
| remaining_monthly_revenue_cap | Unknown |  |
| remaining_weekly_click_cap | Unknown |  |
| remaining_weekly_conversion_cap | Unknown |  |
| remaining_weekly_payout_cap | Unknown |  |
| remaining_weekly_revenue_cap | Unknown |  |
| revenue | Unknown |  |
| revenue_amount | Unknown |  |
| revenue_percentage | Unknown |  |
| revenue_type | Unknown |  |
| ruleset_brands | Json |  |
| ruleset_browsers | Json |  |
| ruleset_cities | Json |  |
| ruleset_connection_types | Json |  |
| ruleset_countries | Json |  |
| ruleset_day_parting_apply_to | Unknown |  |
| ruleset_day_parting_timezone_id | Unknown |  |
| ruleset_days_parting | Json |  |
| ruleset_device_types | Json |  |
| ruleset_dmas | Json |  |
| ruleset_ips | Json |  |
| ruleset_is_block_proxy | Unknown |  |
| ruleset_is_use_day_parting | Unknown |  |
| ruleset_isps | Json |  |
| ruleset_languages | Json |  |
| ruleset_mobile_carriers | Json |  |
| ruleset_network_id | Unknown |  |
| ruleset_network_ruleset_id | Unknown |  |
| ruleset_os_versions | Json |  |
| ruleset_platforms | Json |  |
| ruleset_regions | Json |  |
| ruleset_time_created | Unknown |  |
| ruleset_time_saved | Unknown |  |
| thumbnail_url | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| today_clicks | Unknown |  |
| today_payout_amount | Unknown |  |
| today_revenue | Unknown |  |
| today_revenue_amount | Unknown |  |
| visibility | Unknown |  |
| weekly_click_cap | Unknown |  |
| weekly_conversion_cap | Unknown |  |
| weekly_payout_cap | Unknown |  |
| weekly_revenue_cap | Unknown |  |

### creative

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| network_offer_id | Unknown | FK |
| creative_status | Unknown |  |
| creative_type | Unknown |  |
| email_from | Unknown |  |
| email_from_line | Unknown |  |
| email_subject | Unknown |  |
| email_subject_line | Unknown |  |
| height | Unknown |  |
| html_code | Unknown |  |
| is_private | Unknown |  |
| name | Unknown |  |
| optimized_thumbnail_url | Unknown |  |
| resource_url | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| width | Unknown |  |

### traffic_control_affiliate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| traffic_control_id | Unknown | PK, FK |
| affiliate_id | Unknown | FK |

### traffic_control_advertiser

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| traffic_control_id | Unknown | PK, FK |
| advertiser_id | Unknown | FK |

### traffic_control_offer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| traffic_control_id | Unknown | PK, FK |
| network_offer_id | Unknown | FK |

### traffic_control

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comparison_method | Unknown |  |
| control_type | Unknown |  |
| date_valid_from | Unknown |  |
| date_valid_to | Unknown |  |
| is_apply_all_affiliate | Unknown |  |
| is_apply_all_offer | Unknown |  |
| name | Unknown |  |
| network_id | Unknown |  |
| status | Unknown |  |
| targeting_action | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| variables | Json |  |

### conversion_report

| Column | Type | Keys |
| --- | --- | --- |
| conversion_id | Unknown | PK |
| advertiser_id | Unknown | FK |
| affiliate_id | Unknown | FK |
| network_offer_id | Unknown | FK |
| network_offer_url_id | Unknown | FK |
| account_manager_account_status | Unknown |  |
| account_manager_employee_id | Unknown |  |
| account_manager_first_name | Unknown |  |
| account_manager_full_name | Unknown |  |
| account_manager_last_name | Unknown |  |
| account_manager_network_id | Unknown |  |
| adv_1 | Unknown |  |
| adv_2 | Unknown |  |
| adv_3 | Unknown |  |
| adv_4 | Unknown |  |
| adv_5 | Unknown |  |
| affiliate_manager_account_status | Unknown |  |
| affiliate_manager_employee_id | Unknown |  |
| affiliate_manager_first_name | Unknown |  |
| affiliate_manager_full_name | Unknown |  |
| affiliate_manager_last_name | Unknown |  |
| affiliate_manager_network_id | Unknown |  |
| android_id | Unknown |  |
| android_id_md_5 | Unknown |  |
| android_id_sha_1 | Unknown |  |
| app_id | Unknown |  |
| brand | Unknown |  |
| browser | Unknown |  |
| carrier | Unknown |  |
| city | Unknown |  |
| click_unix_timestamp | Unknown |  |
| conversion_unix_timestamp | Unknown |  |
| conversion_user_ip | Unknown |  |
| country | Unknown |  |
| coupon_code | Unknown |  |
| currency_id | Unknown |  |
| device_model | Unknown |  |
| device_type | Unknown |  |
| dma | Unknown |  |
| email | Unknown |  |
| error_code | Unknown |  |
| error_message | Unknown |  |
| event | Unknown |  |
| google_ad_id | Unknown |  |
| google_ad_id_md_5 | Unknown |  |
| google_ad_id_sha_1 | Unknown |  |
| http_user_agent | Unknown |  |
| idfa | Unknown |  |
| idfa_md_5 | Unknown |  |
| idfa_sha_1 | Unknown |  |
| is_event | Unknown |  |
| is_scrub | Unknown |  |
| is_view_through | Unknown |  |
| isp | Unknown |  |
| languages | Unknown |  |
| network_offer_payout_revenue_id | Unknown |  |
| notes | Unknown |  |
| order_id | Unknown |  |
| os_version | Unknown |  |
| payout | Unknown |  |
| payout_type | Unknown |  |
| platform | Unknown |  |
| previous_network_offer_id | Unknown |  |
| referer | Unknown |  |
| region | Unknown |  |
| relationship_attribution_method | Unknown |  |
| relationship_query_parameters | Unknown |  |
| relationship_usm_data | Unknown |  |
| revenue | Unknown |  |
| revenue_type | Unknown |  |
| sale_amount | Unknown |  |
| session_user_ip | Unknown |  |
| source_id | Unknown |  |
| status | Unknown |  |
| sub_1 | Unknown |  |
| sub_2 | Unknown |  |
| sub_3 | Unknown |  |
| sub_4 | Unknown |  |
| sub_5 | Unknown |  |
| transaction_id | Unknown |  |
| url | Unknown |  |

### custom_cap

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_id | Unknown | FK |
| network_offer_id | Unknown | FK |
| daily_click_cap | Unknown |  |
| daily_conversion_cap | Unknown |  |
| daily_payout_cap | Unknown |  |
| daily_revenue_cap | Unknown |  |
| global_click_cap | Unknown |  |
| global_conversion_cap | Unknown |  |
| global_payout_cap | Unknown |  |
| global_revenue_cap | Unknown |  |
| is_soft_cap | Unknown |  |
| monthly_click_cap | Unknown |  |
| monthly_conversion_cap | Unknown |  |
| monthly_payout_cap | Unknown |  |
| monthly_revenue_cap | Unknown |  |
| name | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| weekly_click_cap | Unknown |  |
| weekly_conversion_cap | Unknown |  |
| weekly_payout_cap | Unknown |  |
| weekly_revenue_cap | Unknown |  |

### affiliate_tracking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_id | Unknown | FK |
| network_offer_id | Unknown | FK |
| domain_status | Unknown |  |
| html_static_redirect | Unknown |  |
| is_apply_all_offer | Unknown |  |
| is_primary_domain | Unknown |  |
| is_ssl_enabled | Unknown |  |
| network_tracking_domain_id | Unknown |  |
| ownership | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| url | Unknown |  |
| url_redirect | Unknown |  |

### advertiser_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| account_status | Unknown |  |
| cell_phone | Unknown |  |
| currency_id | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| instant_messaging_id | Unknown |  |
| instant_messaging_identifier | Unknown |  |
| language_id | Unknown |  |
| last_name | Unknown |  |
| relationship | Json |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| timezone_id | Unknown |  |
| title | Unknown |  |
| work_phone | Unknown |  |

### custom_scrubrate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_id | Unknown | FK |
| network_offer_id | Unknown | FK |
| custom_setting_status | Unknown |  |
| name | Unknown |  |
| ruleset_brands | Json |  |
| ruleset_browsers | Json |  |
| ruleset_cities | Json |  |
| ruleset_connection_types | Json |  |
| ruleset_countries | Json |  |
| ruleset_day_parting_apply_to | Unknown |  |
| ruleset_day_parting_timezone_id | Unknown |  |
| ruleset_days_parting | Json |  |
| ruleset_device_types | Json |  |
| ruleset_dmas | Json |  |
| ruleset_ips | Json |  |
| ruleset_is_block_proxy | Unknown |  |
| ruleset_is_use_day_parting | Unknown |  |
| ruleset_isps | Json |  |
| ruleset_languages | Json |  |
| ruleset_mobile_carriers | Json |  |
| ruleset_network_id | Unknown |  |
| ruleset_network_ruleset_id | Unknown |  |
| ruleset_os_versions | Json |  |
| ruleset_platforms | Json |  |
| ruleset_postal_codes | Json |  |
| ruleset_regions | Json |  |
| ruleset_time_created | Unknown |  |
| ruleset_time_saved | Unknown |  |
| scrub_rate_percentage | Unknown |  |
| scrub_rate_status | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |

### offer_application

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| affiliate_id | Unknown | FK |
| network_affiliate_user_id | Unknown | FK |
| network_offer_id | Unknown | FK |
| application_status | Unknown |  |
| relationship_employee_account_status | Unknown |  |
| relationship_employee_first_name | Unknown |  |
| relationship_employee_full_name | Unknown |  |
| relationship_employee_last_name | Unknown |  |
| relationship_employee_network_employee_id | Unknown |  |
| relationship_employee_network_id | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |

### advertiser_relationship_entry

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| advertiser_id | Unknown | PK, FK |
| entry | Unknown |  |

### advertiser

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_manager_cell_phone | Unknown |  |
| account_manager_email | Unknown |  |
| account_manager_first_name | Unknown |  |
| account_manager_instant_messaging_id | Unknown |  |
| account_manager_instant_messaging_identifier | Unknown |  |
| account_manager_last_name | Unknown |  |
| account_manager_work_phone | Unknown |  |
| account_status | Unknown |  |
| accounting_contact_email | Unknown |  |
| address_id | Unknown |  |
| affiliate_id_macro | Unknown |  |
| attribution_method | Unknown |  |
| contact_address_1 | Unknown |  |
| contact_address_2 | Unknown |  |
| contact_address_id | Unknown |  |
| contact_city | Unknown |  |
| contact_country_code | Unknown |  |
| contact_country_id | Unknown |  |
| contact_region_code | Unknown |  |
| contact_zip_postal_code | Unknown |  |
| default_currency_id | Unknown |  |
| email_attribution_method | Unknown |  |
| integration_advertiser_demand_partner | Unknown |  |
| integration_optizmo | Unknown |  |
| internal_note | Unknown |  |
| is_contact_address_enabled | Unknown |  |
| is_expose_publisher_reporting_data | Unknown |  |
| name | Unknown |  |
| network_employee_id | Unknown |  |
| network_id | Unknown |  |
| offer_id_macro | Unknown |  |
| platform_name | Unknown |  |
| platform_url | Unknown |  |
| platform_username | Unknown |  |
| reporting_timezone_id | Unknown |  |
| sale_manager_cell_phone | Unknown |  |
| sale_manager_email | Unknown |  |
| sale_manager_first_name | Unknown |  |
| sale_manager_instant_messaging_id | Unknown |  |
| sale_manager_instant_messaging_identifier | Unknown |  |
| sale_manager_last_name | Unknown |  |
| sale_manager_work_phone | Unknown |  |
| sales_manager_id | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| verification_token | Unknown |  |

### offer_url

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| network_offer_id | Unknown | FK |
| destination_url | Unknown |  |
| is_apply_specific_affiliate | Unknown |  |
| is_hidden_affiliate | Unknown |  |
| name | Unknown |  |
| network_affiliate_ids | Json |  |
| preview_url | Unknown |  |
| remote_json_config | Unknown |  |
| remote_json_data | Unknown |  |
| remote_last_value_md_5 | Unknown |  |
| remote_network_id | Unknown |  |
| remote_network_offer_id | Unknown |  |
| remote_remote_resource_id | Unknown |  |
| remote_resource_id | Unknown |  |
| remote_resource_type | Unknown |  |
| remote_time_created | Unknown |  |
| remote_time_saved | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| url_status | Unknown |  |

### affiliate_tier_network_affiliate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| affiliate_tier_id | Unknown | PK, FK |
| affiliate_id | Unknown | FK |

### affiliate_tier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| is_default_tier | Unknown |  |
| name | Unknown |  |
| network_id | Unknown |  |
| payout_margin | Unknown |  |
| status | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |

### affiliate_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| affiliate_id | Unknown | PK, FK |
| label | Unknown |  |

### affiliate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_executive_id | Unknown |  |
| account_executive_name | Unknown |  |
| account_manager_id | Unknown |  |
| account_manager_name | Unknown |  |
| account_status | Unknown |  |
| balance | Unknown |  |
| global_tracking_domain_url | Unknown |  |
| is_payable | Unknown |  |
| last_login | Unknown |  |
| name | Unknown |  |
| network_country_code | Unknown |  |
| network_id | Unknown |  |
| network_traffic_source_id | Unknown |  |
| payment_term | Unknown |  |
| payment_type | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| today_revenue | Unknown |  |

### offer_group_network_offer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| offer_group_id | Unknown | PK, FK |
| network_offer_id | Unknown | FK |

### offer_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| daily_click_cap | Unknown |  |
| daily_conversion_cap | Unknown |  |
| daily_payout_cap | Unknown |  |
| daily_revenue_cap | Unknown |  |
| entries | Json |  |
| global_click_cap | Unknown |  |
| global_conversion_cap | Unknown |  |
| global_payout_cap | Unknown |  |
| global_revenue_cap | Unknown |  |
| internal_note | Unknown |  |
| is_caps_enabled | Unknown |  |
| is_soft_cap | Unknown |  |
| monthly_click_cap | Unknown |  |
| monthly_conversion_cap | Unknown |  |
| monthly_payout_cap | Unknown |  |
| monthly_revenue_cap | Unknown |  |
| name | Unknown |  |
| offer_group_status | Unknown |  |
| remaining_daily_click_cap | Unknown |  |
| remaining_daily_conversion_cap | Unknown |  |
| remaining_daily_payout_cap | Unknown |  |
| remaining_daily_revenue_cap | Unknown |  |
| remaining_global_click_cap | Unknown |  |
| remaining_global_conversion_cap | Unknown |  |
| remaining_global_payout_cap | Unknown |  |
| remaining_global_revenue_cap | Unknown |  |
| remaining_monthly_click_cap | Unknown |  |
| remaining_monthly_conversion_cap | Unknown |  |
| remaining_monthly_payout_cap | Unknown |  |
| remaining_monthly_revenue_cap | Unknown |  |
| remaining_weekly_click_cap | Unknown |  |
| remaining_weekly_conversion_cap | Unknown |  |
| remaining_weekly_payout_cap | Unknown |  |
| remaining_weekly_revenue_cap | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| weekly_click_cap | Unknown |  |
| weekly_conversion_cap | Unknown |  |
| weekly_payout_cap | Unknown |  |
| weekly_revenue_cap | Unknown |  |

### smart_link_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_name | Unknown |  |
| campaign_status | Unknown |  |
| catch_all_network_offer_id | Unknown |  |
| data_collection_threshold | Unknown |  |
| data_lookback_window | Unknown |  |
| encoded_value | Unknown |  |
| is_open_to_affiliate | Unknown |  |
| is_use_secure_link | Unknown |  |
| metric | Unknown |  |
| network_id | Unknown |  |
| network_tracking_domain_id | Unknown |  |
| optimization_goal | Unknown |  |
| redirect_routing_type | Unknown |  |
| relationship_label_entries | Json |  |
| relationship_label_total | Unknown |  |
| run_frequency | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |

### business_unit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| network_id | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_id | Unknown | FK |
| affiliate_invoice_status | Unknown |  |
| balance | Unknown |  |
| billed | Unknown |  |
| currency_id | Unknown |  |
| end_time | Unknown |  |
| internal_note | Unknown |  |
| is_hidden_affiliate | Unknown |  |
| is_payable | Unknown |  |
| network_affiliate_name | Unknown |  |
| paid | Unknown |  |
| paid_date | Unknown |  |
| payment_status | Unknown |  |
| payment_term | Unknown |  |
| payment_type | Unknown |  |
| public_note | Unknown |  |
| start_time | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |
| timezone_id | Unknown |  |

### custom_payout_revenue_affiliate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| custom_payout_revenue_id | Unknown | PK, FK |
| affiliate_id | Unknown | FK |

### custom_payout_revenue_entry

| Column | Type | Keys |
| --- | --- | --- |
| affiliate_id | Unknown | PK, FK |
| custom_payout_revenue_id | Unknown | PK, FK |
| account_executive_id | Unknown |  |
| account_status | Unknown |  |
| adress_id | Unknown |  |
| default_currency_id | Unknown |  |
| enable_media_cost_tracking_link | Unknown |  |
| has_notifications | Unknown |  |
| internal_note | Unknown |  |
| is_contact_address_enabled | Unknown |  |
| name | Unknown |  |
| network_employee_id | Unknown |  |
| network_traffic_source_id | Unknown |  |
| referrer_id | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |

### custom_payout_revenue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| network_offer_id | Unknown | FK |
| custom_setting_status | Unknown |  |
| date_valid_from | Unknown |  |
| date_valid_to | Unknown |  |
| description | Unknown |  |
| is_apply_all_affiliate | Unknown |  |
| is_apply_specific_offer_url | Unknown |  |
| is_custom_payout_enabled | Unknown |  |
| is_custom_revenue_enabled | Unknown |  |
| is_postback_disabled | Unknown |  |
| name | Unknown |  |
| network_offer_payout_revenue_id | Unknown |  |
| network_offer_url_ids | Unknown |  |
| payout_amount | Unknown |  |
| payout_percentage | Unknown |  |
| payout_type | Unknown |  |
| public_description | Unknown |  |
| relationship_entry_name | Unknown |  |
| relationship_global_advertiser_event_id | Unknown |  |
| relationship_is_allow_duplicate_conversion | Unknown |  |
| relationship_is_default | Unknown |  |
| relationship_is_email_attribution_default_event | Unknown |  |
| relationship_is_enforce_cap | Unknown |  |
| relationship_is_must_approve_conversion | Unknown |  |
| relationship_is_postback_disabled | Unknown |  |
| relationship_is_private | Unknown |  |
| relationship_network_offer_payout_revenue_id | Unknown |  |
| relationship_payout_amount | Unknown |  |
| relationship_payout_percentage | Unknown |  |
| relationship_payout_type | Unknown |  |
| relationship_remote_offer_resource | Json |  |
| relationship_revenue_amount | Unknown |  |
| relationship_revenue_percentage | Unknown |  |
| relationship_revenue_type | Unknown |  |
| relationship_time_created | Unknown |  |
| revenue_amount | Unknown |  |
| revenue_percentage | Unknown |  |
| revenue_type | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |

### partner_postback

| Column | Type | Keys |
| --- | --- | --- |
| network_pixel_id | Unknown | PK |
| affiliate_id | Unknown | FK |
| network_offer_id | Unknown | FK |
| delay_ms | Unknown |  |
| delivery_method | Unknown |  |
| description | Unknown |  |
| network_offer_payout_revenue_id | Unknown |  |
| pixel_level | Unknown |  |
| pixel_status | Unknown |  |
| pixel_type | Unknown |  |
| postback_url | Unknown |  |
| relationship | Json |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |

### coupon_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_id | Unknown | FK |
| network_offer_id | Unknown | FK |
| coupon_code | Unknown |  |
| coupon_status | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| internal_note | Unknown |  |
| is_description_plain_text | Unknown |  |
| start_date | Unknown |  |
| time_created | Unknown |  |
| time_saved | Unknown |  |

## Relationships

- affiliate_user(affiliate_id) → affiliate(id)
- offer_ruleset_postal_code(offer_id) → offer(id)
- offer(advertiser_id) → advertiser(id)
- offer(network_offer_group_id) → offer_group(id)
- creative(network_offer_id) → offer(id)
- traffic_control_affiliate(affiliate_id) → affiliate(id)
- traffic_control_affiliate(traffic_control_id) → traffic_control(id)
- traffic_control_advertiser(advertiser_id) → advertiser(id)
- traffic_control_advertiser(traffic_control_id) → traffic_control(id)
- traffic_control_offer(network_offer_id) → offer(id)
- traffic_control_offer(traffic_control_id) → traffic_control(id)
- conversion_report(network_offer_id) → offer(id)
- conversion_report(advertiser_id) → advertiser(id)
- conversion_report(affiliate_id) → affiliate(id)
- conversion_report(network_offer_url_id) → offer_url(id)
- custom_cap(affiliate_id) → affiliate(id)
- custom_cap(network_offer_id) → offer(id)
- affiliate_tracking(affiliate_id) → affiliate(id)
- affiliate_tracking(network_offer_id) → offer(id)
- advertiser_user(advertiser_id) → advertiser(id)
- custom_scrubrate(affiliate_id) → affiliate(id)
- custom_scrubrate(network_offer_id) → offer(id)
- offer_application(affiliate_id) → affiliate(id)
- offer_application(network_offer_id) → offer(id)
- offer_application(network_affiliate_user_id) → affiliate_user(id)
- offer_application(advertiser_id) → advertiser(id)
- advertiser_relationship_entry(advertiser_id) → advertiser(id)
- offer_url(network_offer_id) → offer(id)
- affiliate_tier_network_affiliate(affiliate_id) → affiliate(id)
- affiliate_tier_network_affiliate(affiliate_tier_id) → affiliate_tier(id)
- affiliate_label(affiliate_id) → affiliate(id)
- offer_group_network_offer(network_offer_id) → offer(id)
- offer_group_network_offer(offer_group_id) → offer_group(id)
- offer_group(advertiser_id) → advertiser(id)
- invoice(affiliate_id) → affiliate(id)
- custom_payout_revenue_affiliate(affiliate_id) → affiliate(id)
- custom_payout_revenue_affiliate(custom_payout_revenue_id) → custom_payout_revenue(id)
- custom_payout_revenue_entry(affiliate_id) → affiliate(id)
- custom_payout_revenue_entry(custom_payout_revenue_id) → custom_payout_revenue(id)
- custom_payout_revenue(network_offer_id) → offer(id)
- partner_postback(affiliate_id) → affiliate(id)
- partner_postback(network_offer_id) → offer(id)
- coupon_code(affiliate_id) → affiliate(id)
- coupon_code(network_offer_id) → offer(id)