Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: optica_2019
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 63,157 MyISAM utf8_general_ci 5.9 MiB -
bitacora_tracking ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
bodega 46 MyISAM utf8_general_ci 3.7 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 101,474 MyISAM utf8_general_ci 6.2 MiB -
cliente_proveedor 3 MyISAM utf8_general_ci 3.4 KiB -
columna 1,619 MyISAM utf8_general_ci 56.6 KiB 20 B
contacto 170 MyISAM utf8_general_ci 16.8 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,508 MyISAM latin1_swedish_ci 79.6 KiB -
cont_ciudad 28 MyISAM latin1_swedish_ci 3.8 KiB -
cont_cliente_proveedor 758 MyISAM latin1_swedish_ci 145.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 51,149 MyISAM latin1_swedish_ci 3.6 MiB -
cont_comuna 129 MyISAM utf8_general_ci 9.8 KiB 124 B
cont_cuenta 245 MyISAM latin1_swedish_ci 23.4 KiB -
cont_detalle_comprobante 0 MyISAM latin1_swedish_ci 1 KiB -
cont_detalle_comprobante_pago 204 MyISAM latin1_swedish_ci 12.4 KiB -
cont_detalle_documento_venta 128,293 MyISAM latin1_swedish_ci 14.1 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 719 MyISAM utf8_general_ci 61.8 KiB -
costos 7,892 InnoDB latin1_general_ci 432 KiB -
cotizacion 115,959 MyISAM utf8_general_ci 10.5 MiB -
cuota_credito 0 MyISAM latin1_swedish_ci 1 KiB -
descuento_convenio 2,713 MyISAM utf8_general_ci 130.9 KiB -
detalle_convenio 1,052 MyISAM utf8_general_ci 83.7 KiB -
detalle_cotizacion 365,168 MyISAM utf8_general_ci 57.8 MiB -
detalle_devolucion 0 MyISAM utf8_general_ci 1 KiB -
detalle_devolucion_producto 399 MyISAM utf8_general_ci 22.1 KiB -
detalle_guia_despacho 30,427 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 136,286 MyISAM utf8_general_ci 19.3 MiB 52 B
detalle_recepcion 110,740 MyISAM utf8_general_ci 4.7 MiB -
detalle_recepcion_traspaso 28,275 InnoDB utf8_spanish_ci 1.5 MiB -
detalle_tabla_precio 57,983 MyISAM latin1_general_ci 2.4 MiB -
detalle_traspaso 49,168 MyISAM utf8_general_ci 2.3 MiB -
detalle_vale_venta 224,895 MyISAM utf8_general_ci 31.4 MiB -
detalle_ventas 0 MyISAM utf8_general_ci 1 KiB -
deterioro_material 2,421 MyISAM utf8_general_ci 202.3 KiB -
devolucion_productos 380 MyISAM utf8_general_ci 35.8 KiB -
doctor 310 MyISAM utf8_general_ci 23 KiB -
documento 8 MyISAM utf8_general_ci 2.4 KiB -
documento_credito 0 MyISAM latin1_swedish_ci 1 KiB -
empresa 284 MyISAM utf8_general_ci 52.7 KiB -
familia 13 MyISAM utf8_general_ci 2.3 KiB -
fecha_recepcion 0 MyISAM latin1_swedish_ci 2 KiB -
fila 5,017 MyISAM utf8_general_ci 287.5 KiB -
forma_pago 10 MyISAM utf8_general_ci 2.2 KiB -
funcionario 30 MyISAM utf8_general_ci 3.5 KiB -
guia_despacho 21,261 MyISAM utf8_general_ci 2.4 MiB -
guia_despacho_copy 14,048 MyISAM utf8_general_ci 1.6 MiB -
industria 3 MyISAM utf8_general_ci 2.2 KiB -
interes 24 MyISAM utf8_general_ci 2.8 KiB -
inventario 107,244 MyISAM utf8_general_ci 9.4 MiB -
inventario_2018 72,072 MyISAM utf8_general_ci 6 MiB -
inventario_baquedano_05112019 101,719 MyISAM utf8_general_ci 8.6 MiB -
inventario_baquedano_27092019 98,588 MyISAM utf8_general_ci 8.4 MiB -
inventario_baquedano_28082019 96,254 MyISAM utf8_general_ci 8.1 MiB -
inventario_calama_03012020 106,841 MyISAM utf8_general_ci 8.9 MiB -
inventario_central_seguridad_15122019 106,016 MyISAM utf8_general_ci 8.9 MiB -
inventario_colipi09092019 97,314 MyISAM utf8_general_ci 8.2 MiB -
inventario_colipi_09102019 100,107 MyISAM utf8_general_ci 8.5 MiB -
inventario_contactologia_30122019 106,640 MyISAM utf8_general_ci 8.9 MiB -
inventario_iquique7_06012020 106,917 MyISAM utf8_general_ci 8.9 MiB -
inventario_laserena06012020 106,916 MyISAM utf8_general_ci 8.9 MiB -
inventario_loscarrera03012020 106,844 MyISAM utf8_general_ci 8.9 MiB -
inventario_loscarrera10092019 97,371 MyISAM utf8_general_ci 8.2 MiB -
inventario_loscarrera_09102019 100,173 MyISAM utf8_general_ci 8.5 MiB -
inventario_matta_09112019 102,039 MyISAM utf8_general_ci 8.6 MiB -
inventario_matta_28092019 98,671 MyISAM utf8_general_ci 8.4 MiB -
inventario_matta_28122019 106,634 MyISAM utf8_general_ci 8.9 MiB -
inventario_matta_30112019 104,346 MyISAM utf8_general_ci 8.8 MiB -
inventario_prat_05112019 101,655 MyISAM utf8_general_ci 8.6 MiB -
inventario_prat_26092019 98,487 MyISAM utf8_general_ci 8.4 MiB -
inventario_prat_27082019 96,104 MyISAM utf8_general_ci 8.1 MiB -
inventario_prat_28112019 103,984 MyISAM utf8_general_ci 8.8 MiB -
inventario_prat_31122019 106,692 MyISAM utf8_general_ci 8.8 MiB -
inventario_santiago_08012020 106,986 MyISAM utf8_general_ci 8.9 MiB -
inventario_seguridad_03012020 106,837 MyISAM utf8_general_ci 8.9 MiB -
inventario_ventas4_06112019 101,740 MyISAM utf8_general_ci 8.6 MiB -
inventario_ventas4_25092019 98,349 MyISAM utf8_general_ci 8.3 MiB -
inventario_ventas4_29112019 104,135 MyISAM utf8_general_ci 8.8 MiB -
inventario_ventas4_30082019 96,612 MyISAM utf8_general_ci 8.2 MiB -
movimiento_inventario 806,170 MyISAM utf8_general_ci 69.9 MiB -
observacion_paciente 1,649 MyISAM latin1_swedish_ci 133.9 KiB -
oferta 7,436 MyISAM utf8_general_ci 961.5 KiB -
ordenes_produccion ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
orden_compra 22,984 MyISAM utf8_general_ci 2.2 MiB -
paciente 140,397 MyISAM latin1_swedish_ci 9.2 MiB -
pago 62,892 MyISAM utf8_general_ci 5.4 MiB -
parametros 5 MyISAM latin1_general_ci 2.3 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 256,237 MyISAM utf8_general_ci 43.7 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_composicion 86 MyISAM latin1_general_ci 3.7 KiB -
recepcion 37,622 MyISAM utf8_general_ci 2.7 MiB -
recepcion_traspaso 5,814 InnoDB utf8_spanish_ci 256 KiB -
region 14 MyISAM utf8_general_ci 2.4 KiB -
reserva_laboratorio 7,604 MyISAM utf8_general_ci 715.3 KiB -
rrmm_salud 10 MyISAM latin1_swedish_ci 2.3 KiB -
sobre 104,115 MyISAM utf8_general_ci 11.8 MiB -
subfamilia 266 MyISAM utf8_general_ci 16.3 KiB -
sucursal 22 MyISAM utf8_general_ci 4.1 KiB -
tabla_precio 81 MyISAM utf8_general_ci 6.7 KiB -
tarjeta_coordenadas 50 MyISAM latin1_general_ci 3 KiB -
tecnico 48 MyISAM utf8_general_ci 4.2 KiB -
tipos_comprobantes 5 MyISAM latin1_swedish_ci 2.1 KiB -
tipo_material 512 MyISAM utf8_general_ci 45.1 KiB -
toma_inventario 186 MyISAM utf8_general_ci 16.6 KiB -
traspaso_inventario 10,453 MyISAM utf8_general_ci 848.6 KiB -
tratamiento 40 MyISAM utf8_general_ci 4.4 KiB -
tratamientos_cotizacion 90,745 MyISAM latin1_general_ci 2.7 MiB -
unidad 6 MyISAM utf8_general_ci 2.1 KiB -
usuario 4 MyISAM utf8_general_ci 11.5 KiB 8.6 KiB
usuario_copy 41 MyISAM utf8_general_ci 11.5 KiB -
vale_venta 88,384 MyISAM utf8_general_ci 14 MiB -
vendedor 88 MyISAM utf8_general_ci 6.7 KiB -
ventas 237 MyISAM utf8_general_ci 25.9 KiB -
137 tables Sum ~6,455,786 InnoDB latin1_swedish_ci 628.5 MiB 8.7 KiB

  Create table
Name:
Number of columns: