There are no favorite tables.

New
aaa
- aaa
- aaa_fabricas_pruebas
abanq
- abanq_23
- abanq_23 experimental
articulos
autocompleta
azulejoscabello.com
- azulejoscabello.com
- azulejoscabello.com_tienda
azulejoscabello_com
book_sc
cabecab4
cabello-enterprises
- cabello-enterprises
- cabello-enterprises_exp
contabilidad
datatablesv03
durstone
eneboo
grespania
information_schema
intermediaria_online
jplist
keraben
letodms
letodms experimental
magazine
mydms
mydms experimental
mysql
pamesa_filter
performance_schema
php_producto
- php_producto
- php_producto_prueba
sys
tutorial
wordpress
- wordpress
- wordpress_desarrollo

Customize appearance of the navigation panel.

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 panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

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
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

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

Tables display options.

Tables

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 -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

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 Query failed Database : Queried time :

Table structure

Settings for the table structure (list of columns).

Table structure

Default transformations
Hide table structure actions Whether the table structure actions should be hidden.
Show column comments Whether column comments should be shown in table structure view
Default transformations for Hex Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	2
Default transformations for Substring Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 all …
Default transformations for Bool2Text Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	T F
Default transformations for External Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 -f /dev/null -i -wrap -q 1 1
Default transformations for PreApPend Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Default transformations for DateFormat Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 local
Default transformations for Inline Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	100 100
Default transformations for TextImageLink Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	100 50
Default transformations for TextLink Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.

z_diario_t4

#	Name	Type	Collation	Null	Default	Extra	Action
1	z_diario_t4_id	int		No	None	AUTO_INCREMENT	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
2	ASIEN,N,6,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	FECHA,D	datetime		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	SUBCTA,C,12	varchar(12)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	CONTRA,C,12	varchar(12)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	PTADEBE,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
7	CONCEPTO,C,25	varchar(25)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
8	PTAHABER,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
9	FACTURA,N,8,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
10	BASEIMPO,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
11	IVA,N,5,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
12	RECEQUIV,N,5,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
13	DOCUMENTO,C,10	varchar(5)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
14	DEPARTA,C,3	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
15	CLAVE,C,6	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
16	ESTADO,C,1	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
17	NCASADO,N,6,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
18	TCASADO,N,1,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
19	TRANS,N,6,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
20	CAMBIO,N,16,6	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
21	DEBEME,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
22	HABERME,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
23	AUXILIAR,C,1	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
24	SERIE,C,1	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
25	SUCURSAL,C,4	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
26	CODDIVISA,C,5	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
27	IMPAUXME,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
28	MONEDAUSO,C,1	varchar(5)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
29	EURODEBE,N,16,2	double		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
30	EUROHABER,N,16,2	double		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
31	BASEEURO,N,16,2	double		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
32	NOCONV,L	tinyint(1)		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
33	NUMEROINV,C,10	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
34	SERIE_RT,C,1	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
35	FACTU_RT,N,8,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
36	BASEIMP_RT,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
37	BASEIMP_RF,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
38	RECTIFICA,L	tinyint(1)		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
39	FECHA_RT,D	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
40	NIC,C,1	varchar(5)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
41	LPERIODICO,L	tinyint(1)		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
42	CODMOVPER,N,6,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
43	LINTERRUMP,L	tinyint(1)		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
44	SEGACTIV,C,6	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
45	SEGGEOGR,C,6	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
46	LRECT349,L	tinyint(1)		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
47	FECHA_OP,D	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
48	FECHA_EX,D	datetime		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
49	TIPOOPE,C,1	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
50	NFACTICK,N,8,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
51	NUMACUINI,C,40	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
52	NUMACUFIN,C,40	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
53	TERIDNIF,N,1,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
54	TERNIF,C,15	varchar(12)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
55	TERNOM,C,40	varchar(45)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
56	TERNIF14,C,9	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
57	TBIENTRAN,L	tinyint(1)		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
58	TBIENCOD,C,10	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
59	TRANSINM,L	tinyint(1)		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
60	METAL,L	tinyint(1)		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
61	METALIMP,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
62	CLIENTE,C,12	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
63	OPBIENES,N,1,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
64	FACTURAEX,C,40	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
65	GUID,C,40	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
66	L340,L	tinyint(1)		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
67	METALEJE,N,4,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
68	CLIENTESUP,C,12	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
69	FECHASUP,D	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
70	IMPORTESUP,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
71	DOCSUP,C,40	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
72	CLIENTEPRO,C,12	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
73	FECHAPRO,D	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
74	IMPORTEPRO,N,16,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
75	DOCPRO,C,40	varchar(255)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
76	NIRPF,N,5,2	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
77	NCLAVEIRPF,N,2,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
78	CTIMESTAMP,C,19	varchar(25)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
79	CUSRTMSTMP,C,2	varchar(5)	latin1_swedish_ci	Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
80	LESIRPF,L	tinyint(1)		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
81	TIPOSUPPRO,N,1,0	int		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values

