Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v poohson wp_actionscheduler_actions
* action_id : bigint(20) unsigned
* hook : varchar(191)
* status : varchar(20)
* scheduled_date_gmt : datetime
* scheduled_date_local : datetime
* priority : tinyint(3) unsigned
* args : varchar(191)
* schedule : longtext
* group_id : bigint(20) unsigned
* attempts : int(11)
* last_attempt_gmt : datetime
* last_attempt_local : datetime
* claim_id : bigint(20) unsigned
* extended_args : varchar(8000)
v poohson wp_actionscheduler_claims
* claim_id : bigint(20) unsigned
* date_created_gmt : datetime
v poohson wp_actionscheduler_groups
* group_id : bigint(20) unsigned
* slug : varchar(255)
v poohson wp_actionscheduler_logs
* log_id : bigint(20) unsigned
* action_id : bigint(20) unsigned
* message : text
* log_date_gmt : datetime
* log_date_local : datetime
v poohson wp_commentmeta
* meta_id : bigint(20) unsigned
* comment_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v poohson wp_comments
* comment_ID : bigint(20) unsigned
* comment_post_ID : bigint(20) unsigned
* comment_author : tinytext
* comment_author_email : varchar(100)
* comment_author_url : varchar(200)
* comment_author_IP : varchar(100)
* comment_date : datetime
* comment_date_gmt : datetime
* comment_content : text
* comment_karma : int(11)
* comment_approved : varchar(20)
* comment_agent : varchar(255)
* comment_type : varchar(20)
* comment_parent : bigint(20) unsigned
* user_id : bigint(20) unsigned
v poohson wp_e_events
* id : bigint(20) unsigned
* event_data : text
* created_at : datetime
v poohson wp_gla_attribute_mapping_rules
* id : bigint(20)
* attribute : varchar(255)
* source : varchar(100)
* category_condition_type : varchar(10)
* categories : text
v poohson wp_gla_budget_recommendations
* id : bigint(20)
* currency : varchar(3)
* country : varchar(2)
* daily_budget : int(11)
v poohson wp_gla_merchant_issues
* id : bigint(20)
* product_id : bigint(20)
* issue : varchar(200)
* code : varchar(100)
* severity : varchar(20)
* product : varchar(100)
* action : text
* action_url : varchar(1024)
* applicable_countries : text
* source : varchar(10)
* type : varchar(10)
* created_at : datetime
v poohson wp_gla_merchant_price_benchmarks
* product_id : bigint(20)
* mc_product_id : varchar(255)
* mc_product_offer_id : varchar(255)
* mc_product_price_micros : varchar(64)
* mc_product_currency_code : varchar(3)
* mc_price_country_code : varchar(2)
* mc_price_benchmark_price_micros : varchar(64)
* mc_price_benchmark_price_currency_code : varchar(3)
* mc_insights_suggested_price_micros : varchar(64)
* mc_insights_suggested_price_currency_code : varchar(3)
* mc_insights_predicted_impressions_change_fraction : decimal(10,6)
* mc_insights_predicted_clicks_change_fraction : decimal(10,6)
* mc_insights_predicted_conversions_change_fraction : decimal(10,6)
* mc_insights_effectiveness : tinyint(1)
* mc_metrics_clicks : varchar(64)
* mc_metrics_impressions : varchar(64)
* mc_metrics_ctr : int(20)
* mc_metrics_conversions : int(20)
* price_compared_with_benchmark : tinyint(1)
v poohson wp_gla_shipping_rates
* id : bigint(20)
* country : varchar(2)
* currency : varchar(3)
* rate : double
* options : text
v poohson wp_gla_shipping_times
* id : bigint(20)
* country : varchar(2)
* time : bigint(20)
* max_time : bigint(20)
v poohson wp_jetpack_sync_queue
* ID : bigint(20)
* queue_id : varchar(50)
* event_id : varchar(100)
* event_payload : longtext
* timestamp : timestamp
v poohson wp_options
* option_id : bigint(20) unsigned
* option_name : varchar(191)
* option_value : longtext
* autoload : varchar(20)
v poohson wp_postmeta
* meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v poohson wp_posts
* ID : bigint(20) unsigned
* post_author : bigint(20) unsigned
* post_date : datetime
* post_date_gmt : datetime
* post_content : longtext
* post_title : text
* post_excerpt : text
* post_status : varchar(20)
* comment_status : varchar(20)
* ping_status : varchar(20)
* post_password : varchar(255)
* post_name : varchar(200)
* to_ping : text
* pinged : text
* post_modified : datetime
* post_modified_gmt : datetime
* post_content_filtered : longtext
* post_parent : bigint(20) unsigned
* guid : varchar(255)
* menu_order : int(11)
* post_type : varchar(20)
* post_mime_type : varchar(100)
* comment_count : bigint(20)
v poohson wp_srfm_entries
* ID : bigint(20) unsigned
* form_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* form_data : longtext
* logs : longtext
* notes : longtext
* submission_info : longtext
* status : varchar(10)
* type : varchar(20)
* extras : longtext
* created_at : timestamp
* updated_at : timestamp
v poohson wp_srfm_payments
* id : bigint(20) unsigned
* form_id : bigint(20) unsigned
* block_id : varchar(255)
* status : varchar(50)
* total_amount : decimal(26,8)
* refunded_amount : decimal(26,8)
* currency : varchar(10)
* entry_id : bigint(20) unsigned
* gateway : varchar(20)
* type : varchar(30)
* mode : varchar(20)
* transaction_id : varchar(50)
* customer_id : varchar(50)
* subscription_id : varchar(50)
* subscription_status : varchar(20)
* parent_subscription_id : bigint(20) unsigned
* payment_data : longtext
* extra : longtext
* log : longtext
* created_at : timestamp
* updated_at : timestamp
* srfm_txn_id : varchar(100)
* customer_email : varchar(255)
* customer_name : varchar(255)
v poohson wp_suremails_email_log
* id : bigint(20)
* email_from : varchar(100)
* email_to : longtext
* subject : varchar(255)
* body : longtext
* headers : longtext
* attachments : longtext
* status : enum('failed','sent','pending','blocked')
* response : longtext
* meta : longtext
* connection : varchar(255)
* created_at : datetime
* updated_at : datetime
v poohson wp_termmeta
* meta_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v poohson wp_terms
* term_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
* term_group : bigint(10)
v poohson wp_term_relationships
* object_id : bigint(20) unsigned
* term_taxonomy_id : bigint(20) unsigned
* term_order : int(11)
v poohson wp_term_taxonomy
* term_taxonomy_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* taxonomy : varchar(32)
* description : longtext
* parent : bigint(20) unsigned
* count : bigint(20)
v poohson wp_tf_storage
* key : char(16)
* value : mediumtext
* expire : int(10) unsigned
v poohson wp_usermeta
* umeta_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v poohson wp_users
* ID : bigint(20) unsigned
* user_login : varchar(60)
* user_pass : varchar(255)
* user_nicename : varchar(50)
* user_email : varchar(100)
* user_url : varchar(100)
* user_registered : datetime
* user_activation_key : varchar(255)
* user_status : int(11)
* display_name : varchar(250)
v poohson wp_wc_admin_notes
* note_id : bigint(20) unsigned
* name : varchar(255)
* type : varchar(20)
* locale : varchar(20)
* title : longtext
* content : longtext
* content_data : longtext
* status : varchar(200)
* source : varchar(200)
* date_created : datetime
* date_reminder : datetime
* is_snoozable : tinyint(1)
* layout : varchar(20)
* image : varchar(200)
* is_deleted : tinyint(1)
* is_read : tinyint(1)
* icon : varchar(200)
v poohson wp_wc_admin_note_actions
* action_id : bigint(20) unsigned
* note_id : bigint(20) unsigned
* name : varchar(255)
* label : varchar(255)
* query : longtext
* status : varchar(255)
* actioned_text : varchar(255)
* nonce_action : varchar(255)
* nonce_name : varchar(255)
v poohson wp_wc_category_lookup
* category_tree_id : bigint(20) unsigned
* category_id : bigint(20) unsigned
v poohson wp_wc_customer_lookup
* customer_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* username : varchar(60)
* first_name : varchar(255)
* last_name : varchar(255)
* email : varchar(100)
* date_last_active : timestamp
* date_registered : timestamp
* country : char(2)
* postcode : varchar(20)
* city : varchar(100)
* state : varchar(100)
v poohson wp_wc_download_log
* download_log_id : bigint(20) unsigned
* timestamp : datetime
* permission_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* user_ip_address : varchar(100)
v poohson wp_wc_orders
* id : bigint(20) unsigned
* status : varchar(20)
* currency : varchar(10)
* type : varchar(20)
* tax_amount : decimal(26,8)
* total_amount : decimal(26,8)
* customer_id : bigint(20) unsigned
* billing_email : varchar(320)
* date_created_gmt : datetime
* date_updated_gmt : datetime
* parent_order_id : bigint(20) unsigned
* payment_method : varchar(100)
* payment_method_title : text
* transaction_id : varchar(100)
* ip_address : varchar(100)
* user_agent : text
* customer_note : text
v poohson wp_wc_orders_meta
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : text
v poohson wp_wc_order_addresses
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* address_type : varchar(20)
* first_name : text
* last_name : text
* company : text
* address_1 : text
* address_2 : text
* city : text
* state : text
* postcode : text
* country : text
* email : varchar(320)
* phone : varchar(100)
v poohson wp_wc_order_coupon_lookup
* order_id : bigint(20) unsigned
* coupon_id : bigint(20)
* date_created : datetime
* discount_amount : double
v poohson wp_wc_order_operational_data
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* created_via : varchar(100)
* woocommerce_version : varchar(20)
* prices_include_tax : tinyint(1)
* coupon_usages_are_counted : tinyint(1)
* download_permission_granted : tinyint(1)
* cart_hash : varchar(100)
* new_order_email_sent : tinyint(1)
* order_key : varchar(100)
* order_stock_reduced : tinyint(1)
* date_paid_gmt : datetime
* date_completed_gmt : datetime
* shipping_tax_amount : decimal(26,8)
* shipping_total_amount : decimal(26,8)
* discount_tax_amount : decimal(26,8)
* discount_total_amount : decimal(26,8)
* recorded_sales : tinyint(1)
v poohson wp_wc_order_product_lookup
* order_item_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* variation_id : bigint(20) unsigned
* customer_id : bigint(20) unsigned
* date_created : datetime
* product_qty : int(11)
* product_net_revenue : double
* product_gross_revenue : double
* coupon_amount : double
* tax_amount : double
* shipping_amount : double
* shipping_tax_amount : double
v poohson wp_wc_order_stats
* order_id : bigint(20) unsigned
* parent_id : bigint(20) unsigned
* date_created : datetime
* date_created_gmt : datetime
* date_paid : datetime
* date_completed : datetime
* num_items_sold : int(11)
* total_sales : double
* tax_total : double
* shipping_total : double
* net_total : double
* returning_customer : tinyint(1)
* status : varchar(20)
* customer_id : bigint(20) unsigned
v poohson wp_wc_order_tax_lookup
* order_id : bigint(20) unsigned
* tax_rate_id : bigint(20) unsigned
* date_created : datetime
* shipping_tax : double
* order_tax : double
* total_tax : double
v poohson wp_wc_product_attributes_lookup
* product_id : bigint(20)
* product_or_parent_id : bigint(20)
* taxonomy : varchar(32)
* term_id : bigint(20)
* is_variation_attribute : tinyint(1)
* in_stock : tinyint(1)
v poohson wp_wc_product_download_directories
* url_id : bigint(20) unsigned
* url : varchar(256)
* enabled : tinyint(1)
v poohson wp_wc_product_meta_lookup
* product_id : bigint(20)
* sku : varchar(100)
* global_unique_id : varchar(100)
* virtual : tinyint(1)
* downloadable : tinyint(1)
* min_price : decimal(19,4)
* max_price : decimal(19,4)
* onsale : tinyint(1)
* stock_quantity : double
* stock_status : varchar(100)
* rating_count : bigint(20)
* average_rating : decimal(3,2)
* total_sales : bigint(20)
* tax_status : varchar(100)
* tax_class : varchar(100)
v poohson wp_wc_rate_limits
* rate_limit_id : bigint(20) unsigned
* rate_limit_key : varchar(200)
* rate_limit_expiry : bigint(20) unsigned
* rate_limit_remaining : smallint(10)
v poohson wp_wc_reserved_stock
* order_id : bigint(20)
* product_id : bigint(20)
* stock_quantity : double
* timestamp : datetime
* expires : datetime
v poohson wp_wc_tax_rate_classes
* tax_rate_class_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
v poohson wp_wc_webhooks
* webhook_id : bigint(20) unsigned
* status : varchar(200)
* name : text
* user_id : bigint(20) unsigned
* delivery_url : text
* secret : text
* topic : varchar(200)
* date_created : datetime
* date_created_gmt : datetime
* date_modified : datetime
* date_modified_gmt : datetime
* api_version : smallint(4)
* failure_count : smallint(10)
* pending_delivery : tinyint(1)
v poohson wp_woocommerce_api_keys
* key_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* description : varchar(200)
* permissions : varchar(10)
* consumer_key : char(64)
* consumer_secret : char(43)
* nonces : longtext
* truncated_key : char(7)
* last_access : datetime
v poohson wp_woocommerce_attribute_taxonomies
* attribute_id : bigint(20) unsigned
* attribute_name : varchar(200)
* attribute_label : varchar(200)
* attribute_type : varchar(20)
* attribute_orderby : varchar(20)
* attribute_public : int(1)
v poohson wp_woocommerce_downloadable_product_permissions
* permission_id : bigint(20) unsigned
* download_id : varchar(36)
* product_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* order_key : varchar(200)
* user_email : varchar(200)
* user_id : bigint(20) unsigned
* downloads_remaining : varchar(9)
* access_granted : datetime
* access_expires : datetime
* download_count : bigint(20) unsigned
v poohson wp_woocommerce_log
* log_id : bigint(20) unsigned
* timestamp : datetime
* level : smallint(4)
* source : varchar(200)
* message : longtext
* context : longtext
v poohson wp_woocommerce_order_itemmeta
* meta_id : bigint(20) unsigned
* order_item_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v poohson wp_woocommerce_order_items
* order_item_id : bigint(20) unsigned
* order_item_name : text
* order_item_type : varchar(200)
* order_id : bigint(20) unsigned
v poohson wp_woocommerce_payment_tokenmeta
* meta_id : bigint(20) unsigned
* payment_token_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v poohson wp_woocommerce_payment_tokens
* token_id : bigint(20) unsigned
* gateway_id : varchar(200)
* token : text
* user_id : bigint(20) unsigned
* type : varchar(200)
* is_default : tinyint(1)
v poohson wp_woocommerce_sessions
* session_id : bigint(20) unsigned
* session_key : char(32)
* session_value : longtext
* session_expiry : bigint(20) unsigned
v poohson wp_woocommerce_shipping_zones
* zone_id : bigint(20) unsigned
* zone_name : varchar(200)
* zone_order : bigint(20) unsigned
v poohson wp_woocommerce_shipping_zone_locations
* location_id : bigint(20) unsigned
* zone_id : bigint(20) unsigned
* location_code : varchar(200)
* location_type : varchar(40)
v poohson wp_woocommerce_shipping_zone_methods
* zone_id : bigint(20) unsigned
* instance_id : bigint(20) unsigned
* method_id : varchar(200)
* method_order : bigint(20) unsigned
* is_enabled : tinyint(1)
v poohson wp_woocommerce_tax_rates
* tax_rate_id : bigint(20) unsigned
* tax_rate_country : varchar(2)
* tax_rate_state : varchar(200)
* tax_rate : varchar(8)
* tax_rate_name : varchar(200)
* tax_rate_priority : bigint(20) unsigned
* tax_rate_compound : int(1)
* tax_rate_shipping : int(1)
* tax_rate_order : bigint(20) unsigned
* tax_rate_class : varchar(200)
v poohson wp_woocommerce_tax_rate_locations
* location_id : bigint(20) unsigned
* location_code : varchar(200)
* tax_rate_id : bigint(20) unsigned
* location_type : varchar(40)
v poohson wp_wpforms_logs
* id : bigint(20)
* title : varchar(255)
* message : longtext
* types : varchar(255)
* create_at : datetime
* form_id : bigint(20)
* entry_id : bigint(20)
* user_id : bigint(20)
v poohson wp_wpforms_payments
* id : bigint(20)
* form_id : bigint(20)
* status : varchar(10)
* subtotal_amount : decimal(26,8)
* discount_amount : decimal(26,8)
* total_amount : decimal(26,8)
* currency : varchar(3)
* entry_id : bigint(20)
* gateway : varchar(20)
* type : varchar(12)
* mode : varchar(4)
* transaction_id : varchar(40)
* customer_id : varchar(40)
* subscription_id : varchar(40)
* subscription_status : varchar(10)
* title : varchar(255)
* date_created_gmt : datetime
* date_updated_gmt : datetime
* is_published : tinyint(1)
v poohson wp_wpforms_payment_meta
* id : bigint(20)
* payment_id : bigint(20)
* meta_key : varchar(255)
* meta_value : longtext
v poohson wp_wpforms_tasks_meta
* id : bigint(20)
* action : varchar(255)
* data : longtext
* date : datetime
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship