Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: optica_2023
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
accesos 188 MyISAM latin1_general_ci 16.5 KiB -
ayudas 3 MyISAM latin1_general_ci 2.2 KiB -
bitacora 75,811 MyISAM utf8_general_ci 7 MiB -
bodega 55 MyISAM utf8_general_ci 4.1 KiB -
bonos_vale_venta 10,497 MyISAM latin1_swedish_ci 389.4 KiB -
bonos_vale_venta_ant 8,974 MyISAM latin1_swedish_ci 296.9 KiB -
borrar 27 MyISAM latin1_general_ci 1.2 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 251,213 MyISAM utf8_general_ci 17.8 MiB -
cliente_particular_antes_actualizacion 126,816 MyISAM utf8_general_ci 8.4 MiB -
cliente_proveedor 3 MyISAM utf8_general_ci 3.4 KiB -
columna 2,546 MyISAM utf8_general_ci 87.7 KiB -
columna_copy 1,794 MyISAM utf8_general_ci 59 KiB -
comisiones_porcentajes 204 MyISAM latin1_general_ci 9.6 KiB -
cond_venta 22 MyISAM utf8_general_ci 2.7 KiB -
contacto 787 MyISAM utf8_general_ci 61.1 KiB -
cont_banco 7 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,661 MyISAM latin1_swedish_ci 88.3 KiB -
cont_ciudad 34 MyISAM latin1_swedish_ci 3.9 KiB -
cont_cliente_proveedor 1,485 MyISAM latin1_swedish_ci 297.8 KiB -
cont_cliente_proveedor_copy_antes_actualizacion 909 MyISAM latin1_swedish_ci 174.3 KiB -
cont_comportamiento_cuenta 11 MyISAM latin1_swedish_ci 2.3 KiB -
cont_comprobante 0 MyISAM latin1_swedish_ci 1 KiB -
cont_comprobante_pago 67,864 MyISAM latin1_swedish_ci 5.2 MiB -
cont_comuna 133 MyISAM utf8_general_ci 9.7 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 441 MyISAM latin1_swedish_ci 24.9 KiB -
cont_detalle_documento_venta 171,569 MyISAM latin1_swedish_ci 18.8 MiB -
cont_documento_venta 0 MyISAM latin1_swedish_ci 1 KiB -
cont_empresa 1 MyISAM utf8_general_ci 2.2 KiB -
cont_empresa_copy 1 MyISAM utf8_general_ci 2.1 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,181 MyISAM utf8_general_ci 89 KiB 228 B
convenio_antes_actualizacion 847 MyISAM utf8_general_ci 70.1 KiB -
costos 7,892 MyISAM latin1_general_ci 220.9 KiB -
cotizacion 149,204 MyISAM utf8_general_ci 13.8 MiB -
cotizacion_copy 149,140 MyISAM utf8_general_ci 13.8 MiB -
cuota_credito 0 MyISAM latin1_swedish_ci 1 KiB -
descuento_convenio 3,737 MyISAM utf8_general_ci 185.3 KiB -
descuento_convenio_antes_actualizacion 2,997 MyISAM utf8_general_ci 144.5 KiB -
detalle_convenio 1,546 MyISAM utf8_general_ci 153.4 KiB -
detalle_convenio_antes_actualizacion 1,194 MyISAM utf8_general_ci 99.6 KiB -
detalle_cotizacion 98 MyISAM utf8_general_ci 17.7 KiB -
detalle_cotizacion_copy 22 MyISAM utf8_general_ci 6 KiB -
detalle_devolucion 0 MyISAM utf8_general_ci 1 KiB -
detalle_devolucion_producto 503 MyISAM utf8_general_ci 24.5 KiB -
detalle_guia_despacho 43,374 MyISAM utf8_general_ci 4.3 MiB -
detalle_guia_despacho_ant 30,532 MyISAM utf8_general_ci 3 MiB -
detalle_ordenes_produccion 0 MyISAM latin1_general_ci 1 KiB -
detalle_orden_compra 176,197 MyISAM utf8_general_ci 26 MiB -
detalle_recepcion 140,689 MyISAM utf8_general_ci 6 MiB -
detalle_recepcion_traspaso 42,479 MyISAM utf8_spanish_ci 1.4 MiB -
detalle_solicitud_insumos 14,255 MyISAM latin1_swedish_ci 1.3 MiB -
detalle_tabla_precio 106,105 MyISAM latin1_general_ci 4 MiB 28 B
detalle_tabla_precio_copy 118,599 MyISAM latin1_general_ci 4.6 MiB -
detalle_traspaso 63,613 MyISAM utf8_general_ci 3.2 MiB -
detalle_vale_venta 102 MyISAM utf8_general_ci 15.3 KiB -
detalle_vale_venta_copy 300,797 MyISAM utf8_general_ci 41.6 MiB -
detalle_ventas 12,180 MyISAM utf8_general_ci 1.2 MiB -
detalle_ventas_ant 24 MyISAM utf8_general_ci 4.8 KiB -
deterioro_material 3,092 MyISAM utf8_general_ci 268.7 KiB -
deterioro_material_copy 3,089 MyISAM utf8_general_ci 256.4 KiB -
devolucion_productos 471 MyISAM utf8_general_ci 41.8 KiB -
doctor 364 MyISAM utf8_general_ci 25.6 KiB -
documento 8 MyISAM utf8_general_ci 2.4 KiB -
documentos_referencia 17,865 MyISAM latin1_swedish_ci 1.3 MiB -
documento_credito 0 MyISAM latin1_swedish_ci 1 KiB -
documento_dte 11 MyISAM utf8_general_ci 2.4 KiB -
empresa 297 MyISAM utf8_general_ci 54.7 KiB -
familia 13 MyISAM utf8_general_ci 2.4 KiB -
fecha_recepcion 0 MyISAM latin1_swedish_ci 2 KiB -
fila 9,264 MyISAM utf8_general_ci 535.1 KiB -
fila_copy 12,294 MyISAM utf8_general_ci 690.3 KiB -
folios 1 MyISAM latin1_swedish_ci 2 KiB -
forma_pago 14 MyISAM utf8_general_ci 2.4 KiB -
funcionario 30 MyISAM utf8_general_ci 3.5 KiB -
guia_despacho 30,657 MyISAM utf8_general_ci 3.4 MiB -
guia_despacho_ant 21,344 MyISAM utf8_general_ci 2.4 MiB -
industria 3 MyISAM utf8_general_ci 2.2 KiB -
interes 24 MyISAM utf8_general_ci 2.8 KiB -
inventario 466 MyISAM utf8_general_ci 33.6 KiB -
inventario_respaldo_29122022 131,023 MyISAM utf8_general_ci 10.9 MiB -
inv_ajuste_inventario 10 MyISAM utf8_general_ci 2.7 KiB -
inv_detalle_ajuste_inventario 1 MyISAM utf8_general_ci 3 KiB -
lineas_productos 7 MyISAM latin1_general_ci 2.2 KiB -
lista_precios_clientes 0 MyISAM latin1_swedish_ci 2 KiB 36 B
movimiento_inventario 1,030,246 MyISAM utf8_general_ci 90.2 MiB -
observacion_paciente 1,649 MyISAM latin1_swedish_ci 133.9 KiB -
oferta 8,780 MyISAM utf8_general_ci 1.1 MiB -
ordenes_produccion 0 MyISAM latin1_general_ci 1 KiB -
orden_compra 29,152 MyISAM utf8_general_ci 2.8 MiB -
orden_compra_clientes 55,832 MyISAM latin1_swedish_ci 5 MiB -
orden_compra_clientes_copy 51,432 MyISAM latin1_swedish_ci 4.4 MiB -
orden_compra_clientes_copy1 51,453 MyISAM latin1_swedish_ci 4.4 MiB -
orden_compra_clientes_respaldo 51,474 MyISAM latin1_swedish_ci 4.4 MiB -
orden_compra_clientes_vales 61,597 MyISAM latin1_swedish_ci 2.3 MiB -
paciente 232,906 MyISAM latin1_swedish_ci 16.5 MiB -
paciente_antes_actualizacion 159,111 MyISAM latin1_swedish_ci 10.7 MiB -
pago 81,056 MyISAM utf8_general_ci 7.4 MiB -
parametros 23 MyISAM latin1_general_ci 3.9 KiB -
parametros_ant 5 MyISAM latin1_general_ci 2.3 KiB -
paso 47 MyISAM latin1_swedish_ci 2.1 KiB -
persona 9 MyISAM utf8_general_ci 2.4 KiB -
precios_compra 0 MyISAM latin1_general_ci 1 KiB -
produccion_extra 1 MyISAM latin1_general_ci 2 KiB -
producto 25 MyISAM utf8_general_ci 5 KiB -
productos_clientes 3 MyISAM latin1_general_ci 2.1 KiB -
productos_sin_costo 2,574 MyISAM utf8_spanish_ci 51.3 KiB -
producto_antes_cambio_costos 239,187 MyISAM utf8_general_ci 38.8 MiB -
producto_antes_cambio_neto_06092020 268,313 MyISAM utf8_general_ci 45.4 MiB -
producto_composicion 140 MyISAM latin1_general_ci 6.7 KiB -
producto_respaldo_29122022 276,182 MyISAM utf8_general_ci 46.8 MiB -
recepcion 47,757 MyISAM utf8_general_ci 3.4 MiB -
recepcion_traspaso 8,856 MyISAM utf8_spanish_ci 413 KiB -
region 16 MyISAM utf8_general_ci 2.4 KiB -
reserva_laboratorio 7,683 MyISAM utf8_general_ci 722.7 KiB -
rrmm_ficha_bodega 2 MyISAM latin1_swedish_ci 2.1 KiB -
rrmm_salud 10 MyISAM latin1_swedish_ci 2.3 KiB -
rut_defontana 2,000 MyISAM latin1_swedish_ci 40.1 KiB -
sesiones 5,276 MyISAM latin1_swedish_ci 320 KiB -
sobre 132,800 MyISAM utf8_general_ci 15 MiB -
solicitudes_insumos 3 MyISAM latin1_swedish_ci 2.1 KiB -
subfamilia 266 MyISAM utf8_general_ci 16.3 KiB -
sucursal 27 MyISAM utf8_general_ci 5 KiB -
tabla_precio 128 MyISAM utf8_general_ci 11.5 KiB -
tabla_precio_antes_cambio_a_neto 72 MyISAM utf8_general_ci 6 KiB -
tarjeta_coordenadas 50 MyISAM latin1_general_ci 3 KiB -
tecnico 56 MyISAM utf8_general_ci 4.5 KiB -
tipos_comprobantes 5 MyISAM latin1_swedish_ci 2.1 KiB -
tipo_material 892 MyISAM utf8_general_ci 81.9 KiB -
tipo_material_copy 1,626 MyISAM utf8_general_ci 175.2 KiB -
toma_inventario 0 MyISAM utf8_general_ci 1 KiB -
toma_inventario_copy 215 MyISAM utf8_general_ci 19 KiB -
traspaso_inventario 13,599 MyISAM utf8_general_ci 1.1 MiB -
tratamiento 39 MyISAM utf8_general_ci 4.4 KiB -
tratamientos_cotizacion 4 MyISAM latin1_general_ci 2.1 KiB -
tratamientos_cotizacion_copy 131,571 MyISAM latin1_general_ci 4.1 MiB -
ultimos_precios_compra 12,928 MyISAM latin1_swedish_ci 369.4 KiB -
unidad 6 MyISAM utf8_general_ci 2.1 KiB -
usuario 44 MyISAM utf8_general_ci 12.3 KiB -
usuario_vacio 1 MyISAM utf8_general_ci 2.2 KiB -
vale_venta 80 MyISAM utf8_general_ci 11.8 KiB -
vale_venta_copy 114,264 MyISAM utf8_general_ci 17.9 MiB -
vendedor 96 MyISAM utf8_general_ci 7.1 KiB -
ventas 15,664 MyISAM utf8_general_ci 1.6 MiB -
ventas_ant 258 MyISAM utf8_general_ci 29.3 KiB -
156 tables Sum 5,419,605 InnoDB latin1_swedish_ci 529.9 MiB 292 B

  Create table
Name:
Number of columns: