186.10.255.215:81 / localhost / optica_2020_16022022

←

Recent`optica2_2021`.`plazas`
`optica_2021`.`detalle_convenio`
`optica_2021`.`cont_nivel_plan_cuenta`
`optica_2021`.`documentos_referencia`
`optica_2021`.`inventario_prat_28082020`
`optica_2021`.`inventario_prat_09102020`
`optica2_2021`.`cont_comprobante_pago`
`optica_2020_antes_eliminar_bodegas_04082024`.`ciudad`
`optica2_2021`.`detalle_devolucion`
`optica_2020_test`.`guia_despacho`
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.

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

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

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: optica_2020_16022022

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

xxxxxxxxxx

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
armazones_oferta		Browse	Structure	Search	Insert	Empty	Drop	2,913	MyISAM	latin1_swedish_ci	20.9 KiB	-
ayudas		Browse	Structure	Search	Insert	Empty	Drop	3	MyISAM	latin1_general_ci	2.2 KiB	-
bitacora		Browse	Structure	Search	Insert	Empty	Drop	104,035	MyISAM	utf8_general_ci	9.5 MiB	-
bitacora_tracking		Browse	Structure	Search	Insert		Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
bodega		Browse	Structure	Search	Insert	Empty	Drop	53	MyISAM	utf8_general_ci	4 KiB	-
bonos_vale_venta		Browse	Structure	Search	Insert	Empty	Drop	13,153	MyISAM	latin1_swedish_ci	551.1 KiB	-
bonos_vale_venta_ant		Browse	Structure	Search	Insert	Empty	Drop	8,974	MyISAM	latin1_swedish_ci	296.9 KiB	-
borrar		Browse	Structure	Search	Insert	Empty	Drop	27	InnoDB	latin1_general_ci	16 KiB	-
cargo_funcionario		Browse	Structure	Search	Insert	Empty	Drop	15	MyISAM	utf8_general_ci	2.5 KiB	-
carro_compras		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_general_ci	1 KiB	-
celuloide		Browse	Structure	Search	Insert	Empty	Drop	567	MyISAM	latin1_general_ci	51.4 KiB	-
ciudad		Browse	Structure	Search	Insert	Empty	Drop	26	MyISAM	utf8_general_ci	2.7 KiB	-
cliente		Browse	Structure	Search	Insert	Empty	Drop	389	MyISAM	utf8_general_ci	63 KiB	-
cliente_particular		Browse	Structure	Search	Insert	Empty	Drop	165,486	MyISAM	utf8_general_ci	11 MiB	-
cliente_proveedor		Browse	Structure	Search	Insert	Empty	Drop	3	MyISAM	utf8_general_ci	3.4 KiB	-
columna		Browse	Structure	Search	Insert	Empty	Drop	2,237	MyISAM	utf8_general_ci	76.7 KiB	-
columna_ant		Browse	Structure	Search	Insert	Empty	Drop	1,619	MyISAM	utf8_general_ci	55.6 KiB	-
columna_copy		Browse	Structure	Search	Insert	Empty	Drop	2,219	MyISAM	utf8_general_ci	76.3 KiB	-
comisiones_porcentajes		Browse	Structure	Search	Insert	Empty	Drop	358	MyISAM	latin1_general_ci	14.8 KiB	-
cond_venta		Browse	Structure	Search	Insert	Empty	Drop	22	MyISAM	utf8_general_ci	2.7 KiB	-
contacto		Browse	Structure	Search	Insert	Empty	Drop	1,111	MyISAM	utf8_general_ci	83.4 KiB	-
cont_banco		Browse	Structure	Search	Insert	Empty	Drop	8	MyISAM	utf8_general_ci	2.2 KiB	-
cont_boleta_venta		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
cont_centro_costo		Browse	Structure	Search	Insert	Empty	Drop	2	MyISAM	latin1_swedish_ci	2 KiB	-
cont_cheque		Browse	Structure	Search	Insert	Empty	Drop	1,683	MyISAM	latin1_swedish_ci	89.2 KiB	-
cont_ciudad		Browse	Structure	Search	Insert	Empty	Drop	40	MyISAM	latin1_swedish_ci	4 KiB	-
cont_cliente_proveedor		Browse	Structure	Search	Insert	Empty	Drop	1,100	MyISAM	latin1_swedish_ci	211.8 KiB	40 B
cont_cliente_proveedor_2		Browse	Structure	Search	Insert	Empty	Drop	645	MyISAM	latin1_swedish_ci	112.8 KiB	-
cont_cliente_proveedor_copy		Browse	Structure	Search	Insert	Empty	Drop	756	MyISAM	latin1_swedish_ci	143.8 KiB	-
cont_comportamiento_cuenta		Browse	Structure	Search	Insert	Empty	Drop	11	MyISAM	latin1_swedish_ci	2.3 KiB	-
cont_comprobante		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
cont_comprobante_pago		Browse	Structure	Search	Insert	Empty	Drop	92,861	MyISAM	latin1_swedish_ci	7.8 MiB	-
cont_comuna		Browse	Structure	Search	Insert	Empty	Drop	135	MyISAM	utf8_general_ci	9.8 KiB	-
cont_cuenta		Browse	Structure	Search	Insert	Empty	Drop	245	MyISAM	latin1_swedish_ci	23.4 KiB	-
cont_detalle_comprobante		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
cont_detalle_comprobante_pago		Browse	Structure	Search	Insert	Empty	Drop	677	MyISAM	latin1_swedish_ci	35.2 KiB	-
cont_detalle_documento_venta		Browse	Structure	Search	Insert	Empty	Drop	236,818	MyISAM	latin1_swedish_ci	26.1 MiB	-
cont_documento_venta		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
cont_empresa		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	utf8_general_ci	2.2 KiB	-
cont_nivel_plan_cuenta		Browse	Structure	Search	Insert	Empty	Drop	139	MyISAM	utf8_general_ci	19.4 KiB	-
cont_plan_cuenta		Browse	Structure	Search	Insert	Empty	Drop	2	MyISAM	latin1_swedish_ci	2.1 KiB	-
cont_sub_centro_costo		Browse	Structure	Search	Insert	Empty	Drop	7	MyISAM	latin1_swedish_ci	4.3 KiB	-
cont_tipo_documento		Browse	Structure	Search	Insert	Empty	Drop	11	MyISAM	latin1_swedish_ci	2.4 KiB	-
convenio		Browse	Structure	Search	Insert	Empty	Drop	1,033	MyISAM	utf8_general_ci	80.9 KiB	-
costos		Browse	Structure	Search	Insert	Empty	Drop	7,892	InnoDB	latin1_general_ci	432 KiB	-
cotizacion		Browse	Structure	Search	Insert	Empty	Drop	85,211	MyISAM	utf8_general_ci	8.8 MiB	-
cuota_credito		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
descuento_convenio		Browse	Structure	Search	Insert	Empty	Drop	3,355	MyISAM	utf8_general_ci	161.3 KiB	-
detalle_convenio		Browse	Structure	Search	Insert	Empty	Drop	1,383	MyISAM	utf8_general_ci	107.8 KiB	-
detalle_cotizacion		Browse	Structure	Search	Insert	Empty	Drop	290,301	MyISAM	utf8_general_ci	46.2 MiB	-
detalle_devolucion		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8_general_ci	1 KiB	-
detalle_devolucion_producto		Browse	Structure	Search	Insert	Empty	Drop	721	MyISAM	utf8_general_ci	35 KiB	-
detalle_guia_despacho		Browse	Structure	Search	Insert	Empty	Drop	65,216	MyISAM	utf8_general_ci	6.4 MiB	-
detalle_guia_despacho_ant		Browse	Structure	Search	Insert	Empty	Drop	30,532	MyISAM	utf8_general_ci	3 MiB	-
detalle_ordenes_produccion		Browse	Structure	Search	Insert		Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
detalle_orden_compra		Browse	Structure	Search	Insert	Empty	Drop	250,767	MyISAM	utf8_general_ci	37.9 MiB	-
detalle_recepcion		Browse	Structure	Search	Insert	Empty	Drop	189,910	MyISAM	utf8_general_ci	8.1 MiB	-
detalle_recepcion_traspaso		Browse	Structure	Search	Insert	Empty	Drop	64,153	InnoDB	utf8_spanish_ci	2.5 MiB	-
detalle_solicitud_insumos		Browse	Structure	Search	Insert	Empty	Drop	34	MyISAM	latin1_swedish_ci	4 KiB	-
detalle_tabla_precio		Browse	Structure	Search	Insert	Empty	Drop	87,047	MyISAM	latin1_general_ci	3.6 MiB	-
detalle_tabla_precio_16012022		Browse	Structure	Search	Insert	Empty	Drop	86,884	MyISAM	latin1_general_ci	3.6 MiB	-
detalle_traspaso		Browse	Structure	Search	Insert	Empty	Drop	86,294	MyISAM	utf8_general_ci	4.5 MiB	-
detalle_traspaso_copy		Browse	Structure	Search	Insert	Empty	Drop	65,609	MyISAM	utf8_general_ci	3.3 MiB	-
detalle_vale_venta		Browse	Structure	Search	Insert	Empty	Drop	313,666	MyISAM	utf8_general_ci	42 MiB	-
detalle_ventas		Browse	Structure	Search	Insert	Empty	Drop	31,476	MyISAM	utf8_general_ci	3.2 MiB	-
detalle_ventas_ant		Browse	Structure	Search	Insert	Empty	Drop	24	MyISAM	utf8_general_ci	4.8 KiB	-
deterioro_material		Browse	Structure	Search	Insert	Empty	Drop	5,190	MyISAM	utf8_general_ci	472.2 KiB	-
deterioro_material_copy		Browse	Structure	Search	Insert	Empty	Drop	5,124	MyISAM	utf8_general_ci	445.5 KiB	-
devolucion_productos		Browse	Structure	Search	Insert	Empty	Drop	666	MyISAM	utf8_general_ci	56.8 KiB	-
doctor		Browse	Structure	Search	Insert	Empty	Drop	381	MyISAM	utf8_general_ci	26.5 KiB	-
documento		Browse	Structure	Search	Insert	Empty	Drop	8	MyISAM	utf8_general_ci	2.4 KiB	-
documentos_referencia		Browse	Structure	Search	Insert	Empty	Drop	53,748	MyISAM	latin1_swedish_ci	3.9 MiB	-
documento_credito		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
documento_dte		Browse	Structure	Search	Insert	Empty	Drop	11	MyISAM	utf8_general_ci	2.4 KiB	-
empresa		Browse	Structure	Search	Insert	Empty	Drop	305	MyISAM	utf8_general_ci	56 KiB	-
entrega_sobres_bodega		Browse	Structure	Search	Insert	Empty	Drop	1,048	MyISAM	latin1_swedish_ci	51.6 KiB	-
familia		Browse	Structure	Search	Insert	Empty	Drop	15	MyISAM	utf8_general_ci	2.4 KiB	-
fecha_recepcion		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	2 KiB	-
feriados		Browse	Structure	Search	Insert	Empty	Drop	15	MyISAM	latin1_general_ci	2.3 KiB	-
fila		Browse	Structure	Search	Insert	Empty	Drop	8,346	MyISAM	utf8_general_ci	477.8 KiB	-
fila_ant		Browse	Structure	Search	Insert	Empty	Drop	5,017	MyISAM	utf8_general_ci	287.5 KiB	-
fila_copy		Browse	Structure	Search	Insert	Empty	Drop	8,110	MyISAM	utf8_general_ci	464.4 KiB	-
folios		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	latin1_swedish_ci	2 KiB	-
forma_pago		Browse	Structure	Search	Insert	Empty	Drop	14	MyISAM	utf8_general_ci	2.4 KiB	-
funcionario		Browse	Structure	Search	Insert	Empty	Drop	30	MyISAM	utf8_general_ci	3.5 KiB	-
guia_despacho		Browse	Structure	Search	Insert	Empty	Drop	46,610	MyISAM	utf8_general_ci	5.3 MiB	-
guia_despacho_ant		Browse	Structure	Search	Insert	Empty	Drop	21,344	MyISAM	utf8_general_ci	2.4 MiB	-
industria		Browse	Structure	Search	Insert	Empty	Drop	3	MyISAM	utf8_general_ci	2.2 KiB	-
informe_ventas_armazones_seguridad		Browse	Structure	Search	Insert	Empty	Drop	87	MyISAM	latin1_swedish_ci	5.6 KiB	-
interes		Browse	Structure	Search	Insert	Empty	Drop	24	MyISAM	utf8_general_ci	2.8 KiB	-
inventario		Browse	Structure	Search	Insert	Empty	Drop	169,454	MyISAM	utf8_general_ci	14.1 MiB	-
inventario_656_27012022		Browse	Structure	Search	Insert	Empty	Drop	168,220	MyISAM	utf8_general_ci	14 MiB	-
inventario_656_30092021		Browse	Structure	Search	Insert	Empty	Drop	155,846	MyISAM	utf8_general_ci	13.5 MiB	-
inventario_656_30112021		Browse	Structure	Search	Insert	Empty	Drop	162,931	MyISAM	utf8_general_ci	14.2 MiB	-
inventario_calama_10012022		Browse	Structure	Search	Insert	Empty	Drop	166,293	MyISAM	utf8_general_ci	13.9 MiB	-
inventario_calama_12102021		Browse	Structure	Search	Insert	Empty	Drop	156,748	MyISAM	utf8_general_ci	13.5 MiB	-
inventario_central5_19122021		Browse	Structure	Search	Insert	Empty	Drop	164,552	MyISAM	utf8_general_ci	14.2 MiB	-
inventario_cm656_29102021		Browse	Structure	Search	Insert	Empty	Drop	158,459	MyISAM	utf8_general_ci	13.7 MiB	-
inventario_colipi_04012022		Browse	Structure	Search	Insert	Empty	Drop	165,807	MyISAM	utf8_general_ci	14 MiB	-
inventario_comunal_07012022		Browse	Structure	Search	Insert	Empty	Drop	166,089	MyISAM	utf8_general_ci	13.9 MiB	-
inventario_comunal_09092021		Browse	Structure	Search	Insert	Empty	Drop	153,929	MyISAM	utf8_general_ci	12.7 MiB	-
inventario_contactología_27122021		Browse	Structure	Search	Insert	Empty	Drop	165,067	MyISAM	utf8_general_ci	14.2 MiB	-
inventario_copiapo_06012021		Browse	Structure	Search	Insert	Empty	Drop	132,101	MyISAM	utf8_general_ci	10.9 MiB	-
inventario_cristales_17_23122021		Browse	Structure	Search	Insert	Empty	Drop	164,964	MyISAM	utf8_general_ci	14.2 MiB	-
inventario_cristales_17_27122021		Browse	Structure	Search	Insert	Empty	Drop	165,067	MyISAM	utf8_general_ci	14.2 MiB	-
inventario_cristales_matta_08062021		Browse	Structure	Search	Insert	Empty	Drop	144,337	MyISAM	utf8_general_ci	11.9 MiB	-
inventario_iquique7_06012021		Browse	Structure	Search	Insert	Empty	Drop	132,084	MyISAM	utf8_general_ci	10.9 MiB	-
inventario_iquique7_07012022		Browse	Structure	Search	Insert	Empty	Drop	166,089	MyISAM	utf8_general_ci	13.9 MiB	-
inventario_iquique7_26102021		Browse	Structure	Search	Insert	Empty	Drop	158,258	MyISAM	utf8_general_ci	13.7 MiB	-
inventario_la_serena_06012022		Browse	Structure	Search	Insert	Empty	Drop	165,901	MyISAM	utf8_general_ci	14 MiB	-
inventario_la_serena_08012021		Browse	Structure	Search	Insert	Empty	Drop	132,306	MyISAM	utf8_general_ci	10.9 MiB	-
inventario_la_serena_ventas4_29092021		Browse	Structure	Search	Insert	Empty	Drop	155,782	MyISAM	utf8_general_ci	13.3 MiB	-
inventario_lentes_seguridad_11122021		Browse	Structure	Search	Insert	Empty	Drop	163,904	MyISAM	utf8_general_ci	14.1 MiB	-
inventario_los_carrera_02102021		Browse	Structure	Search	Insert	Empty	Drop	155,899	MyISAM	utf8_general_ci	13.4 MiB	-
inventario_los_carrera_05012022		Browse	Structure	Search	Insert	Empty	Drop	165,900	MyISAM	utf8_general_ci	14 MiB	-
inventario_matta_06032021		Browse	Structure	Search	Insert	Empty	Drop	136,770	MyISAM	utf8_general_ci	11.2 MiB	-
inventario_matta_13022021		Browse	Structure	Search	Insert	Empty	Drop	134,638	MyISAM	utf8_general_ci	11.1 MiB	-
inventario_matta_26062021		Browse	Structure	Search	Insert	Empty	Drop	145,500	MyISAM	utf8_general_ci	12 MiB	-
inventario_matta_27112021		Browse	Structure	Search	Insert	Empty	Drop	162,689	MyISAM	utf8_general_ci	14.1 MiB	-
inventario_matta_28082021		Browse	Structure	Search	Insert	Empty	Drop	152,612	MyISAM	utf8_general_ci	12.6 MiB	-
inventario_matta_29012022		Browse	Structure	Search	Insert	Empty	Drop	168,398	MyISAM	utf8_general_ci	14 MiB	-
inventario_matta_29052021		Browse	Structure	Search	Insert	Empty	Drop	143,705	MyISAM	utf8_general_ci	11.8 MiB	-
inventario_matta_29082020		Browse	Structure	Search	Insert	Empty	Drop	121,691	MyISAM	utf8_general_ci	10 MiB	-
inventario_matta_30042021		Browse	Structure	Search	Insert	Empty	Drop	141,965	MyISAM	utf8_general_ci	11.6 MiB	-
inventario_matta_30102021		Browse	Structure	Search	Insert	Empty	Drop	158,599	MyISAM	utf8_general_ci	13.7 MiB	-
inventario_matta_31072021		Browse	Structure	Search	Insert	Empty	Drop	148,789	MyISAM	utf8_general_ci	12.3 MiB	-
inventario_matta_cm565_31122021		Browse	Structure	Search	Insert	Empty	Drop	165,553	MyISAM	utf8_general_ci	14 MiB	-
inventario_operativo_18012022		Browse	Structure	Search	Insert	Empty	Drop	166,816	MyISAM	utf8_general_ci	13.9 MiB	-
inventario_prat2_29122021		Browse	Structure	Search	Insert	Empty	Drop	165,405	MyISAM	utf8_general_ci	14.2 MiB	-
inventario_prat26022021		Browse	Structure	Search	Insert	Empty	Drop	135,649	MyISAM	utf8_general_ci	11.2 MiB	-
inventario_prat_05022021		Browse	Structure	Search	Insert	Empty	Drop	134,219	MyISAM	utf8_general_ci	11.1 MiB	-
inventario_prat_10042021		Browse	Structure	Search	Insert	Empty	Drop	139,732	MyISAM	utf8_general_ci	11.5 MiB	-
inventario_prat_26012022		Browse	Structure	Search	Insert	Empty	Drop	168,145	MyISAM	utf8_general_ci	14 MiB	-
inventario_prat_27052021		Browse	Structure	Search	Insert	Empty	Drop	143,629	MyISAM	utf8_general_ci	11.8 MiB	-
inventario_prat_27082021		Browse	Structure	Search	Insert	Empty	Drop	152,588	MyISAM	utf8_general_ci	12.6 MiB	-
inventario_prat_27102021		Browse	Structure	Search	Insert	Empty	Drop	158,297	MyISAM	utf8_general_ci	13.8 MiB	-
inventario_prat_29062021		Browse	Structure	Search	Insert	Empty	Drop	145,651	MyISAM	utf8_general_ci	12 MiB	-
inventario_prat_29072021		Browse	Structure	Search	Insert	Empty	Drop	148,245	MyISAM	utf8_general_ci	12.2 MiB	-
inventario_prat_colipi_01102021		Browse	Structure	Search	Insert	Empty	Drop	155,879	MyISAM	utf8_general_ci	13.4 MiB	-
inventario_prat_ventas4_29112021		Browse	Structure	Search	Insert	Empty	Drop	162,811	MyISAM	utf8_general_ci	14 MiB	-
inventario_promociones_22122021		Browse	Structure	Search	Insert	Empty	Drop	164,928	MyISAM	utf8_general_ci	14.2 MiB	-
inventario_santiago_10012022		Browse	Structure	Search	Insert	Empty	Drop	166,293	MyISAM	utf8_general_ci	13.9 MiB	-
inventario_santiago_11012021		Browse	Structure	Search	Insert	Empty	Drop	132,480	MyISAM	utf8_general_ci	11 MiB	-
inventario_santiago_27092021		Browse	Structure	Search	Insert	Empty	Drop	155,581	MyISAM	utf8_general_ci	13.4 MiB	-
inventario_seguridad14_27122021		Browse	Structure	Search	Insert	Empty	Drop	165,067	MyISAM	utf8_general_ci	14.2 MiB	-
inventario_ventas4_04102021		Browse	Structure	Search	Insert	Empty	Drop	156,046	MyISAM	utf8_general_ci	13.4 MiB	-
inventario_ventas4_08022021		Browse	Structure	Search	Insert	Empty	Drop	134,290	MyISAM	utf8_general_ci	11 MiB	-
inventario_ventas4_08022022		Browse	Structure	Search	Insert	Empty	Drop	169,056	MyISAM	utf8_general_ci	14.1 MiB	-
inventario_ventas4_09032021		Browse	Structure	Search	Insert	Empty	Drop	137,094	MyISAM	utf8_general_ci	11.3 MiB	-
inventario_ventas4_09042021		Browse	Structure	Search	Insert	Empty	Drop	139,696	MyISAM	utf8_general_ci	11.4 MiB	-
inventario_ventas4_25082021		Browse	Structure	Search	Insert	Empty	Drop	152,226	MyISAM	utf8_general_ci	12.5 MiB	-
inventario_ventas4_28042021		Browse	Structure	Search	Insert	Empty	Drop	141,737	MyISAM	utf8_general_ci	11.6 MiB	-
inventario_ventas4_29102021		Browse	Structure	Search	Insert	Empty	Drop	158,459	MyISAM	utf8_general_ci	13.7 MiB	-
inventario_ventas4_30062021		Browse	Structure	Search	Insert	Empty	Drop	145,733	MyISAM	utf8_general_ci	12 MiB	-
inventario_ventas4_30072021		Browse	Structure	Search	Insert	Empty	Drop	148,761	MyISAM	utf8_general_ci	12.2 MiB	-
inventario_ventas4_30122021		Browse	Structure	Search	Insert	Empty	Drop	165,522	MyISAM	utf8_general_ci	14.1 MiB	-
inventario_ventas4_31052021		Browse	Structure	Search	Insert	Empty	Drop	143,795	MyISAM	utf8_general_ci	11.8 MiB	-
lentes_sol_oferta		Browse	Structure	Search	Insert	Empty	Drop	2,354	MyISAM	latin1_swedish_ci	17.1 KiB	-
lineas_productos		Browse	Structure	Search	Insert	Empty	Drop	7	MyISAM	latin1_general_ci	2.2 KiB	-
movimiento_inventario		Browse	Structure	Search	Insert	Empty	Drop	1,578,661	MyISAM	utf8_general_ci	138.4 MiB	-
observacion_paciente		Browse	Structure	Search	Insert	Empty	Drop	1,649	MyISAM	latin1_swedish_ci	133.9 KiB	-
oferta		Browse	Structure	Search	Insert	Empty	Drop	8,856	MyISAM	utf8_general_ci	1.1 MiB	-
ordenes_produccion		Browse	Structure	Search	Insert		Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
orden_compra		Browse	Structure	Search	Insert	Empty	Drop	39,664	MyISAM	utf8_general_ci	3.8 MiB	-
orden_compra_clientes		Browse	Structure	Search	Insert	Empty	Drop	62,048	MyISAM	latin1_swedish_ci	5.6 MiB	-
orden_compra_clientes_copy		Browse	Structure	Search	Insert	Empty	Drop	51,432	MyISAM	latin1_swedish_ci	4.4 MiB	-
orden_compra_clientes_copy1		Browse	Structure	Search	Insert	Empty	Drop	51,453	MyISAM	latin1_swedish_ci	4.4 MiB	-
orden_compra_clientes_copy2		Browse	Structure	Search	Insert	Empty	Drop	59,544	MyISAM	latin1_swedish_ci	5.3 MiB	-
orden_compra_clientes_respaldo		Browse	Structure	Search	Insert	Empty	Drop	51,474	MyISAM	latin1_swedish_ci	4.4 MiB	-
orden_compra_clientes_vales		Browse	Structure	Search	Insert	Empty	Drop	79,085	MyISAM	latin1_swedish_ci	3 MiB	-
paciente		Browse	Structure	Search	Insert	Empty	Drop	185,682	MyISAM	latin1_swedish_ci	12.8 MiB	-
paciente_copy		Browse	Structure	Search	Insert	Empty	Drop	150,768	MyISAM	latin1_swedish_ci	10 MiB	-
pago		Browse	Structure	Search	Insert	Empty	Drop	108,215	MyISAM	utf8_general_ci	10.5 MiB	-
parametros		Browse	Structure	Search	Insert	Empty	Drop	21	MyISAM	latin1_general_ci	3.7 KiB	-
parametros_ant		Browse	Structure	Search	Insert	Empty	Drop	5	MyISAM	latin1_general_ci	2.3 KiB	-
paso		Browse	Structure	Search	Insert	Empty	Drop	47	InnoDB	latin1_swedish_ci	16 KiB	-
persona		Browse	Structure	Search	Insert	Empty	Drop	9	MyISAM	utf8_general_ci	2.4 KiB	-
precios_compra		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_general_ci	16 KiB	-
produccion_extra		Browse	Structure	Search	Insert	Empty	Drop	2	MyISAM	latin1_general_ci	2.1 KiB	-
producto		Browse	Structure	Search	Insert	Empty	Drop	303,917	MyISAM	utf8_general_ci	53.5 MiB	-
productos_clientes		Browse	Structure	Search	Insert	Empty	Drop	3	MyISAM	latin1_general_ci	2.1 KiB	-
productos_sin_costo		Browse	Structure	Search	Insert	Empty	Drop	2,574	InnoDB	utf8_spanish_ci	128 KiB	-
producto_antes_cambio_costos		Browse	Structure	Search	Insert	Empty	Drop	239,187	MyISAM	utf8_general_ci	38.8 MiB	-
producto_antes_oferta_26092021		Browse	Structure	Search	Insert	Empty	Drop	295,996	MyISAM	utf8_general_ci	50.5 MiB	-
producto_composicion		Browse	Structure	Search	Insert	Empty	Drop	177	MyISAM	latin1_general_ci	7.5 KiB	-
producto_con_armazones_oferta		Browse	Structure	Search	Insert	Empty	Drop	278,857	MyISAM	utf8_general_ci	47.3 MiB	-
producto_revisar		Browse	Structure	Search	Insert	Empty	Drop	278,596	MyISAM	utf8_general_ci	47.3 MiB	-
recepcion		Browse	Structure	Search	Insert	Empty	Drop	63,232	MyISAM	utf8_general_ci	4.6 MiB	-
recepcion_traspaso		Browse	Structure	Search	Insert	Empty	Drop	12,414	InnoDB	utf8_spanish_ci	1.5 MiB	-
region		Browse	Structure	Search	Insert	Empty	Drop	17	MyISAM	utf8_general_ci	2.5 KiB	-
reserva_laboratorio		Browse	Structure	Search	Insert	Empty	Drop	16,292	MyISAM	utf8_general_ci	1.5 MiB	-
rrmm_salud		Browse	Structure	Search	Insert	Empty	Drop	10	MyISAM	latin1_swedish_ci	2.3 KiB	-
rut_defontana		Browse	Structure	Search	Insert	Empty	Drop	2,000	InnoDB	latin1_swedish_ci	112 KiB	-
sesiones		Browse	Structure	Search	Insert	Empty	Drop	5,276	MyISAM	latin1_swedish_ci	320 KiB	-
sobre		Browse	Structure	Search	Insert	Empty	Drop	181,774	MyISAM	utf8_general_ci	21.3 MiB	-
solicitudes_insumos		Browse	Structure	Search	Insert	Empty	Drop	22	MyISAM	latin1_swedish_ci	2.8 KiB	-
subfamilia		Browse	Structure	Search	Insert	Empty	Drop	269	MyISAM	utf8_general_ci	16.4 KiB	-
sucursal		Browse	Structure	Search	Insert	Empty	Drop	26	MyISAM	utf8_general_ci	4.9 KiB	-
tabla_precio		Browse	Structure	Search	Insert	Empty	Drop	107	MyISAM	utf8_general_ci	10.1 KiB	-
tabla_precio_antes_cambio_a_neto		Browse	Structure	Search	Insert	Empty	Drop	72	MyISAM	utf8_general_ci	6 KiB	-
tabla_precio_copy		Browse	Structure	Search	Insert	Empty	Drop	105	MyISAM	utf8_general_ci	10 KiB	-
tarjeta_coordenadas		Browse	Structure	Search	Insert	Empty	Drop	50	MyISAM	latin1_general_ci	3 KiB	-
tecnico		Browse	Structure	Search	Insert	Empty	Drop	65	MyISAM	utf8_general_ci	4.8 KiB	-
tipos_comprobantes		Browse	Structure	Search	Insert	Empty	Drop	5	MyISAM	latin1_swedish_ci	2.1 KiB	-
tipo_material		Browse	Structure	Search	Insert	Empty	Drop	608	MyISAM	utf8_general_ci	54.9 KiB	-
tipo_material_ant		Browse	Structure	Search	Insert	Empty	Drop	512	MyISAM	utf8_general_ci	44.8 KiB	-
toma_inventario		Browse	Structure	Search	Insert	Empty	Drop	296	MyISAM	utf8_general_ci	24.4 KiB	-
traspaso_inventario		Browse	Structure	Search	Insert	Empty	Drop	17,496	MyISAM	utf8_general_ci	1.4 MiB	-
tratamiento		Browse	Structure	Search	Insert	Empty	Drop	44	MyISAM	utf8_general_ci	4.8 KiB	-
tratamientos_cotizacion		Browse	Structure	Search	Insert	Empty	Drop	194,140	MyISAM	latin1_general_ci	6.1 MiB	-
ultimos_precios_compra		Browse	Structure	Search	Insert	Empty	Drop	12,928	InnoDB	latin1_swedish_ci	1.5 MiB	-
unidad		Browse	Structure	Search	Insert	Empty	Drop	6	MyISAM	utf8_general_ci	2.1 KiB	-
usuario		Browse	Structure	Search	Insert	Empty	Drop	53	MyISAM	utf8_general_ci	14.4 KiB	-
usuario_vacio		Browse	Structure	Search	Insert	Empty	Drop	1	MyISAM	utf8_general_ci	2.2 KiB	-
vale_venta		Browse	Structure	Search	Insert	Empty	Drop	68,511	MyISAM	utf8_general_ci	10.8 MiB	-
vendedor		Browse	Structure	Search	Insert	Empty	Drop	108	MyISAM	utf8_general_ci	9.6 KiB	-
ventas		Browse	Structure	Search	Insert	Empty	Drop	52,283	MyISAM	utf8_general_ci	5.4 MiB	-
ventas_ant		Browse	Structure	Search	Insert	Empty	Drop	258	MyISAM	utf8_general_ci	29.3 KiB	-
xml		Browse	Structure	Search	Insert	Empty	Drop	8,166	MyISAM	latin1_general_ci	13.3 MiB	-
219 tables	Sum							~17,214,111	InnoDB	latin1_swedish_ci	1.6 GiB	40 B

Check all / Check tables having overhead

Print Data dictionary