Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafelahore
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 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 32.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 1.4 KiB -
tbl_attendance   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~187,236 InnoDB utf8mb4_general_ci 34.1 MiB -
tbl_brands   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 MyISAM latin1_swedish_ci 5.4 KiB 32 B
tbl_calculations   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,710 InnoDB utf8mb4_general_ci 656.0 KiB -
tbl_cashdetails   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 32.0 KiB -
tbl_cities   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5 InnoDB latin1_swedish_ci 48.0 KiB -
tbl_customers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB latin1_swedish_ci 64.0 KiB -
tbl_cus_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 642 InnoDB latin1_swedish_ci 96.0 KiB -
tbl_daily_cash   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,208 InnoDB latin1_swedish_ci 320.0 KiB -
tbl_daily_closing   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
tbl_demand_record   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 18,357 InnoDB latin1_swedish_ci 3.4 MiB -
tbl_employees   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 303 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 32.0 KiB -
tbl_expenses   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 305 InnoDB latin1_swedish_ci 48.0 KiB -
tbl_exp_categories   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB latin1_swedish_ci 32.0 KiB -
tbl_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 998 InnoDB latin1_swedish_ci 288.0 KiB -
tbl_items_cat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 MyISAM latin1_swedish_ci 5.6 KiB -
tbl_leaves_use   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 32.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 1,219 InnoDB utf8mb4_general_ci 144.0 KiB -
tbl_products   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB latin1_swedish_ci 48.0 KiB -
tbl_products_cat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3 MyISAM latin1_swedish_ci 2.1 KiB -
tbl_purchaser_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_purchases   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,722 MyISAM latin1_swedish_ci 1.0 MiB -
tbl_pur_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15,461 InnoDB latin1_swedish_ci 2.0 MiB -
tbl_recipe   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,916 InnoDB latin1_swedish_ci 192.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 322 InnoDB latin1_swedish_ci 80.0 KiB -
tbl_sales_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 317 InnoDB latin1_swedish_ci 96.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 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_services_calculations   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_staff_leaves   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 867 InnoDB utf8mb4_general_ci 96.0 KiB -
tbl_stock_dairy   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15,535 MyISAM latin1_swedish_ci 2.0 MiB -
tbl_suppliers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 113 InnoDB latin1_swedish_ci 80.0 KiB -
tbl_sup_cat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 InnoDB latin1_swedish_ci 16.0 KiB -
tbl_sup_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 19,474 InnoDB latin1_swedish_ci 3.2 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 4.6 KiB 2.6 KiB
tbl_tmp_stock_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
tbl_units   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 53 MyISAM latin1_swedish_ci 4.0 KiB -
46 tables Sum ~276,835 InnoDB utf8mb4_general_ci 48.4 MiB 2.6 KiB
With selected: / Check tables having overhead

Print Print Data dictionary Data dictionary

Create table
Name:
Number of columns: