Tables


SchemaSpy Analysis of russell_production

Generated on vie. jun. 05 19:34 GMT 2020

XML Representation
Insertion Order Deletion Order
TABLES 139
VIEWS 7
COLUMNS 1322
Constraints 234
Anomalies 8
Routines 2

Database Properties

Database Type: MySQL - 5.5.5-10.4.11-MariaDB

Tables

Table / View Children Parents Columns Rows Type Comments
pearch_ad_unit_code 8 3 10 0 Table
automation_log 0 0 9 0 Table
account_pearch_user 0 2 3 0 Table
bing_json_ad_group 4 3 22 0 Table
bing_json_campaign 4 3 15 0 Table
pearch_keyword 5 0 9 0 Table
google_criterion_location 1 0 8 0 Table
facebook_json_ad_set 3 3 30 0 Table
pearch_partner_market_user 0 4 7 0 Table
two_click_model 0 5 10 0 Table
facebook_json_pixel 2 1 10 0 Table
run_process 0 1 5 0 Table
ml_bid_budget_trained_model 0 1 7 0 Table
facebook_builder_ad_creative 0 1 9 0 Table
helper_currency_rate 0 2 6 0 Table
log 0 0 4 0 Table
pearch_partner_group_device 0 2 3 0 Table
dev_number 0 0 1 0 Table
facebook_json_image 0 2 13 0 Table
facebook_json_ad 0 3 13 0 Table
pearch_role 1 0 4 0 Table
pearch_network 7 1 7 0 Table
report_revenue_file_line 0 1 15 0 Table
pearch_user_optimization_filter 0 1 12 0 Table
locker 0 0 8 0 Table
google_change_log 0 7 16 0 Table
management_new_ad_google 0 2 8 0 Table
ml_bid_budget_setup 1 3 8 0 Table
pearch_network_partner_group 1 2 3 0 Table
google_json_campaign_budget 3 1 13 0 Table
pearch_tracking_code 3 2 12 0 Table
helper_structure_campaign_name 2 0 2 0 Table
helper_forbidden_keyword 0 1 6 0 Table
bing_json_ad 0 2 11 0 Table
management_new_keyword_bing 0 9 29 0 Table
report_revenue_pull_log 0 0 7 0 Table
organization 10 1 11 0 Table
pearch_image_text 0 2 6 0 Table
google_json_ad_group_criterion 0 1 9 0 Table
google_builder_expanded_text_ad 0 1 10 0 Table
pearch_keyword_image 0 4 6 0 Table
pearch_report_code_log 0 2 7 0 Table
bing_builder_expanded_text_ad 0 1 11 0 Table
google_bidding_strategy_source 0 0 2 0 Table
management_new_ad_facebook 0 2 11 0 Table
pearch_text 1 0 5 0 Table
pearch_image 5 3 20 0 Table
helper_bidding_strategy_type 5 1 7 0 Table
management_new_keyword_facebook 0 10 39 0 Table
google_json_campaign_criterion 0 1 10 0 Table
organization_user 0 2 3 0 Table
watcher 1 1 4 0 Table
report_revenue_file 1 1 8 0 Table
google_json_campaign 4 3 22 0 Table
facebook_page 2 2 10 0 Table
pearch_additional_url_parameter_partner_group 0 1 5 0 Table
google_builder_responsive_display_ad 0 1 9 0 Table
pearch_group 1 0 3 0 Table
automation 3 0 15 0 Table
facebook_scraper_ad 0 0 14 0 Table
report_breakdown 3 1 4 0 Table
facebook_call_to_action 1 0 2 0 Table
pearch_report_code 8 2 12 0 Table
bing_json_budget 3 1 8 0 Table
management_used_keyword 10 8 17 0 Table
management_account_clone 0 4 18 0 Table
google_json_ad_group_ad 0 2 14 0 Table
report_revenue_file_line_prohibited_tag 0 1 4 0 Table

Insert a tag here if you do not want to send it to Ego/Eco aka Spanish

facebook_change_log 0 6 15 0 Table
pearch_keyword_group 2 1 5 0 Table
pearch_video 2 0 10 0 Table
optimization_used_filter 3 0 3 0 Table
google_json_schema 0 0 5 0 Table
google_json_campaign_bid_modifier 0 1 7 0 Table
facebook_scraper 0 1 5 0 Table
account 29 9 25 0 Table
helper_device 2 0 3 0 Table
pearch_partner_group 9 1 19 0 Table
bing_criterion_location 1 1 6 0 Table
facebook_json_video 0 2 11 0 Table
pearch_report_code_revenue_override 0 3 8 0 Table
pearch_image_network 0 2 6 0 Table
google_json_asset 0 1 9 0 Table
google_json_ad_group 5 2 24 0 Table
account_manager 4 3 10 0 Table
report_breakdown_access 0 2 3 0 Table
management_new_keyword_request 12 2 12 0 Table
techadsmedia_adunit_tqs 0 1 8 0 Table
management_new_keyword_google 0 5 27 0 Table
report_cost 0 1 17 0 Table
report_revenue 0 1 9 0 Table
watcher_user 0 2 4 0 Table
pearch_user_group 0 2 3 0 Table
organization_report_breakdown_type 0 1 5 0 Table
pearch_keyword_video 0 3 6 0 Table
management_discovered_keyword 0 3 6 0 Table
pearch_forbidden_range 0 3 7 0 Table
bing_change_log 0 7 16 0 Table
feed 0 0 3 0 Table
facebook_json_campaign 3 2 14 0 Table
pearch_partner 7 1 8 0 Table
google_json_ad_group_bid_modifier 0 1 7 0 Table
report_tq_score 0 2 9 0 Table
helper_structure_ad_group_name 2 0 2 0 Table
pearch_user_access_restriction 0 3 4 0 Table
pearch_tracking_code_init 1 1 5 0 Table
dealer_image_ratio_code 0 1 5 0 Table
facebook_json_schema 0 0 5 0 Table
pearch_ad_unit_code_log 0 4 7 0 Table
bing_json_ad_group_criterion 0 1 7 0 Table
helper_locale_code 3 0 8 0 Table
automation_account 0 2 5 0 Table
bing_json_schema 0 0 5 0 Table
log_clean 0 0 5 0 Table
facebook_criterion_language 0 0 4 0 Table
facebook_json_ad_creative 1 1 11 0 Table
pearch_keyword_group_image 0 2 5 0 Table
pearch_user_role 0 2 4 0 Table
google_criterion_device 0 1 4 0 Table
management_new_keyword_google_precheck 0 4 25 0 Table
report_cost_account 0 1 12 0 Table
helper_country 0 0 5 0 Table
pearch_keyword_keyword_group 0 3 5 0 Table
helper_currency 4 0 3 0 Table
pearch_partner_market_log 0 2 7 0 Table
bing_json_ad_group_keyword 0 1 7 0 Table
facebook_scraper_page 0 0 7 0 Table
google_placement_metric 0 1 18 0 Table
dealer 10 0 4 0 Table
automation_rule 0 1 5 0 Table
google_criterion_language 0 0 4 0 Table
bing_json_campaign_criterion 0 1 7 0 Table
facebook_timezone 0 0 2 0 Table
___accountmanagers 0 0 7 0 Table
pearch_user 35 3 11 0 Table
automation_item 0 1 4 0 Table

This table is used to save Campaign or AdGroups remote ids.

pearch_additional_url_parameter_ad_unit 0 1 5 0 Table
report_cost_ad_type 0 0 15 0 Table
pearch_partner_market 10 2 7 0 Table
_view_discovered_keyword 0 0 5 0 View
_view_ad_unit_code 0 0 10 0 View
_view_account_partner 0 2 7 0 View
_view_facebook_page 0 2 6 0 View
_view_keyword_image 0 0 11 0 View
_view_account_cost 0 1 6 0 View
_view_dev_check_duplicated 0 5 15 0 View