Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: optica_2021
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,800 MyISAM utf8_general_ci 7 MiB -
bitacora_tracking ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
bodega 49 MyISAM utf8_general_ci 3.8 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 InnoDB latin1_general_ci 16 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 126,806 MyISAM utf8_general_ci 8.4 MiB -
cliente_proveedor 3 MyISAM utf8_general_ci 3.4 KiB -
columna 1,468 MyISAM utf8_general_ci 48.7 KiB -
columna_copy 2,259 MyISAM utf8_general_ci 78.1 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 909 MyISAM latin1_swedish_ci 173.4 KiB 20 B
cont_cliente_proveedor_2 645 MyISAM latin1_swedish_ci 112.8 KiB -
cont_cliente_proveedor_copy 756 MyISAM latin1_swedish_ci 143.8 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,892 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 438 MyISAM latin1_swedish_ci 24.8 KiB -
cont_detalle_documento_venta 171,662 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_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 849 MyISAM utf8_general_ci 70.2 KiB -
costos 7,892 InnoDB latin1_general_ci 432 KiB -
cotizacion 149,163 MyISAM utf8_general_ci 13.8 MiB -
cotizacion_copy 149,160 MyISAM utf8_general_ci 13.8 MiB -
cuota_credito 0 MyISAM latin1_swedish_ci 1 KiB -
descuento_convenio 2,997 MyISAM utf8_general_ci 144.5 KiB -
detalle_convenio 1,194 MyISAM utf8_general_ci 94.1 KiB -
detalle_cotizacion 466,961 MyISAM utf8_general_ci 74.9 MiB -
detalle_cotizacion_copy 466,950 MyISAM utf8_general_ci 74.9 MiB -
detalle_devolucion 0 MyISAM utf8_general_ci 1 KiB -
detalle_devolucion_producto 502 MyISAM utf8_general_ci 24.4 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 This view has at least this number of rows. Please refer to documentation. View --- - -
detalle_orden_compra 176,185 MyISAM utf8_general_ci 24.9 MiB -
detalle_recepcion 140,688 MyISAM utf8_general_ci 6 MiB -
detalle_recepcion_traspaso 42,479 InnoDB utf8_spanish_ci 2.5 MiB -
detalle_solicitud_insumos 3 MyISAM latin1_swedish_ci 2.2 KiB -
detalle_tabla_precio 112,166 MyISAM latin1_general_ci 4.4 MiB -
detalle_tabla_precio_copy 79,042 MyISAM latin1_general_ci 3.3 MiB -
detalle_tabla_precio_copy1 79,042 MyISAM latin1_general_ci 3.3 MiB -
detalle_traspaso 63,613 MyISAM utf8_general_ci 3.2 MiB -
detalle_vale_venta 300,970 MyISAM utf8_general_ci 41.6 MiB -
detalle_ventas 12,268 MyISAM utf8_general_ci 1.2 MiB -
detalle_ventas_ant 24 MyISAM utf8_general_ci 4.8 KiB -
deterioro_material 3,089 MyISAM utf8_general_ci 316.8 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 12,294 MyISAM utf8_general_ci 692.3 KiB -
fila_ant 5,017 MyISAM utf8_general_ci 287.5 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 130,988 MyISAM utf8_general_ci 10.6 MiB -
inventario_antes_cambio_neto_06092020 122,356 MyISAM utf8_general_ci 10.2 MiB -
inventario_baquedano_29022020 111,305 MyISAM utf8_general_ci 9.2 MiB -
inventario_central5_21122020 130,970 MyISAM utf8_general_ci 10.6 MiB -
inventario_central5_armazones_17012020 107,726 MyISAM utf8_general_ci 9 MiB -
inventario_central5_lentes_sol_21012020 107,942 MyISAM utf8_general_ci 9.1 MiB -
inventario_central5_liq_lentes_contacto_24012020 108,313 MyISAM utf8_general_ci 9.1 MiB -
inventario_iquique7_04032020 111,630 MyISAM utf8_general_ci 9.3 MiB -
inventario_matta_29082020 121,691 MyISAM utf8_general_ci 10 MiB -
inventario_prat_04052020 115,569 MyISAM utf8_general_ci 9.6 MiB -
inventario_prat_09102020 124,695 MyISAM utf8_general_ci 10.3 MiB -
inventario_prat_22022020 110,483 MyISAM utf8_general_ci 9.3 MiB -
inventario_prat_25092020 123,686 MyISAM utf8_general_ci 10.2 MiB -
inventario_prat_28082020 121,622 MyISAM utf8_general_ci 10.1 MiB -
inventario_prat_30102020 126,282 MyISAM utf8_general_ci 10.4 MiB -
inventario_ventas4_01082020 119,963 MyISAM utf8_general_ci 9.9 MiB -
inventario_ventas4_04022020 108,958 MyISAM utf8_general_ci 9.2 MiB -
inventario_ventas4_04052020 115,604 MyISAM utf8_general_ci 9.6 MiB -
inventario_ventas4_05022020 109,107 MyISAM utf8_general_ci 9.1 MiB -
inventario_ventas4_05032020 111,672 MyISAM utf8_general_ci 9.3 MiB -
inventario_ventas4_27102020 126,076 MyISAM utf8_general_ci 10.4 MiB -
inventario_ventas4_30062020 118,568 MyISAM utf8_general_ci 9.8 MiB -
inventario_ventas4_31082020 121,878 MyISAM utf8_general_ci 10.1 MiB -
lineas_productos 7 MyISAM latin1_general_ci 2.2 KiB -
lista_precios_clientes 13 MyISAM latin1_swedish_ci 2.5 KiB -
movimiento_inventario 1,030,276 MyISAM utf8_general_ci 90.3 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 This view has at least this number of rows. Please refer to documentation. View --- - -
orden_compra 29,137 MyISAM utf8_general_ci 2.8 MiB -
orden_compra_clientes 55,833 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,599 MyISAM latin1_swedish_ci 2.3 MiB -
paciente 159,106 MyISAM latin1_swedish_ci 10.7 MiB 40 B
paciente_copy 150,768 MyISAM latin1_swedish_ci 10 MiB -
paciente_copy1 152,307 MyISAM latin1_swedish_ci 10.1 MiB -
paciente_copy2 152,387 MyISAM latin1_swedish_ci 10.1 MiB -
pago 81,080 MyISAM utf8_general_ci 7.4 MiB -
parametros 22 MyISAM latin1_general_ci 3.8 KiB -
parametros_ant 22 MyISAM latin1_general_ci 3.8 KiB -
paso 47 InnoDB latin1_swedish_ci 16 KiB -
persona 9 MyISAM utf8_general_ci 2.4 KiB -
precios_compra 0 InnoDB latin1_general_ci 16 KiB -
produccion_extra 1 MyISAM latin1_general_ci 2 KiB -
producto 276,185 MyISAM utf8_general_ci 46.8 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 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 -
recepcion 47,756 MyISAM utf8_general_ci 3.4 MiB 36 B
recepcion_traspaso 8,856 InnoDB utf8_spanish_ci 528 KiB -
region 16 MyISAM utf8_general_ci 2.4 KiB -
reserva_laboratorio 7,679 MyISAM utf8_general_ci 722.4 KiB -
rrmm_salud 10 MyISAM latin1_swedish_ci 2.3 KiB -
rut_defontana 2,000 InnoDB latin1_swedish_ci 112 KiB -
sesiones 5,276 MyISAM latin1_swedish_ci 320 KiB -
sobre 132,777 MyISAM utf8_general_ci 15 MiB 20 B
solicitudes_insumos 4 MyISAM latin1_swedish_ci 2.1 KiB -
subfamilia 266 MyISAM utf8_general_ci 16.3 KiB -
sucursal 24 MyISAM utf8_general_ci 5 KiB -
tabla_precio 271 MyISAM utf8_general_ci 26.1 KiB -
tabla_precio_antes_cambio_a_neto 72 MyISAM utf8_general_ci 6 KiB -
tabla_precio_copy 156 MyISAM utf8_general_ci 14.5 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 1,517 MyISAM utf8_general_ci 176.5 KiB -
tipo_material_copy 478 MyISAM utf8_general_ci 51.1 KiB -
toma_inventario 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 131,563 MyISAM latin1_general_ci 4.1 MiB -
ultimos_precios_compra 12,928 InnoDB latin1_swedish_ci 1.5 MiB -
unidad 6 MyISAM utf8_general_ci 2.1 KiB -
usuario 8 MyISAM utf8_general_ci 12.1 KiB 8.2 KiB
usuario_chico 2 MyISAM utf8_general_ci 12.1 KiB 9.6 KiB
usuario_respaldo18072022 43 MyISAM utf8_general_ci 12.1 KiB -
usuario_vacio 1 MyISAM utf8_general_ci 2.2 KiB -
vale_venta 114,312 MyISAM utf8_general_ci 17.9 MiB -
vendedor 96 MyISAM utf8_general_ci 7.1 KiB 20 B
ventas 15,690 MyISAM utf8_general_ci 1.6 MiB -
ventas_ant 258 MyISAM utf8_general_ci 29.3 KiB -
171 tables Sum ~8,917,112 InnoDB latin1_swedish_ci 891 MiB 17.9 KiB

  Create table
Name:
Number of columns: