Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
sent tinyint(1)
datesend datetime
clientid int(11)
deleted_customer_name varchar(100) utf8_general_ci
number int(11)
prefix varchar(50) utf8_general_ci
number_format int(11)
datecreated datetime
date date
duedate date
currency int(11)
subtotal decimal(15,2)
total_tax decimal(15,2)
total decimal(15,2)
adjustment decimal(15,2)
adjustment_percent decimal(15,2)
adjustment_type varchar(30) utf8_general_ci
addedfrom int(11)
hash varchar(32) utf8_general_ci
status int(11)
clientnote text utf8_general_ci
adminnote text utf8_general_ci
last_overdue_reminder date
cancel_overdue_reminders int(11)
allowed_payment_modes mediumtext utf8_general_ci
token mediumtext utf8_general_ci
discount_percent decimal(15,2)
discount_total decimal(15,2)
discount_type varchar(30) utf8_general_ci
recurring int(11)
recurring_type varchar(10) utf8_general_ci
custom_recurring tinyint(1)
cycles int(11)
total_cycles int(11)
is_recurring_from int(11)
last_recurring_date date
terms text 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_invoice tinyint(1)
show_quantity_as int(11)
project_id int(11)
subscription_id int(11)
invoice_type varchar(30) utf8_general_ci
rel_id int(11)
certificate_pct varchar(8) utf8_general_ci
certificate_text varchar(255) utf8_general_ci
rel_type enum('customer', 'lead') utf8_general_ci
contact_id int(11)
sub_cost_from_project decimal(15,2)
invoice_description text utf8_general_ci
expense_id_from_project int(11)
is_verified int(11)
estimateid int(11)
estimate_pct int(11)
public_client_id int(11)
payment_term int(11)
invoice_general_tax_pct varchar(64) utf8_general_ci
language varchar(32) utf8_general_ci
company_address_id int(11)