Suelte aquí los archivos

Carga SQL ( 0 ) x -

Ajustes de página relacionada Pulse en la barra para deslizarse al tope de la página
Presione Ctrl+Enter para ejecutar la consulta Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar Expandir Mostrar rastro Ocultar rastro Cantidad : Tiempo necesario :
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Opciones
Definir predeterminado





Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :
Sin título *
v Mostrar/Ocultar lista de tablas Ver en pantalla completa Añadir tablas de otras bases de datos Nueva página Abrir página Guardar página Guardar página como Borrar páginas Crear tabla Crear relación Elegir la columna a mostrar Cargar nuevamente Ayuda Enlaces angulares / Enlaces directos Cuadrícula magnética v Pequeño/grande todos Alterne entre pequeño y grande Alternar líneas de relación Exportar estructura > Mover el Menú > Fijar texto
v v
Número de tablas: 0
v optikom_db 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 optikom_db wp_actionscheduler_claims
* claim_id : bigint(20) unsigned
* date_created_gmt : datetime
v optikom_db wp_actionscheduler_groups
* group_id : bigint(20) unsigned
* slug : varchar(255)
v optikom_db wp_actionscheduler_logs
* log_id : bigint(20) unsigned
* action_id : bigint(20) unsigned
* message : text
* log_date_gmt : datetime
* log_date_local : datetime
v optikom_db wp_commentmeta
* meta_id : bigint(20) unsigned
* comment_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v optikom_db 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 optikom_db wp_optikom_reactions
* id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* type : varchar(12)
* comment : text
* contact : varchar(190)
* ip_hash : char(32)
* created_at : datetime
v optikom_db wp_options
* option_id : bigint(20) unsigned
* option_name : varchar(191)
* option_value : longtext
* autoload : varchar(20)
v optikom_db wp_postmeta
* meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v optikom_db 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 optikom_db wp_termmeta
* meta_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v optikom_db wp_terms
* term_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
* term_group : bigint(10)
v optikom_db wp_term_relationships
* object_id : bigint(20) unsigned
* term_taxonomy_id : bigint(20) unsigned
* term_order : int(11)
v optikom_db 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 optikom_db wp_usermeta
* umeta_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v optikom_db 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 optikom_db 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 optikom_db 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 optikom_db wp_wc_category_lookup
* category_tree_id : bigint(20) unsigned
* category_id : bigint(20) unsigned
v optikom_db 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)
* billing_phone : varchar(100)
* shipping_phone : varchar(100)
v optikom_db 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 optikom_db 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 optikom_db wp_wc_orders_meta
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : text
v optikom_db 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 optikom_db wp_wc_order_coupon_lookup
* order_id : bigint(20) unsigned
* coupon_id : bigint(20)
* date_created : datetime
* discount_amount : double
v optikom_db 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 optikom_db 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 optikom_db 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 optikom_db wp_wc_order_tax_lookup
* order_id : bigint(20) unsigned
* tax_rate_id : bigint(20) unsigned
* order_item_id : bigint(20) unsigned
* date_created : datetime
* shipping_tax : double
* order_tax : double
* total_tax : double
* taxable_amount : double
v optikom_db 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 optikom_db wp_wc_product_download_directories
* url_id : bigint(20) unsigned
* url : varchar(256)
* enabled : tinyint(1)
v optikom_db 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 optikom_db 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 optikom_db wp_wc_reserved_stock
* order_id : bigint(20)
* product_id : bigint(20)
* stock_quantity : double
* timestamp : datetime
* expires : datetime
v optikom_db wp_wc_stock_notificationmeta
* id : bigint(20) unsigned
* notification_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v optikom_db wp_wc_stock_notifications
* id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* user_email : varchar(100)
* status : varchar(20)
* date_created_gmt : datetime
* date_modified_gmt : datetime
* date_confirmed_gmt : datetime
* date_last_attempt_gmt : datetime
* date_notified_gmt : datetime
* date_cancelled_gmt : datetime
* cancellation_source : varchar(30)
v optikom_db wp_wc_tax_rate_classes
* tax_rate_class_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
v optikom_db 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 optikom_db 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 optikom_db 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 optikom_db 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 optikom_db wp_woocommerce_log
* log_id : bigint(20) unsigned
* timestamp : datetime
* level : smallint(4)
* source : varchar(200)
* message : longtext
* context : longtext
v optikom_db wp_woocommerce_order_itemmeta
* meta_id : bigint(20) unsigned
* order_item_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v optikom_db 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 optikom_db wp_woocommerce_payment_tokenmeta
* meta_id : bigint(20) unsigned
* payment_token_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v optikom_db 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 optikom_db wp_woocommerce_sessions
* session_id : bigint(20) unsigned
* session_key : char(32)
* session_value : longtext
* session_expiry : bigint(20) unsigned
v optikom_db wp_woocommerce_shipping_zones
* zone_id : bigint(20) unsigned
* zone_name : varchar(200)
* zone_order : bigint(20) unsigned
v optikom_db wp_woocommerce_shipping_zone_locations
* location_id : bigint(20) unsigned
* zone_id : bigint(20) unsigned
* location_code : varchar(200)
* location_type : varchar(40)
v optikom_db 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 optikom_db 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 optikom_db wp_woocommerce_tax_rate_locations
* location_id : bigint(20) unsigned
* location_code : varchar(200)
* tax_rate_id : bigint(20) unsigned
* location_type : varchar(40)
Crear relación
FOREIGN KEY
on delete
on update
Eliminar la relación