Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafe
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
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the charset for all tables.
Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
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
customer_types   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 64.0 KiB -
designation   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
purchaser_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 16.0 KiB -
stock_dairy_types   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_unicode_ci 1.0 KiB -
tbl_admin   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 MyISAM latin1_swedish_ci 2.4 KiB -
tbl_attendance   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~87,639 InnoDB utf8mb4_general_ci 16.0 MiB -
tbl_brands   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 10 MyISAM latin1_swedish_ci 5.4 KiB -
tbl_calculations   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,128 InnoDB utf8mb4_general_ci 512.0 KiB -
tbl_cashdetails   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 InnoDB utf8mb4_general_ci 64.0 KiB -
tbl_cities   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5 InnoDB latin1_swedish_ci 96.0 KiB -
tbl_customers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB latin1_swedish_ci 128.0 KiB -
tbl_cus_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 582 InnoDB latin1_swedish_ci 160.0 KiB -
tbl_daily_cash   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,692 InnoDB latin1_swedish_ci 432.0 KiB -
tbl_daily_closing   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11 InnoDB latin1_swedish_ci 16.0 KiB -
tbl_demand_record   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 22,794 InnoDB latin1_swedish_ci 5.9 MiB -
tbl_employees   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 272 InnoDB utf8mb4_general_ci 144.0 KiB -
tbl_emp_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 64.0 KiB -
tbl_expenses   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 805 InnoDB latin1_swedish_ci 96.0 KiB -
tbl_exp_categories   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB latin1_swedish_ci 64.0 KiB -
tbl_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 890 InnoDB latin1_swedish_ci 496.0 KiB -
tbl_items_cat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 18 MyISAM latin1_swedish_ci 5.7 KiB -
tbl_leaves_use   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 852 InnoDB utf8mb4_general_ci 80.0 KiB -
tbl_notes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
tbl_points   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,212 InnoDB utf8mb4_general_ci 368.0 KiB -
tbl_products   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 429 InnoDB latin1_swedish_ci 96.0 KiB -
tbl_products_cat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 238 MyISAM latin1_swedish_ci 13.8 KiB -
tbl_purchaser_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,847 InnoDB utf8mb4_general_ci 96.0 KiB -
tbl_purchases   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11,778 MyISAM latin1_swedish_ci 2.2 MiB -
tbl_pur_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 25,428 InnoDB latin1_swedish_ci 4.3 MiB -
tbl_recipe   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,045 InnoDB latin1_swedish_ci 208.0 KiB -
tbl_reward_points   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 16.0 KiB -
tbl_sales   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 574 InnoDB latin1_swedish_ci 112.0 KiB -
tbl_sales_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 601 InnoDB latin1_swedish_ci 144.0 KiB -
tbl_sale_services   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM latin1_swedish_ci 3.0 KiB -
tbl_section_sale   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_services   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 37 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_services_calculations   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 457 InnoDB utf8mb4_general_ci 80.0 KiB -
tbl_staff_leaves   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,135 InnoDB utf8mb4_general_ci 176.0 KiB -
tbl_stock_dairy   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 25,448 MyISAM latin1_swedish_ci 3.2 MiB -
tbl_suppliers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 100 InnoDB latin1_swedish_ci 112.0 KiB -
tbl_sup_cat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 14 InnoDB latin1_swedish_ci 32.0 KiB -
tbl_sup_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 27,550 InnoDB latin1_swedish_ci 4.5 MiB -
tbl_tmp_purchases   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM latin1_swedish_ci 2.1 KiB -
tbl_tmp_pur_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM latin1_swedish_ci 3.8 KiB 1.8 KiB
tbl_tmp_stock_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 126 MyISAM latin1_swedish_ci 9.2 KiB -
tbl_units   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 59 MyISAM latin1_swedish_ci 4.2 KiB -
46 tables Sum ~224,798 InnoDB utf8mb4_general_ci 40.0 MiB 1.8 KiB
With selected: / Check tables having overhead

Print Print Data dictionary Data dictionary

Create table
Name:
Number of columns: