perfex.tail1f1784.ts.net / 127.0.0.1 / gms_local / tblestimates

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 :

Do a "query by example" (wildcard: "%")

Column	Type	Collation	Value
id	int(11)
sent	tinyint(1)
datesend	datetime
clientid	int(11)
contactid	int(11)		Browse foreign values
work_type	int(11)
deleted_customer_name	varchar(100)	utf8_general_ci
project_id	int(11)
number	int(11)
prefix	varchar(50)	utf8_general_ci
number_format	int(11)
hash	varchar(32)	utf8_general_ci
datecreated	datetime
date	date
expirydate	date
date3	date
date4	date
date5	date
currency	int(11)
subtotal	decimal(15,2)
total_tax	decimal(15,2)
total	decimal(15,2)
adjustment	decimal(15,2)
addedfrom	int(11)
status	int(11)
clientnote	text	utf8_general_ci
adminnote	text	utf8_general_ci
discount_percent	decimal(15,2)
discount_total	decimal(15,2)
discount_type	varchar(30)	utf8_general_ci
invoiceid	longtext	utf8_general_ci
invoiced_date	datetime
terms	text	utf8_general_ci
reference_no	varchar(100)	utf8_general_ci
sale_agent	int(11)
billing_street	varchar(200)	utf8_general_ci
billing_city	varchar(100)	utf8_general_ci
billing_state	varchar(100)	utf8_general_ci
billing_zip	varchar(100)	utf8_general_ci
billing_country	int(11)
shipping_street	varchar(200)	utf8_general_ci
shipping_city	varchar(100)	utf8_general_ci
shipping_state	varchar(100)	utf8_general_ci
shipping_zip	varchar(100)	utf8_general_ci
shipping_country	int(11)
include_shipping	tinyint(1)
show_shipping_on_estimate	tinyint(1)
show_quantity_as	int(11)
pipeline_order	int(11)
is_expiry_notified	int(11)
acceptance_firstname	varchar(50)	utf8_general_ci
acceptance_lastname	varchar(50)	utf8_general_ci
acceptance_email	varchar(100)	utf8_general_ci
acceptance_date	datetime
acceptance_ip	varchar(40)	utf8_general_ci
signature	varchar(40)	utf8_general_ci
contract_operation_txt	longtext	utf8_general_ci
summary_txt	longtext	utf8_general_ci
summary_title	varchar(255)	utf8_general_ci
work_type_item	int(11)
origen	varchar(255)	utf8_general_ci
origen_type	int(11)
administrator	varchar(255)	utf8_general_ci
phone	varchar(32)	utf8_general_ci
phone2	varchar(32)	utf8_general_ci
email	varchar(64)	utf8_general_ci
irdam1	decimal(10,2)
irdam2	decimal(10,2)
client_details_txt	longtext	utf8_general_ci
contactid2	int(11)
contactid3	int(11)
contactid4	int(11)
contactid5	int(11)
contactid6	int(11)
contactid7	int(11)
contactid8	int(11)
contactid9	int(11)
contactid10	int(11)
parentid	int(11)
e_company	int(11)
prevstudies_id	int(11)
version	varchar(256)	utf8_general_ci
estimate_type	enum('modular', 'normal')	utf8_general_ci
estimate_pdf_prefs	varchar(1024)	utf8_general_ci
housing_surfaces	float
housing_coef_geo	float
housing_coef_typology	float
housing_coef_quality	float
housing_coef_use	float
garage_surfaces	float
garage_coef_geo	float
garage_coef_typology	float
garage_coef_quality	float
garage_coef_use	float
sp_surfaces	float
sp_coef_geo	float
sp_coef_typology	float
sp_coef_quality	float
sp_coef_use	float
porches_surfaces	float
porches_coef_geo	float
porches_coef_typology	float
porches_coef_quality	float
porches_coef_use	float
next_discount	int(11)
topographic_study	float
geotechnical_study	float
indicative	float
work_license_fee	float
icio	float
aesa	float
bail_replacement_urban_elements	float
works_plaque	float
public_manhole_connection	float
street_cuts	float
occupation_of_public_roads	float
first_occupation_license	float
ford_application_fee	float
mail_code	varchar(128)	utf8_general_ci
project_subtotal	decimal(15,2)
specialty	int(11)
lead_date	date
language	varchar(32)	utf8_general_ci
priority	int(11)
prov_price	int(11)
proposal_note	text	utf8_general_ci
project_type	varchar(64)	utf8_general_ci
study_area	varchar(128)	utf8_general_ci
power	varchar(32)	utf8_general_ci
country_id	int(11)
province	varchar(64)	utf8_general_ci
term_id	int(11)
awarded_status_date	date
total_invoiced_pct	decimal(15,2)
company_address_id	int(11)
date_year	smallint(5)

Select columns (at least one):

DISTINCT

Or Add search conditions (body of the "where" clause):

Number of rows per page

Order by:

Ascending

Descending

id
sent
datesend
clientid
contactid
work_type
deleted_customer_name
project_id
number
prefix
number_format
hash
datecreated
date
expirydate
date3
date4
date5
currency
subtotal
total_tax
total
adjustment
addedfrom
status
clientnote
adminnote
discount_percent
discount_total
discount_type
invoiceid
invoiced_date
terms
reference_no
sale_agent
billing_street
billing_city
billing_state
billing_zip
billing_country
shipping_street
shipping_city
shipping_state
shipping_zip
shipping_country
include_shipping
show_shipping_on_estimate
show_quantity_as
pipeline_order
is_expiry_notified
acceptance_firstname
acceptance_lastname
acceptance_email
acceptance_date
acceptance_ip
signature
contract_operation_txt
summary_txt
summary_title
work_type_item
origen
origen_type
administrator
phone
phone2
email
irdam1
irdam2
client_details_txt
contactid2
contactid3
contactid4
contactid5
contactid6
contactid7
contactid8
contactid9
contactid10
parentid
e_company
prevstudies_id
version
estimate_type
estimate_pdf_prefs
housing_surfaces
housing_coef_geo
housing_coef_typology
housing_coef_quality
housing_coef_use
garage_surfaces
garage_coef_geo
garage_coef_typology
garage_coef_quality
garage_coef_use
sp_surfaces
sp_coef_geo
sp_coef_typology
sp_coef_quality
sp_coef_use
porches_surfaces
porches_coef_geo
porches_coef_typology
porches_coef_quality
porches_coef_use
next_discount
topographic_study
geotechnical_study
indicative
work_license_fee
icio
aesa
bail_replacement_urban_elements
works_plaque
public_manhole_connection
street_cuts
occupation_of_public_roads
first_occupation_license
ford_application_fee
mail_code
project_subtotal
specialty
lead_date
language
priority
prov_price
proposal_note
project_type
study_area
power
country_id
province
term_id
awarded_status_date
total_invoiced_pct
company_address_id
date_year