Check all With selected:

Move columns

Normalize

Add column(s)

Indexes

Action			Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
Edit	Rename	Drop	PRIMARY	BTREE	Yes	No	z_diario_t4_id	5206	A	No
Edit	Rename	Drop	PTADEBE,N,16,2_index	BTREE	No	No	PTADEBE,N,16,2	1	A	No
Edit	Rename	Drop	PTAHABER,N,16,2_index	BTREE	No	No	PTAHABER,N,16,2	1	A	No
Edit	Rename	Drop	FACTURA,N,8,0_index	BTREE	No	No	FACTURA,N,8,0	4	A	No
Edit	Rename	Drop	BASEIMPO,N,16,2_index	BTREE	No	No	BASEIMPO,N,16,2	1	A	No
Edit	Rename	Drop	IVA,N,5,2_index	BTREE	No	No	IVA,N,5,2	5	A	No
Edit	Rename	Drop	RECEQUIV,N,5,2_index	BTREE	No	No	RECEQUIV,N,5,2	1	A	No
Edit	Rename	Drop	NCASADO,N,6,0_index	BTREE	No	No	NCASADO,N,6,0	1	A	No
Edit	Rename	Drop	TCASADO,N,1,0_index	BTREE	No	No	TCASADO,N,1,0	1	A	No
Edit	Rename	Drop	TRANS,N,6,0_index	BTREE	No	No	TRANS,N,6,0	1	A	No
Edit	Rename	Drop	CAMBIO,N,16,6_index	BTREE	No	No	CAMBIO,N,16,6	1	A	No
Edit	Rename	Drop	DEBEME,N,16,2_index	BTREE	No	No	DEBEME,N,16,2	1	A	No
Edit	Rename	Drop	HABERME,N,16,2_index	BTREE	No	No	HABERME,N,16,2	1	A	No
Edit	Rename	Drop	IMPAUXME,N,16,2_index	BTREE	No	No	IMPAUXME,N,16,2	1	A	No
Edit	Rename	Drop	FACTU_RT,N,8,0_index	BTREE	No	No	FACTU_RT,N,8,0	1	A	No
Edit	Rename	Drop	BASEIMP_RT,N,16,2_index	BTREE	No	No	BASEIMP_RT,N,16,2	1	A	No
Edit	Rename	Drop	BASEIMP_RF,N,16,2_index	BTREE	No	No	BASEIMP_RF,N,16,2	1	A	No
Edit	Rename	Drop	CODMOVPER,N,6,0_index	BTREE	No	No	CODMOVPER,N,6,0	1	A	No
Edit	Rename	Drop	NFACTICK,N,8,0_index	BTREE	No	No	NFACTICK,N,8,0	2	A	No
Edit	Rename	Drop	TERIDNIF,N,1,0_index	BTREE	No	No	TERIDNIF,N,1,0	3	A	No
Edit	Rename	Drop	METALIMP,N,16,2_index	BTREE	No	No	METALIMP,N,16,2	1	A	No
Edit	Rename	Drop	OPBIENES,N,1,0_index	BTREE	No	No	OPBIENES,N,1,0	2	A	No
Edit	Rename	Drop	METALEJE,N,4,0_index	BTREE	No	No	METALEJE,N,4,0	1	A	No
Edit	Rename	Drop	IMPORTESUP,N,16,2_index	BTREE	No	No	IMPORTESUP,N,16,2	1	A	No
Edit	Rename	Drop	IMPORTEPRO,N,16,2_index	BTREE	No	No	IMPORTEPRO,N,16,2	1	A	No
Edit	Rename	Drop	NIRPF,N,5,2_index	BTREE	No	No	NIRPF,N,5,2	1	A	No
Edit	Rename	Drop	NCLAVEIRPF,N,2,0_index	BTREE	No	No	NCLAVEIRPF,N,2,0	1	A	No
Edit	Rename	Drop	TIPOSUPPRO,N,1,0_index	BTREE	No	No	TIPOSUPPRO,N,1,0	1	A	No

Partitions

No partitioning defined!

Information

Space usage
Optimize table
Data	1.5	MiB
Index	2.6	MiB
Overhead	3.0	MiB
Effective	1.2	MiB
Total	4.2	MiB

Row statistics
Format	dynamic
Collation	latin1_swedish_ci
Next autoindex	5,409
Creation	Mar 10, 2026 at 01:15 PM
Last update	Aug 06, 2026 at 07:02 AM
Last check	Aug 06, 2026 at 07:02 AM