Thả tập tin vào đây

SQL upload ( 0 ) x -

Cài đặt liên quan đến trang Bấm vào thanh để cuộn lên đỉnh trang
Nhấn Ctrl+Enter để thực thi truy vấn Nhấn Enter để thực thi truy vấn
tăng dần
giảm dần
Thứ tự:
Gỡ rối SQL
Số lượng
Thứ tự thực thi
Thời gian cần
Xếp theo:
Nhóm truy vấn
Bỏ nhóm các truy vấn
Co lại Mở rộng Hiện theo dõi Ẩn theo dõi Số lượng Thời gian cần
Đánh dấu
Làm tươi lại
Thêm
Không có đánh dấu nào
Thêm đánh dấu
Tùy chọn
Đặt lại thành mặc định





Co lại Mở rộng Truy vấn lại Sửa Giải thích Hồ sơ Đánh dấu Truy vấn bị lỗi Cơ sở dữ liệu : Thời gian truy vấn :
Chưa đặt tên *
v Hiện/Ẩn danh sách bảng Hiển thị toàn màn hình Thêm bảng từ cơ sở dữ liệu khác Trang mới Mở trang Ghi lại trang Ghi trang bằng tên mới Xóa trang Tạo bảng Create relationship Chọn cột bạn muốn hiển thị Tải lại Trợ giúp Các liên kết góc / Liên kết trực tiếp Dính lưới v Nhỏ/To tất cả Bật/tắt lớn/nhỏ Toggle relationship lines Xuất lược đồ > Di chuyển trình đơn > Đóng đinh chữ
v v
Số lượng bảng: 0
v lari-uat 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 lari-uat wp_actionscheduler_claims
* claim_id : bigint(20) unsigned
* date_created_gmt : datetime
v lari-uat wp_actionscheduler_groups
* group_id : bigint(20) unsigned
* slug : varchar(255)
v lari-uat wp_actionscheduler_logs
* log_id : bigint(20) unsigned
* action_id : bigint(20) unsigned
* message : text
* log_date_gmt : datetime
* log_date_local : datetime
v lari-uat wp_commentmeta
* meta_id : bigint(20) unsigned
* comment_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v lari-uat 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 lari-uat wp_dokan_announcement
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* post_id : bigint(11)
* status : varchar(30)
v lari-uat wp_dokan_orders
* id : bigint(20) unsigned
* order_id : bigint(20)
* seller_id : bigint(20)
* order_total : decimal(19,4)
* net_amount : decimal(19,4)
* order_status : varchar(30)
v lari-uat wp_dokan_order_stats
* order_id : bigint(20) unsigned
* vendor_id : bigint(20) unsigned
* order_type : tinyint(1)
* vendor_earning : double
* vendor_gateway_fee : double
* vendor_shipping_fee : double
* vendor_discount : double
* admin_commission : double
* admin_gateway_fee : double
* admin_shipping_fee : double
* admin_discount : double
* admin_subsidy : double
v lari-uat wp_dokan_refund
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* seller_id : bigint(20)
* refund_amount : decimal(19,4)
* refund_reason : text
* item_qtys : varchar(200)
* item_totals : text
* item_tax_totals : text
* restock_items : varchar(10)
* date : timestamp
* status : int(1)
* method : varchar(30)
v lari-uat wp_dokan_reverse_withdrawal
* id : bigint(20) unsigned
* trn_id : bigint(20) unsigned
* trn_type : varchar(200)
* vendor_id : bigint(20) unsigned
* note : mediumtext
* debit : decimal(19,4)
* credit : decimal(19,4)
* trn_date : int(11) unsigned
v lari-uat wp_dokan_vendor_balance
* id : bigint(20) unsigned
* vendor_id : bigint(20) unsigned
* trn_id : bigint(20) unsigned
* trn_type : varchar(30)
* perticulars : text
* debit : decimal(19,4)
* credit : decimal(19,4)
* status : varchar(30)
* trn_date : timestamp
* balance_date : timestamp
v lari-uat wp_dokan_withdraw
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* amount : decimal(19,4)
* date : timestamp
* status : int(1)
* method : varchar(30)
* note : text
* details : longtext
* ip : varchar(50)
v lari-uat wp_e_events
* id : bigint(20) unsigned
* event_data : text
* created_at : datetime
v lari-uat wp_gla_attribute_mapping_rules
* id : bigint(20)
* attribute : varchar(255)
* source : varchar(100)
* category_condition_type : varchar(10)
* categories : text
v lari-uat wp_gla_budget_recommendations
* id : bigint(20)
* currency : varchar(3)
* country : varchar(2)
* daily_budget : int(11)
v lari-uat 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 lari-uat 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 lari-uat wp_gla_shipping_rates
* id : bigint(20)
* country : varchar(2)
* currency : varchar(3)
* rate : double
* options : text
v lari-uat wp_gla_shipping_times
* id : bigint(20)
* country : varchar(2)
* time : bigint(20)
* max_time : bigint(20)
v lari-uat wp_jetpack_sync_queue
* ID : bigint(20)
* queue_id : varchar(50)
* event_id : varchar(100)
* event_payload : longtext
* timestamp : timestamp
v lari-uat wp_options
* option_id : bigint(20) unsigned
* option_name : varchar(191)
* option_value : longtext
* autoload : varchar(20)
v lari-uat wp_postmeta
* meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v lari-uat 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 lari-uat wp_revslider_css
* id : int(9)
* handle : text
* settings : longtext
* hover : longtext
* advanced : longtext
* params : longtext
v lari-uat wp_revslider_layer_animations
* id : int(9)
* handle : text
* params : text
* settings : text
v lari-uat wp_revslider_navigations
* id : int(9)
* name : varchar(191)
* handle : varchar(191)
* type : varchar(191)
* css : longtext
* markup : longtext
* settings : longtext
v lari-uat wp_revslider_sliders
* id : int(9)
* title : tinytext
* alias : tinytext
* params : longtext
* settings : text
* type : varchar(191)
v lari-uat wp_revslider_sliders7
* id : int(9)
* title : tinytext
* alias : tinytext
* params : longtext
* settings : text
* type : varchar(191)
v lari-uat wp_revslider_slides
* id : int(9)
* slider_id : int(9)
* slide_order : int(11)
* params : longtext
* layers : longtext
* settings : text
v lari-uat wp_revslider_slides7
* id : int(9)
* slider_id : int(11)
* slide_order : int(11)
* params : longtext
* layers : longtext
* settings : text
* static : varchar(191)
v lari-uat wp_revslider_static_slides
* id : int(9)
* slider_id : int(9)
* params : longtext
* layers : longtext
* settings : text
v lari-uat wp_termmeta
* meta_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v lari-uat wp_terms
* term_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
* term_group : bigint(10)
v lari-uat wp_term_relationships
* object_id : bigint(20) unsigned
* term_taxonomy_id : bigint(20) unsigned
* term_order : int(11)
v lari-uat 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 lari-uat wp_usermeta
* umeta_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v lari-uat 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 lari-uat 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 lari-uat 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 lari-uat wp_wc_category_lookup
* category_tree_id : bigint(20) unsigned
* category_id : bigint(20) unsigned
v lari-uat 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 lari-uat 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 lari-uat 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 lari-uat wp_wc_orders_meta
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : text
v lari-uat 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 lari-uat wp_wc_order_coupon_lookup
* order_id : bigint(20) unsigned
* coupon_id : bigint(20)
* date_created : datetime
* discount_amount : double
v lari-uat 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 lari-uat 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 lari-uat 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 lari-uat 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 lari-uat 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 lari-uat wp_wc_product_download_directories
* url_id : bigint(20) unsigned
* url : varchar(256)
* enabled : tinyint(1)
v lari-uat 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 lari-uat 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 lari-uat wp_wc_reserved_stock
* order_id : bigint(20)
* product_id : bigint(20)
* stock_quantity : double
* timestamp : datetime
* expires : datetime
v lari-uat wp_wc_tax_rate_classes
* tax_rate_class_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
v lari-uat 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 lari-uat 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 lari-uat 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 lari-uat 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 lari-uat wp_woocommerce_log
* log_id : bigint(20) unsigned
* timestamp : datetime
* level : smallint(4)
* source : varchar(200)
* message : longtext
* context : longtext
v lari-uat wp_woocommerce_order_itemmeta
* meta_id : bigint(20) unsigned
* order_item_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v lari-uat 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 lari-uat wp_woocommerce_payment_tokenmeta
* meta_id : bigint(20) unsigned
* payment_token_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v lari-uat 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 lari-uat wp_woocommerce_sessions
* session_id : bigint(20) unsigned
* session_key : char(32)
* session_value : longtext
* session_expiry : bigint(20) unsigned
v lari-uat wp_woocommerce_shipping_zones
* zone_id : bigint(20) unsigned
* zone_name : varchar(200)
* zone_order : bigint(20) unsigned
v lari-uat wp_woocommerce_shipping_zone_locations
* location_id : bigint(20) unsigned
* zone_id : bigint(20) unsigned
* location_code : varchar(200)
* location_type : varchar(40)
v lari-uat 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 lari-uat 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 lari-uat 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 lari-uat wp_wpc_wishlist_stats
* id : bigint(20)
* product_id : bigint(20)
* user_id : bigint(20)
* action : varchar(10)
* created_at : datetime
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship