• There are no recent tables.
  • There are no favorite tables.
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 :
Choose which details to show in the database structure (list of tables).
Database structure
Documentation Show or hide a column displaying the charset for all tables. Restore default value
Documentation Show or hide a column displaying the comments for all tables. Restore default value
Documentation Show or hide a column displaying the Creation timestamp for all tables. Restore default value
Documentation Show or hide a column displaying the Last update timestamp for all tables. Restore default value
Documentation Show or hide a column displaying the Last check timestamp for all tables. Restore default value
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
tblaccounting_accounts   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 410 InnoDB utf8mb4_general_ci 64.0 KiB -
tblaccounting_account_types   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 26 InnoDB utf8mb4_general_ci 16.0 KiB -
tblactivity_log   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,573 InnoDB utf8_general_ci 496.0 KiB -
tblannouncements   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8_general_ci 16.0 KiB -
tblarticles   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblassigned_clients   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 50 InnoDB utf8mb4_unicode_ci 64.0 KiB -
tblbillpaymentrecords   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 98 InnoDB utf8mb4_unicode_ci 48.0 KiB -
tblbills   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 280 InnoDB utf8mb4_unicode_ci 208.0 KiB -
tblclients   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 806 InnoDB utf8_general_ci 304.0 KiB -
tblcompany_addresses   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3 InnoDB utf8mb4_general_ci 16.0 KiB -
tblconsents   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 64.0 KiB -
tblconsent_purposes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblcontacts   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 954 InnoDB utf8_general_ci 304.0 KiB -
tblcontact_permissions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 210 InnoDB utf8_general_ci 16.0 KiB -
tblcontracts   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8_general_ci 48.0 KiB -
tblcontracts_types   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 InnoDB utf8_general_ci 16.0 KiB -
tblcontract_comments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblcontract_renewals   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblcountries   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 250 InnoDB utf8_general_ci 48.0 KiB -
tblcreditnotes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 8 InnoDB utf8_general_ci 64.0 KiB -
tblcreditnote_refunds   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblcredits   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5 InnoDB utf8_general_ci 16.0 KiB -
tblcurrencies   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5 InnoDB utf8_general_ci 16.0 KiB -
tblcustomers_groupings   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 67 InnoDB utf8_general_ci 32.0 KiB -
tblcustomers_groups   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 InnoDB utf8_general_ci 32.0 KiB -
tblcustomer_activity_log   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 392 InnoDB utf8_general_ci 112.0 KiB -
tblcustomer_admins   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 48.0 KiB -
tblcustomer_groupings   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 24 InnoDB utf8_general_ci 48.0 KiB -
tblcustomer_groups   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 574 InnoDB utf8_general_ci 80.0 KiB -
tblcustomfields   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 38 InnoDB utf8_general_ci 16.0 KiB -
tblcustomfieldsvalues   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,682 InnoDB utf8_general_ci 480.0 KiB -
tbldepartments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 32.0 KiB -
tbldiary   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3 InnoDB utf8_general_ci 176.0 KiB -
tbldiary_members   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 20 InnoDB utf8_general_ci 48.0 KiB -
tbldismissed_announcements   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 8 InnoDB utf8_general_ci 64.0 KiB -
tblemaillists   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblemailtemplates   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,743 InnoDB utf8_general_ci 416.0 KiB -
tblesconnect_connectors   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 16.0 KiB -
tblesconnect_connector_entities   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 19 InnoDB utf8_general_ci 32.0 KiB -
tblesconnect_sync_queue   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,095 InnoDB utf8_general_ci 368.0 KiB -
tblesconnect_sync_settings   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 32.0 KiB -
tblestimates   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 682 InnoDB utf8_general_ci 464.0 KiB -
tblestimate_meetings   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 48.0 KiB -
tblestimate_members   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 841 InnoDB utf8_general_ci 64.0 KiB -
tblevents   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblexpenses   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 456 InnoDB utf8_general_ci 192.0 KiB -
tblexpenses_categories   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 30 InnoDB utf8_general_ci 16.0 KiB -
tblfiles   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 171 InnoDB utf8_general_ci 96.0 KiB -
tblform_questions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblform_question_box   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblform_question_box_description   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblform_results   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblgdpr_requests   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblgoals   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 32.0 KiB -
tblinventory_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 596 InnoDB utf8mb4_general_ci 144.0 KiB -
tblinventory_items_groups   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 73 InnoDB utf8mb4_general_ci 16.0 KiB -
tblinvoicepaymentrecords   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 182 InnoDB utf8_general_ci 48.0 KiB -
tblinvoices   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 273 InnoDB utf8_general_ci 304.0 KiB -
tblitemable   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 12,879 InnoDB utf8_general_ci 3.3 MiB -
tblitems   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 732 InnoDB utf8_general_ci 240.0 KiB -
tblitems_groups   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 16.0 KiB -
tblitem_tax   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,672 InnoDB utf8_general_ci 176.0 KiB -
tblknowedge_base_article_feedback   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblknowledge_base   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8_general_ci 16.0 KiB -
tblknowledge_base_groups   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblleads   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 616 InnoDB utf8_general_ci 320.0 KiB -
tblleads_email_integration   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblleads_sources   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 InnoDB utf8_general_ci 32.0 KiB -
tblleads_status   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB utf8_general_ci 32.0 KiB -
tbllead_activity_log   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,505 InnoDB utf8_general_ci 1.5 MiB -
tbllead_integration_emails   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tbllistemails   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblmaillistscustomfields   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblmaillistscustomfieldvalues   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 48.0 KiB -
tblmail_queue   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblmention_posts   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblmention_post_comments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblmigrations   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8_general_ci 16.0 KiB -
tblmilestones   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 96 InnoDB utf8_general_ci 16.0 KiB -
tblmodules   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 8 InnoDB utf8_general_ci 16.0 KiB -
tblnewsfeed_comment_likes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblnewsfeed_posts   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 16.0 KiB -
tblnewsfeed_post_comments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 16.0 KiB -
tblnewsfeed_post_likes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 16.0 KiB -
tblngn_audit   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 553 InnoDB utf8mb4_unicode_ci 1.5 MiB -
tblngn_classification   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,787 InnoDB utf8mb4_unicode_ci 400.0 KiB -
tblngn_fx_rates   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 28 InnoDB utf8mb4_unicode_ci 32.0 KiB -
tblngn_inbox   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 338 InnoDB utf8mb4_unicode_ci 1.6 MiB -
tblngn_payment_schedule   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 199 InnoDB utf8mb4_unicode_ci 64.0 KiB -
tblnotes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,222 InnoDB utf8_general_ci 480.0 KiB -
tblnotifications   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,361 InnoDB utf8_general_ci 528.0 KiB -
tbloptions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 490 InnoDB utf8_general_ci 208.0 KiB -
tblpayment_attachments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblpayment_modes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 21 InnoDB utf8_general_ci 16.0 KiB -
tblpayment_modes_old   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 16.0 KiB -
tblpayment_terms   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 14 InnoDB utf8mb4_general_ci 16.0 KiB -
tblpermissions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 73 InnoDB utf8_general_ci 16.0 KiB -
tblpinned_prevstudies   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 32.0 KiB -
tblpinned_projects   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 32.0 KiB -
tblprevstudies   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 48.0 KiB -
tblprevstudiesdiscussioncomments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblprevstudiesdiscussions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblprevstudies_activity   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblprevstudies_files   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblprevstudies_members   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 48.0 KiB -
tblprevstudies_notes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblprevstudies_settings   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 32.0 KiB -
tblprevstudies_status   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8_general_ci 16.0 KiB -
tblprojectdiscussioncomments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8_general_ci 16.0 KiB -
tblprojectdiscussions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3 InnoDB utf8_general_ci 16.0 KiB -
tblprojects   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 159 InnoDB utf8_general_ci 96.0 KiB -
tblproject_activity   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,165 InnoDB utf8_general_ci 1.5 MiB -
tblproject_clients   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 48.0 KiB -
tblproject_files   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5 InnoDB utf8_general_ci 16.0 KiB -
tblproject_members   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 294 InnoDB utf8_general_ci 48.0 KiB -
tblproject_notes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 8 InnoDB utf8_general_ci 16.0 KiB -
tblproject_responsible_members   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 174 InnoDB utf8_general_ci 48.0 KiB -
tblproject_settings   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,021 InnoDB utf8_general_ci 320.0 KiB -
tblproject_status   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB utf8_general_ci 16.0 KiB -
tblproject_support_members   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 48.0 KiB -
tblproject_types   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB utf8_general_ci 16.0 KiB -
tblproposals   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblproposal_comments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblproposal_meetings   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 48.0 KiB -
tblpurchase_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 489 InnoDB utf8_general_ci 128.0 KiB -
tblpurchase_items_groups   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblpurchase_orders   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 179 InnoDB utf8mb4_unicode_ci 160.0 KiB -
tblrelated_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16.0 KiB -
tblreminders   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 705 InnoDB utf8_general_ci 128.0 KiB -
tblroles   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 17 InnoDB utf8_general_ci 16.0 KiB -
tblrole_permissions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 717 InnoDB utf8_general_ci 64.0 KiB -
tblsales_activity   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 10,358 InnoDB utf8_general_ci 2.5 MiB -
tblsale_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 351 InnoDB utf8_general_ci 144.0 KiB -
tblsale_items_groups   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB utf8_general_ci 16.0 KiB -
tblservices   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7 InnoDB utf8_general_ci 16.0 KiB -
tblsessions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 45,092 InnoDB utf8_general_ci 9.0 MiB -
136 tables Sum 112,062 InnoDB utf8mb4_unicode_ci 30.9 MiB 0 B
With selected:

Data dictionary Data dictionary

Create new table Create new table