desktop-pb00esf.tail37de6a.ts.net / 127.0.0.1 / egsystemit_acsuin / ot3

`egsystemit_acsuin`.`ot3`

There are no favorite tables.

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 :

Edit mode
Text fields

Customize edit mode.

Edit mode

Protect binary columns Disallow BLOB and BINARY columns from editing.
Show function fields Display the function fields in edit/insert mode.
Show field types Defines whether or not type fields should be initially displayed in edit/insert mode.
Number of inserted rows How many rows can be inserted at one time.
Foreign key dropdown order Sort order for items in a foreign-key dropdown box; `content` is the referenced data, `id` is the key value.	content-id id-content
Foreign key limit A dropdown will be used if fewer items are present.

Customize text input fields.

Text fields

CHAR columns editing Defines which type of editing controls should be used for CHAR and VARCHAR columns; `input` - allows limiting of input length, `textarea` - allows newlines in columns.
Minimum size for input field Defines the minimum size for input fields generated for CHAR and VARCHAR columns.
Maximum size for input field Defines the maximum size for input fields generated for CHAR and VARCHAR columns.
CHAR textarea columns Number of columns for CHAR/VARCHAR textareas.
CHAR textarea rows Number of rows for CHAR/VARCHAR textareas.
Textarea columns Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2).
Textarea rows Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2).
Bigger textarea for LONGTEXT Double size of textarea for LONGTEXT columns.

Column	Type	Function	Null	Value

secuencial	int(11)
fecha	datetime
num_orden	int(11)
orden_trabajo	varchar(50)
responsable	varchar(50)
cliente	varchar(50)
placa	varchar(50)
aseguradora	varchar(50)
marca	varchar(50)
modelo	varchar(50)
tamaño	varchar(50)
npiezas	int(11)
porcentaje_daño	varchar(50)
estado_orden	varchar(50)
D1	varchar(50)
PRESENT_D1	int(11)
COSTO_D1	float
PESO_D1	float
REND_D1	float
CUSADAL_D1	float
CUSADAG_D1	float
COSTOR_D1	float
MD	varchar(50)
PRESENT_MD	varchar(50)
COSTO_MD	float
PESO_MD	float
REND_MD	float
CUSADAL_MD	float
CUSADAG_MD	float
CATALIZACION_MD	int(11)
COSTOR_MD	float
CATMD	varchar(50)
PRESENT_CATMD	varchar(50)
COSTO_CATMD	float
PESO_CATMD	float
REND_CATMD	float
CUSADAL_CATMD	float
CUSADAG_CATMD	float
COSTOR_CATMD	float
FIPLAS	varchar(50)
PESO_FIPLAS	float
PRESENT_FIPLAS	float
COSTO_FIPLAS	float
REND_FIPLAS	float
CUSADAL_FIPLAS	float
CUSADAG_FIPLAS	float
COSTOR_FIPLAS	float
FI	varchar(50)
PESO_FI	float
PRESENT_FI	float
COSTO_FI	float
REND_FI	float
CUSADAL_FI	float
CUSADAG_FI	float
CATALIZACION_FI	varchar(3)
PORCTHI_FI	int(11)
COSTOR_FI	float
CATFI	varchar(50)
PESO_CATFI	float
PRESENT_CATFI	float
COSTO_CATFI	float
REND_CATFI	float
CUSADAL_CATFI	float
CUSADAG_CATFI	float
COSTOR_CATFI	float
THIFI	varchar(50)
PESO_THIFI	float
PRESENT_THIFI	float
COSTO_THIFI	float
REND_THIFI	float
CUSADAL_THIFI	float
CUSADAG_THIFI	float
COSTOR_THIFI	float
FR	varchar(50)
PESO_FR	float
PRESENT_FR	float
COSTO_FR	float
REND_FR	float
CUSADAL_FR	float
CUSADAG_FR	float
CATALIZACION_FR	varchar(3)
PORCTHI_FIR	int(11)
COSTOR_FR	float
CATFR	varchar(50)
PRESENT_CATFR	float
PESO_CATFR	float
COSTO_CATFR	float
REND_CATFR	float
CUSADAL_CATFR	float
CUSADAG_CATFR	float
COSTOR_CATFR	float
THIFR	varchar(50)
PRESENT_THIFR	float
PESO_THIFR	float
COSTO_THIFR	float
REND_THIFR	float
CUSADAL_THIFR	float
CUSADAG_THIFR	float
COSTOR_THIFR	float
D2	varchar(50)
PRESENT_D2	float
PESO_D2	float
COSTO_D2	float
REND_D2	float
CUSADAL_D2	float
CUSADAG_D2	float
COSTOR_D2	float
COLOR	varchar(50)
PRESENT_COLOR	float
PESO_COLOR	float
COSTO_COLOR	float
REND_COLOR	float
CUSADAL_COLOR	float
CUSADAG_COLOR	float
COSTOR_COLOR	float
LINEA_COLOR	varchar(2)
TIPO_COLOR	varchar(10)
SUBTIPO_COLOR	varchar(50)
CATALIZACION_COLOR	varchar(3)
PORCTHI_COLOR	int(11)
CATCOLOR	varchar(50)
PRESENT_CATCOLOR	float
PESO_CATCOLOR	float
COSTO_CATCOLOR	float
REND_CATCOLOR	float
CUSADAL_CATCOLOR	float
CUSADAG_CATCOLOR	float
COSTOR_CATCOLOR	float
THICOLOR	varchar(50)
PRESENT_THICOLOR	float
PESO_THICOLOR	float
COSTO_THICOLOR	float
REND_THICOLOR	float
CUSADAL_THICOLOR	float
CUSADAG_THICOLOR	float
COSTOR_THICOLOR	float
BARNIZ	varchar(50)
PRESENT_BARNIZ	float
PESO_BARNIZ	float
COSTO_BARNIZ	float
REND_BARNIZ	float
CUSADAL_BARNIZ	float
CUSADAG_BARNIZ	float
CATALIZACION_BARNIZ	varchar(3)
PORCTHI_BARNIZ	int(11)
COSTOR_BARNIZ	float
CATBARNIZ	varchar(50)
PRESENT_CATBARNIZ	float
PESO_CATBARNIZ	float
COSTO_CATBARNIZ	float
REND_CATBARNIZ	float
CUSADAL_CATBARNIZ	float
CUSADAG_CATBARNIZ	float
COSTOR_CATBARNIZ	float
THIBARNIZ	varchar(50)
PRESENT_THIBARNIZ	float
PESO_THIBARNIZ	float
COSTO_THIBARNIZ	float
REND_THIBARNIZ	float
CUSADAL_THIBARNIZ	float
CUSADAG_THIBARNIZ	float
COSTOR_THIBARNIZ	float
PULIDO	varchar(50)
PRESENT_PULIDO	float
PESO_PULIDO	float
COSTO_PULIDO	float
REND_PULIDO	float
CUSADAL_PULIDO	float
CUSADAG_PULIDO	float
COSTOR_PULIDO	float
ABRILL	varchar(50)
PRESENT_ABRILL	float
PESO_ABRILL	float
COSTO_ABRILL	float
REND_ABRILL	float
CUSADAL_ABRILL	float
CUSADAG_ABRILL	float
COSTOR_ABRILL	float
PROTEC	varchar(50)
PRESENT_PROTEC	float
PESO_PROTEC	float
COSTO_PROTEC	float
REND_PROTEC	float
CUSADAL_PROTEC	float
CUSADAG_PROTEC	float
COSTOR_PROTEC	float
total_costocomp	float
num_piezas	int(11)
area_total	float
horas_hombre	float
costo_hora_hombre	float
porc_depre_equipos	int(11)
observaciones	mediumtext

Ignore

Column	Type	Function	Null	Value

secuencial	int(11)
fecha	datetime
num_orden	int(11)
orden_trabajo	varchar(50)
responsable	varchar(50)
cliente	varchar(50)
placa	varchar(50)
aseguradora	varchar(50)
marca	varchar(50)
modelo	varchar(50)
tamaño	varchar(50)
npiezas	int(11)
porcentaje_daño	varchar(50)
estado_orden	varchar(50)
D1	varchar(50)
PRESENT_D1	int(11)
COSTO_D1	float
PESO_D1	float
REND_D1	float
CUSADAL_D1	float
CUSADAG_D1	float
COSTOR_D1	float
MD	varchar(50)
PRESENT_MD	varchar(50)
COSTO_MD	float
PESO_MD	float
REND_MD	float
CUSADAL_MD	float
CUSADAG_MD	float
CATALIZACION_MD	int(11)
COSTOR_MD	float
CATMD	varchar(50)
PRESENT_CATMD	varchar(50)
COSTO_CATMD	float
PESO_CATMD	float
REND_CATMD	float
CUSADAL_CATMD	float
CUSADAG_CATMD	float
COSTOR_CATMD	float
FIPLAS	varchar(50)
PESO_FIPLAS	float
PRESENT_FIPLAS	float
COSTO_FIPLAS	float
REND_FIPLAS	float
CUSADAL_FIPLAS	float
CUSADAG_FIPLAS	float
COSTOR_FIPLAS	float
FI	varchar(50)
PESO_FI	float
PRESENT_FI	float
COSTO_FI	float
REND_FI	float
CUSADAL_FI	float
CUSADAG_FI	float
CATALIZACION_FI	varchar(3)
PORCTHI_FI	int(11)
COSTOR_FI	float
CATFI	varchar(50)
PESO_CATFI	float
PRESENT_CATFI	float
COSTO_CATFI	float
REND_CATFI	float
CUSADAL_CATFI	float
CUSADAG_CATFI	float
COSTOR_CATFI	float
THIFI	varchar(50)
PESO_THIFI	float
PRESENT_THIFI	float
COSTO_THIFI	float
REND_THIFI	float
CUSADAL_THIFI	float
CUSADAG_THIFI	float
COSTOR_THIFI	float
FR	varchar(50)
PESO_FR	float
PRESENT_FR	float
COSTO_FR	float
REND_FR	float
CUSADAL_FR	float
CUSADAG_FR	float
CATALIZACION_FR	varchar(3)
PORCTHI_FIR	int(11)
COSTOR_FR	float
CATFR	varchar(50)
PRESENT_CATFR	float
PESO_CATFR	float
COSTO_CATFR	float
REND_CATFR	float
CUSADAL_CATFR	float
CUSADAG_CATFR	float
COSTOR_CATFR	float
THIFR	varchar(50)
PRESENT_THIFR	float
PESO_THIFR	float
COSTO_THIFR	float
REND_THIFR	float
CUSADAL_THIFR	float
CUSADAG_THIFR	float
COSTOR_THIFR	float
D2	varchar(50)
PRESENT_D2	float
PESO_D2	float
COSTO_D2	float
REND_D2	float
CUSADAL_D2	float
CUSADAG_D2	float
COSTOR_D2	float
COLOR	varchar(50)
PRESENT_COLOR	float
PESO_COLOR	float
COSTO_COLOR	float
REND_COLOR	float
CUSADAL_COLOR	float
CUSADAG_COLOR	float
COSTOR_COLOR	float
LINEA_COLOR	varchar(2)
TIPO_COLOR	varchar(10)
SUBTIPO_COLOR	varchar(50)
CATALIZACION_COLOR	varchar(3)
PORCTHI_COLOR	int(11)
CATCOLOR	varchar(50)
PRESENT_CATCOLOR	float
PESO_CATCOLOR	float
COSTO_CATCOLOR	float
REND_CATCOLOR	float
CUSADAL_CATCOLOR	float
CUSADAG_CATCOLOR	float
COSTOR_CATCOLOR	float
THICOLOR	varchar(50)
PRESENT_THICOLOR	float
PESO_THICOLOR	float
COSTO_THICOLOR	float
REND_THICOLOR	float
CUSADAL_THICOLOR	float
CUSADAG_THICOLOR	float
COSTOR_THICOLOR	float
BARNIZ	varchar(50)
PRESENT_BARNIZ	float
PESO_BARNIZ	float
COSTO_BARNIZ	float
REND_BARNIZ	float
CUSADAL_BARNIZ	float
CUSADAG_BARNIZ	float
CATALIZACION_BARNIZ	varchar(3)
PORCTHI_BARNIZ	int(11)
COSTOR_BARNIZ	float
CATBARNIZ	varchar(50)
PRESENT_CATBARNIZ	float
PESO_CATBARNIZ	float
COSTO_CATBARNIZ	float
REND_CATBARNIZ	float
CUSADAL_CATBARNIZ	float
CUSADAG_CATBARNIZ	float
COSTOR_CATBARNIZ	float
THIBARNIZ	varchar(50)
PRESENT_THIBARNIZ	float
PESO_THIBARNIZ	float
COSTO_THIBARNIZ	float
REND_THIBARNIZ	float
CUSADAL_THIBARNIZ	float
CUSADAG_THIBARNIZ	float
COSTOR_THIBARNIZ	float
PULIDO	varchar(50)
PRESENT_PULIDO	float
PESO_PULIDO	float
COSTO_PULIDO	float
REND_PULIDO	float
CUSADAL_PULIDO	float
CUSADAG_PULIDO	float
COSTOR_PULIDO	float
ABRILL	varchar(50)
PRESENT_ABRILL	float
PESO_ABRILL	float
COSTO_ABRILL	float
REND_ABRILL	float
CUSADAL_ABRILL	float
CUSADAG_ABRILL	float
COSTOR_ABRILL	float
PROTEC	varchar(50)
PRESENT_PROTEC	float
PESO_PROTEC	float
COSTO_PROTEC	float
REND_PROTEC	float
CUSADAL_PROTEC	float
CUSADAG_PROTEC	float
COSTOR_PROTEC	float
total_costocomp	float
num_piezas	int(11)
area_total	float
horas_hombre	float
costo_hora_hombre	float
porc_depre_equipos	int(11)
observaciones	mediumtext

	and then
Use TAB key to move from value to value, or CTRL+arrows to move anywhere.