Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: hr_data
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
account_access_table 5,263 MyISAM utf8mb4_general_ci 419.7 KiB -
account_edit_table 90 MyISAM utf8mb4_general_ci 29.9 KiB -
account_schedule_table 137 MyISAM utf8mb4_general_ci 155.4 KiB -
account_table 137 MyISAM utf8mb4_general_ci 223.1 KiB -
branch_table 1 MyISAM utf8mb4_general_ci 41.1 KiB -
dailytime_leaveofabsence_table 4 MyISAM utf8mb4_general_ci 57.5 KiB -
dailytime_notimein_table 296 MyISAM utf8mb4_general_ci 90.6 KiB -
dailytime_overtime_table 36 MyISAM utf8mb4_general_ci 39.3 KiB -
dailytime_shiftschedule_table 45,750 MyISAM utf8mb4_general_ci 5.3 MiB 252 B
dailytime_table 4,834 MyISAM utf8mb4_general_ci 1.9 MiB -
dailytime_timeadjustment_table 109 MyISAM utf8mb4_general_ci 71.1 KiB -
ecommerce_account_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
ecommerce_dropoff_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
ecommerce_order_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
ecommerce_payment_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
error_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
holidays_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
inventory_daily_record_table 105 MyISAM utf8mb4_general_ci 26.3 KiB -
inventory_edit_stock_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
inventory_edit_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
inventory_subitem_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
inventory_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
payslip_deduction_payment_table 52 MyISAM utf8mb4_general_ci 26.7 KiB -
payslip_deduction_table 14 MyISAM utf8mb4_general_ci 34.0 KiB -
pos_cashcount_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
pos_cashrecord_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
pos_customer_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
pos_payment_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
pos_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
purchase_order_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
registration_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
rental_billing_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
rental_invoice_payment_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
rental_invoice_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
rental_properties_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
rental_property_owner_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
rental_tenant_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
stockin_pending_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
stockin_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
stockout_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
supplier_table 0 MyISAM utf8mb4_general_ci 4.0 KiB -
41 tables Sum 56,828 InnoDB utf8mb4_general_ci 8.5 MiB 252 B

Create table
Name:
Number of columns: