Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: optica_2020_antes_eliminar_bodegas_04082024
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
x
 
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
xxxxxxxxxx
 
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the charset for all tables.
Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
armazones_oferta 2,913 MyISAM latin1_swedish_ci 20.9 KiB -
ayudas 3 MyISAM latin1_general_ci 2.2 KiB -
bitacora 214,745 MyISAM utf8_general_ci 19.8 MiB -
bitacora_tracking ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
bodega 51 MyISAM utf8_general_ci 3.9 KiB -
bodega_copy 51 MyISAM utf8_general_ci 3.9 KiB -
bonos_vale_venta 19,007 MyISAM latin1_swedish_ci 909.8 KiB -
cargo_funcionario 15 MyISAM utf8_general_ci 2.5 KiB -
carro_compras 0 MyISAM latin1_general_ci 1 KiB -
celuloide 567 MyISAM latin1_general_ci 51.4 KiB -
ciudad 26 MyISAM utf8_general_ci 2.7 KiB -
cliente 389 MyISAM utf8_general_ci 63 KiB -
cliente_particular 243,870 MyISAM utf8_general_ci 17.2 MiB -
cliente_proveedor 3 MyISAM utf8_general_ci 3.4 KiB -
columna 2,539 MyISAM utf8_general_ci 87.6 KiB -
comisiones_porcentajes 724 MyISAM latin1_general_ci 26 KiB -
cond_venta 26 MyISAM utf8_general_ci 2.9 KiB -
contacto 1,724 MyISAM utf8_general_ci 126.8 KiB -
cont_banco 8 MyISAM utf8_general_ci 2.2 KiB -
cont_boleta_venta 0 MyISAM latin1_swedish_ci 1 KiB -
cont_centro_costo 2 MyISAM latin1_swedish_ci 2 KiB -
cont_cheque 1,706 MyISAM latin1_swedish_ci 90.2 KiB -
cont_ciudad 47 MyISAM latin1_swedish_ci 4.2 KiB -
cont_cliente_proveedor 1,453 MyISAM latin1_swedish_ci 286 KiB -
cont_comportamiento_cuenta 11 MyISAM latin1_swedish_ci 2.3 KiB -
cont_comprobante 0 MyISAM latin1_swedish_ci 1 KiB -
cont_comprobante_pago 132,695 MyISAM latin1_swedish_ci 11.9 MiB -
cont_comuna 142 MyISAM utf8_general_ci 9.9 KiB -
cont_cuenta 245 MyISAM latin1_swedish_ci 23.4 KiB -
cont_detalle_comprobante 0 MyISAM latin1_swedish_ci 1 KiB -
cont_detalle_comprobante_pago 1,598 MyISAM latin1_swedish_ci 78.3 KiB -
cont_detalle_documento_venta 330,654 MyISAM latin1_swedish_ci 36.8 MiB -
cont_documento_venta 0 MyISAM latin1_swedish_ci 1 KiB -
cont_empresa 1 MyISAM utf8_general_ci 2.2 KiB 20 B
cont_nivel_plan_cuenta 139 MyISAM utf8_general_ci 19.4 KiB -
cont_plan_cuenta 2 MyISAM latin1_swedish_ci 2.1 KiB -
cont_sub_centro_costo 7 MyISAM latin1_swedish_ci 4.3 KiB -
cont_tipo_documento 11 MyISAM latin1_swedish_ci 2.4 KiB -
convenio 1,182 MyISAM utf8_general_ci 88.9 KiB -
costos 7,892 InnoDB latin1_general_ci 432 KiB -
cotizacion 110,727 MyISAM utf8_general_ci 11.3 MiB -
cotizaciones_vendidas 14,768 MyISAM latin1_general_ci 102 KiB -
cuota_credito 0 MyISAM latin1_swedish_ci 1 KiB -
descuento_convenio 3,728 MyISAM utf8_general_ci 185 KiB -
detalle_convenio 1,543 MyISAM utf8_general_ci 119.3 KiB -
detalle_cotizacion 330,068 MyISAM utf8_general_ci 58.1 MiB -
detalle_devolucion 26 MyISAM utf8_general_ci 2.5 KiB -
detalle_devolucion_producto 1,222 MyISAM utf8_general_ci 56.5 KiB -
detalle_guia_despacho 117,978 MyISAM utf8_general_ci 11.8 MiB -
detalle_ordenes_produccion ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
detalle_orden_compra 156,091 MyISAM utf8_general_ci 25.8 MiB -
detalle_recepcion 313,142 MyISAM utf8_general_ci 13.5 MiB -
detalle_recepcion_traspaso 107,223 InnoDB utf8_spanish_ci 4.5 MiB -
detalle_solicitud_insumos 42,653 MyISAM latin1_swedish_ci 4 MiB -
detalle_tabla_precio 105,886 MyISAM latin1_general_ci 4.4 MiB -
detalle_traspaso 133,166 MyISAM utf8_general_ci 7 MiB -
detalle_vale_venta 260,184 MyISAM utf8_general_ci 37.7 MiB -
detalle_ventas 73,423 MyISAM utf8_general_ci 7.6 MiB -
deterioro_material 8,788 MyISAM utf8_general_ci 819.8 KiB -
devolucion_productos 1,131 MyISAM utf8_general_ci 93.6 KiB -
doctor 387 MyISAM utf8_general_ci 26.9 KiB -
documento 9 MyISAM utf8_general_ci 2.4 KiB -
documentos_referencia 142,214 MyISAM latin1_swedish_ci 10.4 MiB -
documento_credito 0 MyISAM latin1_swedish_ci 1 KiB -
documento_dte 11 MyISAM utf8_general_ci 2.4 KiB -
empresa 323 MyISAM utf8_general_ci 59.7 KiB -
entrega_sobres_bodega 1,048 MyISAM latin1_swedish_ci 51.6 KiB -
familia 16 MyISAM utf8_general_ci 2.5 KiB -
fecha_recepcion 0 MyISAM latin1_swedish_ci 2 KiB -
feriados 15 MyISAM latin1_general_ci 2.3 KiB -
fila 9,240 MyISAM utf8_general_ci 534.1 KiB -
folios 1 MyISAM latin1_swedish_ci 2 KiB -
forma_pago 15 MyISAM utf8_general_ci 2.4 KiB -
funcionario 30 MyISAM utf8_general_ci 3.5 KiB -
guia_despacho 93,085 MyISAM utf8_general_ci 10.5 MiB -
industria 3 MyISAM utf8_general_ci 2.2 KiB -
informe_alondra 13,783 InnoDB latin1_swedish_ci 2.5 MiB -
informe_ventas_armazones_seguridad 87 MyISAM latin1_swedish_ci 5.6 KiB -
interes 24 MyISAM utf8_general_ci 2.8 KiB -
inventario 246,305 MyISAM utf8_general_ci 20.5 MiB -
lentes_sol_oferta 2,354 MyISAM latin1_swedish_ci 17.1 KiB -
lineas_productos 7 MyISAM latin1_general_ci 2.2 KiB -
lista_precios_clientes 0 MyISAM latin1_swedish_ci 1 KiB -
movimiento_inventario 529,777 MyISAM utf8_general_ci 47.7 MiB -
observacion_paciente 1,649 MyISAM latin1_swedish_ci 133.9 KiB -
oferta 8,859 MyISAM utf8_general_ci 1.1 MiB -
ordenes_produccion ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
orden_compra 42,997 MyISAM utf8_general_ci 3.9 MiB -
orden_compra_clientes 79,317 MyISAM latin1_swedish_ci 7.3 MiB -
orden_compra_clientes_vales 122,577 MyISAM latin1_swedish_ci 4.8 MiB -
paciente 229,068 MyISAM latin1_swedish_ci 16.2 MiB -
pago 150,935 MyISAM utf8_general_ci 15.2 MiB -
parametros 26 MyISAM latin1_general_ci 4.2 KiB 20 B
persona 9 MyISAM utf8_general_ci 2.4 KiB -
precios_compra 0 InnoDB latin1_general_ci 16 KiB -
produccion_extra 208 MyISAM latin1_general_ci 17.6 KiB -
producto 350,294 MyISAM utf8_general_ci 62.7 MiB -
productos_clientes 3 MyISAM latin1_general_ci 2.1 KiB -
productos_sin_costo 2,574 InnoDB utf8_spanish_ci 128 KiB -
producto_composicion 181 MyISAM latin1_general_ci 7.5 KiB -
recepcion 102,870 MyISAM utf8_general_ci 7.5 MiB -
recepcion_traspaso 18,250 InnoDB utf8_spanish_ci 1.5 MiB -
region 17 MyISAM utf8_general_ci 2.5 KiB -
reserva_laboratorio 52,420 MyISAM utf8_general_ci 5 MiB -
rrmm_salud 10 MyISAM latin1_swedish_ci 2.3 KiB -
sesiones 5,276 MyISAM latin1_swedish_ci 320 KiB -
sobre 289,353 MyISAM utf8_general_ci 35.1 MiB -
solicitudes_insumos 11,373 MyISAM latin1_swedish_ci 515.8 KiB -
subfamilia 275 MyISAM utf8_general_ci 16.6 KiB -
sucursal 23 MyISAM utf8_general_ci 4.5 KiB -
tabla_precio 126 MyISAM utf8_general_ci 11.4 KiB -
tarjeta_coordenadas 50 MyISAM latin1_general_ci 3 KiB -
tecnico 58 MyISAM utf8_general_ci 5.1 KiB -
tipos_comprobantes 5 MyISAM latin1_swedish_ci 2.1 KiB -
tipo_material 888 MyISAM utf8_general_ci 81.5 KiB -
toma_inventario 485 MyISAM utf8_general_ci 37.9 KiB -
traspaso_inventario 24,626 MyISAM utf8_general_ci 2.1 MiB -
tratamiento 54 MyISAM utf8_general_ci 5.6 KiB -
tratamientos_cotizacion 319,384 MyISAM latin1_general_ci 10.2 MiB -
ultimos_precios_compra 120,585 InnoDB latin1_swedish_ci 6.5 MiB -
unidad 6 MyISAM utf8_general_ci 2.1 KiB -
usuario 67 MyISAM utf8_general_ci 17.6 KiB -
vale_venta 88,842 MyISAM utf8_general_ci 14.5 MiB -
vendedor 136 MyISAM utf8_general_ci 10.9 KiB -
ventas 120,242 MyISAM utf8_general_ci 12.3 MiB -
xml 69,145 MyISAM latin1_general_ci 115.8 MiB -
126 tables Sum ~5,998,192 InnoDB latin1_swedish_ci 690.4 MiB 40 B

  Create table
Name:
Number of columns: