186.10.255.215:81 / localhost / optica2_2021

Recent`optica_2019`.`paso`
`mysql`.`help_relation`
`optica2_2021`.`tarjetas_debito_venta`
`optica2_2021`.`productos`
`optica_2023`.`detalle_recepcion`
`optica2_2021`.`movimientos_cuenta_corriente`
`optica_2023`.`tecnico`
`optica_2023`.`producto_antes_cambio_costos`
`optica_2023`.`detalle_cotizacion`
`optica2_2021`.`orden_trabajo`
FavoritesThere are no favorite tables.
New
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==cm9vdA==.b3B0aWNh0
 optica
cm9vdA==cm9vdA==.b3B0aWNh.MjAxOQ==0
 2019
cm9vdA==.b3B0aWNhXzIwMTk=cm9vdA==.b3B0aWNh.MjAxOQ==.0
optica_2019
cm9vdA==.b3B0aWNhXzIwMTlfdHJhY2tpbmc=cm9vdA==.b3B0aWNh.MjAxOQ==.dHJhY2tpbmc=0
optica_2019_tracking
cm9vdA==cm9vdA==.b3B0aWNh.MjAyMA==0
 2020
cm9vdA==.b3B0aWNhXzIwMjA=cm9vdA==.b3B0aWNh.MjAyMA==.0
optica_2020
cm9vdA==.b3B0aWNhXzIwMjBfMTYwMjIwMjI=cm9vdA==.b3B0aWNh.MjAyMA==.MTYwMjIwMjI=0
optica_2020_16022022
cm9vdA==.b3B0aWNhXzIwMjBfYW50ZXNfZWxpbWluYXJfYm9kZWdhc18wNDA4MjAyNA==cm9vdA==.b3B0aWNh.MjAyMA==.YW50ZXNfZWxpbWluYXJfYm9kZWdhc18wNDA4MjAyNA==0
optica_2020_antes_eliminar_bodegas_04082024
cm9vdA==.b3B0aWNhXzIwMjBfdGVzdA==cm9vdA==.b3B0aWNh.MjAyMA==.dGVzdA==0
optica_2020_test
cm9vdA==.b3B0aWNhXzIwMjE=cm9vdA==.b3B0aWNh.MjAyMQ==0
optica_2021
cm9vdA==.b3B0aWNhXzIwMjM=cm9vdA==.b3B0aWNh.MjAyMw==0
optica_2023
cm9vdA==.b3B0aWNhX2RlZm9udGFuYQ==cm9vdA==.b3B0aWNh.ZGVmb250YW5h0
optica_defontana
cm9vdA==.b3B0aWNhX2dlc3Rpb24=cm9vdA==.b3B0aWNh.Z2VzdGlvbg==0
optica_gestion
cm9vdA==.b3B0aWNhMl8yMDIxcm9vdA==.b3B0aWNhMl8yMDIx0
optica2_2021
cm9vdA==.b3B0aWNhMjJfMjAyMQ==cm9vdA==.b3B0aWNhMjJfMjAyMQ==0
optica22_2021
cm9vdA==.b3B0aWNhMjAyMl9jcmlzdGFsZXM=cm9vdA==.b3B0aWNhMjAyMl9jcmlzdGFsZXM=0
optica2022_cristales
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0
phpmyadmin
cm9vdA==.dGVzdA==cm9vdA==.dGVzdA==0
test
cm9vdA==cm9vdA==.dHJhY2tpbmc=0
 tracking
cm9vdA==cm9vdA==.dHJhY2tpbmc=.b3B0aWNh0
 optica
cm9vdA==.dHJhY2tpbmdfb3B0aWNhcm9vdA==.dHJhY2tpbmc=.b3B0aWNh.0
tracking_optica
cm9vdA==.dHJhY2tpbmdfb3B0aWNhXzIwMjI=cm9vdA==.dHJhY2tpbmc=.b3B0aWNh.MjAyMg==0
tracking_optica_2022

Navigation panel
Navigation tree
Databases
Tables

Navigation panel

Customize appearance of the navigation panel.

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.

Navigation tree

Customize the navigation tree.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree

Databases

Databases display options.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables

Tables display options.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x-

Server: localhost »

Database: optica2_2021

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

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

Database structure

Database structure

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

Show table charset Show or hide a column displaying the charset for all tables.
Show table comments Show or hide a column displaying the comments for all tables.
Show creation timestamp Show or hide a column displaying the Creation timestamp for all tables.
Show last update timestamp Show or hide a column displaying the Last update timestamp for all tables.
Show last check timestamp Show or hide a column displaying the Last check timestamp for all tables.

Filters

Containing the word:

Table	Action							Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11.	Type	Collation	Size	Overhead
actividades		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
actividades_clientes		Browse	Structure	Search	Insert	Empty	Drop	11	MyISAM	latin1_swedish_ci	2.3 KiB	-
apertura		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
asignaciones		Browse	Structure	Search	Insert	Empty	Drop	72	MyISAM	latin1_swedish_ci	6.4 KiB	-
asignados		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
atributo		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
bitacora		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
bodega		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	utf8_general_ci	2 KiB	-
boletascanceladas		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
caja_chica		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	latin1_swedish_ci	2 KiB	-
capturador		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
cheques_venta		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
ciudad		Browse	Structure	Search	Insert	Empty	Drop	42	MyISAM	utf8_general_ci	3 KiB	-
clasificacion_productos		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
clientes_actividades		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	latin1_general_ci	2 KiB	-
cmn_configuracion_agenda		Browse	Structure	Search	Insert	Empty	Drop	38,666	MyISAM	latin1_swedish_ci	2 MiB	-
codigo_descuento		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	utf8_general_ci	2 KiB	-
cond_venta		Browse	Structure	Search	Insert	Empty	Drop	8	MyISAM	utf8_general_ci	2.2 KiB	-
cont_cheque		Browse	Structure	Search	Insert	Empty	Drop	17	MyISAM	utf8_general_ci	3.7 KiB	-
cont_cliente_proveedor		Browse	Structure	Search	Insert		Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
cont_cliente_proveedor_ant		Browse	Structure	Search	Insert	Empty	Drop	141	MyISAM	utf8_general_ci	19.8 KiB	-
cont_comprobante		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
cont_comprobante_pago		Browse	Structure	Search	Insert	Empty	Drop	266	MyISAM	utf8_general_ci	37.5 KiB	-
cont_comuna		Browse	Structure	Search	Insert	Empty	Drop	33	MyISAM	utf8_general_ci	3.7 KiB	-
cont_contacto		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
cont_detalle_comprobante		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
cont_detalle_comprobante_pago		Browse	Structure	Search	Insert	Empty	Drop	269	MyISAM	utf8_general_ci	20.3 KiB	-
cont_observacion_comercial		Browse	Structure	Search	Insert	Empty	Drop	526	MyISAM	utf8_general_ci	18.3 KiB	-
cont_sub_centro_costo		Browse	Structure	Search	Insert	Empty	Drop	8	MyISAM	latin1_swedish_ci	4.5 KiB	-
convenios		Browse	Structure	Search	Insert	Empty	Drop	51	MyISAM	latin1_swedish_ci	6.8 KiB	-
cotizacion		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
cuenta_corriente_clientes		Browse	Structure	Search	Insert	Empty	Drop	2	MyISAM	latin1_general_ci	2 KiB	-
cuenta_corriente_cliente_proveedor		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	latin1_swedish_ci	2 KiB	-
cupones_deposito		Browse	Structure	Search	Insert	Empty	Drop	1,595	MyISAM	latin1_swedish_ci	78.9 KiB	-
cupones_deposito_copy		Browse	Structure	Search	Insert	Empty	Drop	1,023	MyISAM	latin1_swedish_ci	49 KiB	-
depositos		Browse	Structure	Search	Insert	Empty	Drop	15,533	MyISAM	latin1_swedish_ci	1.2 MiB	-
detalle_cotizacion		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
detalle_devolucion		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
detalle_devolucion_producto		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
detalle_documento_ventas		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
detalle_nota_venta		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
detalle_orden_compra		Browse	Structure	Search	Insert	Empty	Drop	38	MyISAM	utf8_general_ci	6.4 KiB	-
detalle_pagos		Browse	Structure	Search	Insert	Empty	Drop	34,507	MyISAM	latin1_swedish_ci	1.1 MiB	-
detalle_paquete		Browse	Structure	Search	Insert	Empty	Drop	40	MyISAM	latin1_swedish_ci	4.2 KiB	-
detalle_producto		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
detalle_recepcion		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	utf8_general_ci	3 KiB	-
detalle_traspaso		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
detalle_ventas		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
devolucion		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
devolucion_productos		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
documento		Browse	Structure	Search	Insert	Empty	Drop	7	MyISAM	utf8_general_ci	2.2 KiB	-
documentos		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
documentos_referencia		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
documento_compra		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
documento_rendicion		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
documento_venta		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
documento_ventas		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
dtebox_out		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
empresa		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	utf8_general_ci	2.2 KiB	-
empresas		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	latin1_general_ci	2.1 KiB	-
familia		Browse	Structure	Search	Insert		Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
familia_ant		Browse	Structure	Search	Insert	Empty	Drop	11	MyISAM	utf8_general_ci	2.3 KiB	-
folios		Browse	Structure	Search	Insert	Empty	Drop	4	MyISAM	latin1_swedish_ci	2.2 KiB	-
forma_pago		Browse	Structure	Search	Insert	Empty	Drop	7	MyISAM	utf8_general_ci	2.2 KiB	-
guias_traslado		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
inventario		Browse	Structure	Search	Insert	Empty	Drop	1,620	MyISAM	utf8_general_ci	101.4 KiB	-
inventario_ant		Browse	Structure	Search	Insert	Empty	Drop	2,074	MyISAM	utf8_general_ci	157.8 KiB	-
inv_ajuste_inventario		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
inv_comprador		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
inv_detalle_ajuste_inventario		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
inv_tipo_ajuste_inventario		Browse	Structure	Search	Insert	Empty	Drop	2	MyISAM	utf8_general_ci	2.1 KiB	-
movimientos_cuenta_corriente		Browse	Structure	Search	Insert	Empty	Drop	89	MyISAM	latin1_swedish_ci	7.4 KiB	-
movimiento_inventario		Browse	Structure	Search	Insert	Empty	Drop	4	MyISAM	utf8_general_ci	2.3 KiB	-
nota_venta		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
oferta		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_general_ci	1 KiB	-
orden_compra		Browse	Structure	Search	Insert	Empty	Drop	27	MyISAM	utf8_general_ci	4.2 KiB	-
orden_trabajo		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
pagos		Browse	Structure	Search	Insert	Empty	Drop	37,440	MyISAM	latin1_swedish_ci	3.4 MiB	-
pagos_copy		Browse	Structure	Search	Insert	Empty	Drop	36,913	MyISAM	latin1_swedish_ci	3.4 MiB	-
pagos_reservas		Browse	Structure	Search	Insert	Empty	Drop	36,237	MyISAM	latin1_swedish_ci	1.9 MiB	-
pagos_reservas_copy		Browse	Structure	Search	Insert	Empty	Drop	36,001	MyISAM	latin1_swedish_ci	1.7 MiB	-
pagos_reservas_copy1		Browse	Structure	Search	Insert	Empty	Drop	35,966	MyISAM	latin1_swedish_ci	1.7 MiB	-
pagos_servicios		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_general_ci	1 KiB	-
paquetes		Browse	Structure	Search	Insert	Empty	Drop	28	MyISAM	latin1_general_ci	4.1 KiB	-
paquetes_clientes		Browse	Structure	Search	Insert	Empty	Drop	75	MyISAM	latin1_swedish_ci	5.8 KiB	-
paquetes_cliente_detalle		Browse	Structure	Search	Insert	Empty	Drop	139	MyISAM	latin1_swedish_ci	14.7 KiB	-
parametros		Browse	Structure	Search	Insert	Empty	Drop	2	MyISAM	utf8_general_ci	2 KiB	-
plazas		Browse	Structure	Search	Insert	Empty	Drop	193	MyISAM	latin1_swedish_ci	8.2 KiB	-
prestador		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_general_ci	1 KiB	-
producto		Browse	Structure	Search	Insert		Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
productos		Browse	Structure	Search	Insert	Empty	Drop	39	MyISAM	utf8_general_ci	10.6 KiB	-
propaganda		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	latin1_swedish_ci	2 KiB	-
proyectos		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
recepcion		Browse	Structure	Search	Insert	Empty	Drop	2	MyISAM	utf8_general_ci	3.3 KiB	-
region		Browse	Structure	Search	Insert	Empty	Drop	15	MyISAM	utf8_general_ci	2.3 KiB	-
rendiciones		Browse	Structure	Search	Insert	Empty	Drop	1,674	MyISAM	latin1_swedish_ci	201 KiB	-
res_bloqueo		Browse	Structure	Search	Insert	Empty	Drop	13	MyISAM	latin1_swedish_ci	3.1 KiB	-
res_reserva		Browse	Structure	Search	Insert	Empty	Drop	36,953	MyISAM	latin1_swedish_ci	4.3 MiB	-
res_reserva_copy		Browse	Structure	Search	Insert	Empty	Drop	29,807	MyISAM	latin1_swedish_ci	3.1 MiB	-
rrmm_bancos		Browse	Structure	Search	Insert	Empty	Drop	29	MyISAM	utf8_general_ci	2.7 KiB	-
rrmm_ficha_bodega		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
servicios_zonas		Browse	Structure	Search	Insert	Empty	Drop	7	MyISAM	latin1_general_ci	2.2 KiB	-
subfamilia		Browse	Structure	Search	Insert		Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
subfamilia_ant		Browse	Structure	Search	Insert	Empty	Drop	33	MyISAM	utf8_general_ci	4.3 KiB	-
sucursal		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	utf8_general_ci	2.1 KiB	-
tareas		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
tarjetas_bancarias		Browse	Structure	Search	Insert	Empty	Drop	3	MyISAM	utf8_general_ci	3.1 KiB	-
tarjetas_bancarias_venta		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
tarjetas_debito		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	utf8_general_ci	3 KiB	-
tarjetas_debito_venta		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
tipos_clientes		Browse	Structure	Search	Insert	Empty	Drop	12	MyISAM	latin1_swedish_ci	2.3 KiB	-
tipo_solicitud		Browse	Structure	Search	Insert	Empty	Drop	4	MyISAM	latin1_swedish_ci	2.1 KiB	-
toma_inventario		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
traspaso_inventario		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
unidad		Browse	Structure	Search	Insert	Empty	Drop	3	MyISAM	utf8_general_ci	2.1 KiB	-
usuario		Browse	Structure	Search	Insert	Empty	Drop	13	MyISAM	utf8_general_ci	3.2 KiB	-
usuario_ant		Browse	Structure	Search	Insert	Empty	Drop	9	MyISAM	utf8_general_ci	2.8 KiB	-
vendedor		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	latin1_general_ci	2 KiB	-
ventas		Browse	Structure	Search	Insert	Empty	Drop	356	MyISAM	utf8_general_ci	37.6 KiB	-
ventas_copy		Browse	Structure	Search	Insert	Empty	Drop	352	MyISAM	utf8_general_ci	37.2 KiB	-
vtas_cotizacion		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
vtas_detalle_cotizacion		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_general_ci	1 KiB	-
zonas		Browse	Structure	Search	Insert	Empty	Drop	16	MyISAM	latin1_general_ci	2.5 KiB	-
123 tables	Sum							~349,039	InnoDB	latin1_swedish_ci	24.8 MiB	0 B

Check all

Print Data dictionary