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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark 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
admin_block_overview_view   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
block_inventory   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 30 InnoDB utf8mb4_general_ci 48.0 KiB -
branches   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 18 InnoDB utf8mb4_general_ci 48.0 KiB -
products   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 327 InnoDB utf8mb4_general_ci 96.0 KiB -
product_main_type_tbl   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB utf8mb4_general_ci 48.0 KiB -
product_sub_type_tbl   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 44 InnoDB utf8mb4_general_ci 64.0 KiB -
product_unit_info_tbl   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 322 InnoDB utf8mb4_general_ci 96.0 KiB -
product_unit_tbl   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 InnoDB utf8mb4_general_ci 32.0 KiB -
roles   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 32.0 KiB -
stock_transfers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 80.0 KiB -
system_inventory   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 331 InnoDB utf8mb4_general_ci 80.0 KiB -
users   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8mb4_general_ci 80.0 KiB -
user_warehouses   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8mb4_general_ci 48.0 KiB -
view_warehouse_keepers   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
warehouses   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 53 InnoDB utf8mb4_general_ci 32.0 KiB -
warehouse_inventory_view   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
warehouse_keepers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 80.0 KiB -
17 tables Sum ~1,150 InnoDB utf8mb4_general_ci 864.0 KiB 0 B
With selected:

Data dictionary Data dictionary

Create new table Create new table