Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: optica_2020
Page-related settingsClick 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 :

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
ayudas 3 MyISAM latin1_general_ci 2.2 KiB -
bitacora 264,902 MyISAM utf8_general_ci 24.6 MiB -
bitacora_tracking 0 MyISAM latin1_swedish_ci 1 KiB -
bodega 43 MyISAM utf8_general_ci 4.1 KiB 340 B
bodega_copy 51 MyISAM utf8_general_ci 3.9 KiB -
bonos_vale_venta 20,707 MyISAM latin1_swedish_ci 1 MiB -
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 61 KiB -
cliente_particular 264,343 MyISAM utf8_general_ci 18.2 MiB -
cliente_proveedor 3 MyISAM utf8_general_ci 3.4 KiB -
columna 2,561 MyISAM utf8_general_ci 79.1 KiB -
comisiones_porcentajes 802 MyISAM latin1_general_ci 28.6 KiB -
cond_venta 26 MyISAM utf8_general_ci 2.9 KiB -
contacto 1,877 MyISAM utf8_general_ci 138.5 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,709 MyISAM latin1_swedish_ci 90.3 KiB -
cont_ciudad 47 MyISAM latin1_swedish_ci 4.2 KiB -
cont_cliente_proveedor 1,552 MyISAM latin1_swedish_ci 312.5 KiB 20 B
cont_comportamiento_cuenta 11 MyISAM latin1_swedish_ci 2.3 KiB -
cont_comprobante 0 MyISAM latin1_swedish_ci 1 KiB -
cont_comprobante_pago 143,208 MyISAM latin1_swedish_ci 13 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,854 MyISAM latin1_swedish_ci 91.3 KiB -
cont_detalle_documento_venta 354,043 MyISAM latin1_swedish_ci 39.4 MiB -
cont_documento_venta 0 MyISAM latin1_swedish_ci 1 KiB -
cont_empresa 1 MyISAM utf8_general_ci 2.2 KiB -
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,200 MyISAM utf8_general_ci 87.4 KiB -
costos 7,892 InnoDB latin1_general_ci 432 KiB -
cotizacion 139,049 MyISAM utf8_general_ci 15.7 MiB -
cuota_credito 0 MyISAM latin1_swedish_ci 1 KiB -
descuento_convenio 3,786 MyISAM utf8_general_ci 193.6 KiB -
detalle_convenio 1,563 MyISAM utf8_general_ci 115.4 KiB -
detalle_cotizacion 413,222 MyISAM utf8_general_ci 82.2 MiB -
detalle_devolucion 26 MyISAM utf8_general_ci 2.5 KiB -
detalle_devolucion_producto 1,328 MyISAM utf8_general_ci 73.5 KiB -
detalle_guia_despacho 132,550 MyISAM utf8_general_ci 13.5 MiB -
detalle_ordenes_produccion ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
detalle_orden_compra 194,964 MyISAM utf8_general_ci 49.1 MiB 11.1 MiB
detalle_recepcion 355,071 MyISAM utf8_general_ci 15.1 MiB -
detalle_recepcion_traspaso 116,849 InnoDB utf8_spanish_ci 4.5 MiB -
detalle_solicitud_insumos 53,653 MyISAM latin1_swedish_ci 6 MiB -
detalle_tabla_precio 106,698 MyISAM latin1_general_ci 4.4 MiB -
detalle_traspaso 143,796 MyISAM utf8_general_ci 7.6 MiB -
detalle_vale_venta 323,061 MyISAM utf8_general_ci 58.7 MiB 4.8 MiB
detalle_ventas 83,844 MyISAM utf8_general_ci 9.5 MiB -
deterioro_material 9,733 MyISAM utf8_general_ci 928.5 KiB -
devolucion_productos 1,222 MyISAM utf8_general_ci 104.4 KiB -
doctor 418 MyISAM utf8_general_ci 29.3 KiB -
documento 9 MyISAM utf8_general_ci 2.4 KiB -
documentos_referencia 166,939 MyISAM latin1_swedish_ci 12.3 MiB -
documento_credito 0 MyISAM latin1_swedish_ci 1 KiB -
documento_dte 11 MyISAM utf8_general_ci 2.4 KiB -
empresa 326 MyISAM utf8_general_ci 60.4 KiB -
empresa_antes_actualizacion_tipos_oc 325 MyISAM utf8_general_ci 60.1 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 33 MyISAM latin1_general_ci 2.7 KiB 20 B
fila 9,304 MyISAM utf8_general_ci 505.9 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 106,212 MyISAM utf8_general_ci 12.7 MiB -
industria 3 MyISAM utf8_general_ci 2.2 KiB -
interes 24 MyISAM utf8_general_ci 2.8 KiB -
inventario 259,043 MyISAM utf8_general_ci 22.7 MiB -
inventario_calama_08012025 253,551 MyISAM utf8_general_ci 20.9 MiB -
inventario_central5_armazones 253,941 MyISAM utf8_general_ci 21 MiB -
inventario_central5_ofertas 254,154 MyISAM utf8_general_ci 21 MiB -
inventario_cm656_01022025 255,308 MyISAM utf8_general_ci 21.1 MiB -
inventario_cm656_12022025 256,212 MyISAM utf8_general_ci 21.2 MiB -
inventario_cm656_28022025 257,498 MyISAM utf8_general_ci 21.3 MiB -
inventario_colipi_10012025 253,783 MyISAM utf8_general_ci 20.9 MiB -
inventario_cristales 254,333 MyISAM utf8_general_ci 21.1 MiB -
inventario_fleming_04012025 253,164 MyISAM utf8_general_ci 20.9 MiB -
inventario_iqq_serena_03012025 253,103 MyISAM utf8_general_ci 20.9 MiB -
inventario_lentes_contacto_central_08012025 253,551 MyISAM utf8_general_ci 20.9 MiB -
inventario_lentes_seguridad_central5_09012025 253,699 MyISAM utf8_general_ci 20.9 MiB -
inventario_los_carrera_09012025 253,699 MyISAM utf8_general_ci 20.9 MiB -
inventario_matta_26022025 257,343 MyISAM utf8_general_ci 21.3 MiB -
inventario_matta_27122024 252,684 MyISAM utf8_general_ci 20.9 MiB -
inventario_matta_30012025 255,236 MyISAM utf8_general_ci 21.1 MiB -
inventario_matta_cm656_07112024 248,220 MyISAM utf8_general_ci 20.6 MiB -
inventario_santiago_armazones_08012025 253,551 MyISAM utf8_general_ci 20.9 MiB -
inventario_shopping_27022025 257,434 MyISAM utf8_general_ci 21.3 MiB -
inventario_shopping_29012025 254,945 MyISAM utf8_general_ci 21.1 MiB -
inventario_shopping_norte_08112024 248,223 MyISAM utf8_general_ci 20.6 MiB -
inventario_shopping_norte_30122024 252,826 MyISAM utf8_general_ci 21 MiB -
inventario_ventas_seguridad_contactologia 252,925 MyISAM utf8_general_ci 20.9 MiB -
lineas_productos 7 MyISAM latin1_general_ci 2.2 KiB -
lista_precios_clientes 0 MyISAM latin1_swedish_ci 1 KiB -
movimiento_inventario 656,804 MyISAM utf8_general_ci 155 MiB 76 MiB
observacion_paciente 1,649 MyISAM latin1_swedish_ci 133.9 KiB -
oferta 8,856 MyISAM utf8_general_ci 1.1 MiB 3.2 KiB
ordenes_produccion ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
orden_compra 58,463 MyISAM utf8_general_ci 6.2 MiB -
orden_compra_clientes 83,708 MyISAM latin1_swedish_ci 9.1 MiB -
orden_compra_clientes_vales 133,351 MyISAM latin1_swedish_ci 4.9 MiB -
paciente 239,702 MyISAM latin1_swedish_ci 18.2 MiB -
pago 162,185 MyISAM utf8_general_ci 16.7 MiB -
parametros 26 MyISAM latin1_general_ci 4.3 KiB -
persona 9 MyISAM utf8_general_ci 2.4 KiB -
produccion_extra 208 MyISAM latin1_general_ci 17.6 KiB -
producto 359,700 MyISAM utf8_general_ci 64.3 MiB -
productos_clientes 3 MyISAM latin1_general_ci 2.1 KiB -
productos_sin_costo 2,574 InnoDB utf8_spanish_ci 128 KiB -
producto_antes_cambio_costos 239,187 MyISAM utf8_general_ci 37.8 MiB -
producto_antes_cambio_precio_contactologia 319,419 MyISAM utf8_general_ci 55.3 MiB -
producto_composicion 188 MyISAM latin1_general_ci 7.7 KiB -
producto_con_armazones_oferta 278,857 MyISAM utf8_general_ci 46.2 MiB -
producto_copy 353,540 MyISAM utf8_general_ci 63.3 MiB -
recepcion 119,895 MyISAM utf8_general_ci 11.6 MiB -
recepcion_copy 115,834 MyISAM utf8_general_ci 9.8 MiB -
recepcion_traspaso 19,769 InnoDB utf8_spanish_ci 1.5 MiB -
region 17 MyISAM utf8_general_ci 2.5 KiB -
reserva_laboratorio 66,665 MyISAM utf8_general_ci 6.6 MiB -
rrmm_salud 10 MyISAM latin1_swedish_ci 2.3 KiB -
sesiones 5,276 MyISAM latin1_swedish_ci 398.8 KiB -
sobre 318,874 MyISAM utf8_general_ci 41.7 MiB -
solicitudes_insumos 15,663 MyISAM latin1_swedish_ci 709.8 KiB -
subfamilia 275 MyISAM utf8_general_ci 16.7 KiB -
sucursal 18 MyISAM utf8_general_ci 5.4 KiB 1 KiB
tabla_precio 131 MyISAM utf8_general_ci 11.8 KiB -
tarjeta_coordenadas 50 MyISAM latin1_general_ci 3 KiB -
tecnico 59 MyISAM utf8_general_ci 5.9 KiB 116 B
tipos_comprobantes 5 MyISAM latin1_swedish_ci 2.1 KiB -
tipo_material 897 MyISAM utf8_general_ci 81.7 KiB -
toma_inventario 455 MyISAM utf8_general_ci 44 KiB 1.5 KiB
traspaso_inventario 26,381 MyISAM utf8_general_ci 2.3 MiB -
tratamiento 56 MyISAM utf8_general_ci 5.9 KiB -
tratamientos_cotizacion 351,283 MyISAM latin1_general_ci 11.2 MiB -
ultimos_precios_compra 120,585 InnoDB latin1_swedish_ci 6.5 MiB -
unidad 6 MyISAM utf8_general_ci 2.1 KiB -
usuario 71 MyISAM utf8_general_ci 19.1 KiB 180 B
vale_venta 110,805 MyISAM utf8_general_ci 18.7 MiB -
vendedor 142 MyISAM utf8_general_ci 11.6 KiB -
ventas 138,734 MyISAM utf8_general_ci 15 MiB -
xml 85,714 MyISAM latin1_general_ci 143.7 MiB -
149 tables Sum ~13,928,049 InnoDB latin1_swedish_ci 1.6 GiB 91.9 MiB

  Create table
Name:
Number of columns: