Everflow

Explore the interactive ERD

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	PKFK
`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	PKFK
`affiliate_id`	Unknown	FK

traffic_control_advertiser

Column	Type	Keys
`index`	Unknown	PK
`traffic_control_id`	Unknown	PKFK
`advertiser_id`	Unknown	FK

traffic_control_offer

Column	Type	Keys
`index`	Unknown	PK
`traffic_control_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`affiliate_id`	Unknown	FK

custom_payout_revenue_entry

Column	Type	Keys
`affiliate_id`	Unknown	PKFK
`custom_payout_revenue_id`	Unknown	PKFK
`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