shackfitness.online / 127.0.0.1 / truckingbusiness

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

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).

Database structure

Show table charset Show or hide a column displaying the charset for all tables.
Show table comments Show or hide a column displaying the comments for all tables.
Show creation timestamp Show or hide a column displaying the Creation timestamp for all tables.
Show last update timestamp Show or hide a column displaying the Last update timestamp for all tables.
Show last check timestamp Show or hide a column displaying the Last check timestamp for all tables.

Filters

Containing the word:

Table	Action							Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11.	Type	Collation	Size	Overhead
account_transfers		Browse	Structure	Search	Insert	Empty	Drop	26	InnoDB	utf8mb4_general_ci	80.0 KiB	-
advance_documents		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
advance_expense_documents		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
advance_expense_usage		Browse	Structure	Search	Insert	Empty	Drop	7,284	InnoDB	utf8mb4_general_ci	928.0 KiB	-
advance_tracker		Browse	Structure	Search	Insert	Empty	Drop	2,187	InnoDB	utf8mb4_general_ci	512.0 KiB	-
app_roles		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8mb4_general_ci	32.0 KiB	-
app_role_permissions		Browse	Structure	Search	Insert	Empty	Drop	169	InnoDB	utf8mb4_general_ci	32.0 KiB	-
cash_trip_payment_entries		Browse	Structure	Search	Insert	Empty	Drop	752	InnoDB	utf8mb4_general_ci	160.0 KiB	-
city_exchange_pension		Browse	Structure	Search	Insert	Empty	Drop	9	InnoDB	utf8mb4_general_ci	80.0 KiB	-
city_exchange_reimbursement		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
city_exchange_salary		Browse	Structure	Search	Insert	Empty	Drop	18	InnoDB	utf8mb4_general_ci	64.0 KiB	-
clients		Browse	Structure	Search	Insert	Empty	Drop	43	InnoDB	utf8mb4_general_ci	16.0 KiB	-
client_share_accounts		Browse	Structure	Search	Insert	Empty	Drop	223	InnoDB	utf8mb4_general_ci	48.0 KiB	-
company		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8_general_ci	16.0 KiB	-
company_documents		Browse	Structure	Search	Insert	Empty	Drop	13	InnoDB	utf8mb4_general_ci	48.0 KiB	-
company_expense_documents		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
dashboard_notes		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
diesel		Browse	Structure	Search	Insert	Empty	Drop	180	InnoDB	utf8mb4_general_ci	112.0 KiB	-
diesel_documents		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
driver_salaries		Browse	Structure	Search	Insert	Empty	Drop	321	InnoDB	utf8_general_ci	144.0 KiB	-
employees		Browse	Structure	Search	Insert	Empty	Drop	46	InnoDB	utf8_general_ci	48.0 KiB	-
employee_documents		Browse	Structure	Search	Insert	Empty	Drop	75	InnoDB	utf8mb4_general_ci	32.0 KiB	-
expense_payment_logs		Browse	Structure	Search	Insert	Empty	Drop	249	InnoDB	utf8mb4_general_ci	64.0 KiB	-
fines		Browse	Structure	Search	Insert	Empty	Drop	38	InnoDB	utf8mb4_general_ci	80.0 KiB	-
fine_documents		Browse	Structure	Search	Insert	Empty	Drop	13	InnoDB	utf8mb4_general_ci	16.0 KiB	-
inventory_parts		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_general_ci	16.0 KiB	-
inventory_tir		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_general_ci	16.0 KiB	-
investor1_accounts		Browse	Structure	Search	Insert	Empty	Drop	558	InnoDB	utf8mb4_general_ci	96.0 KiB	-
invoice		Browse	Structure	Search	Insert	Empty	Drop	397	InnoDB	utf8mb4_general_ci	128.0 KiB	-
invoice_bulk_payments		Browse	Structure	Search	Insert	Empty	Drop	319	InnoDB	utf8mb4_general_ci	176.0 KiB	-
invoice_credit_notes		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
invoice_items		Browse	Structure	Search	Insert	Empty	Drop	6,839	InnoDB	utf8mb4_general_ci	1.9 MiB	-
invoice_payments		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
kec_invoice_item_remarks		Browse	Structure	Search	Insert	Empty	Drop	13	InnoDB	utf8mb4_general_ci	48.0 KiB	-
kec_invoice_item_share_amounts		Browse	Structure	Search	Insert	Empty	Drop	81	InnoDB	utf8mb4_general_ci	48.0 KiB	-
kec_invoice_remarks		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
kec_projects		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_general_ci	32.0 KiB	-
kec_project_invoices		Browse	Structure	Search	Insert	Empty	Drop	16	InnoDB	utf8mb4_general_ci	48.0 KiB	-
kec_project_payments		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
logs		Browse	Structure	Search	Insert	Empty	Drop	1,759	InnoDB	utf8mb4_general_ci	720.0 KiB	-
master_accounts		Browse	Structure	Search	Insert	Empty	Drop	60	InnoDB	utf8mb4_general_ci	32.0 KiB	-
master_account_details		Browse	Structure	Search	Insert	Empty	Drop	1,155	InnoDB	utf8mb4_general_ci	160.0 KiB	-
miscellaneous		Browse	Structure	Search	Insert	Empty	Drop	308	InnoDB	utf8mb4_general_ci	256.0 KiB	-
miscellaneous_categories		Browse	Structure	Search	Insert	Empty	Drop	16	InnoDB	utf8mb4_general_ci	32.0 KiB	-
other_employees		Browse	Structure	Search	Insert	Empty	Drop	19	InnoDB	utf8mb4_general_ci	48.0 KiB	-
other_employee_documents		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
other_owner		Browse	Structure	Search	Insert	Empty	Drop	13	InnoDB	utf8mb4_general_ci	16.0 KiB	-
other_trailer		Browse	Structure	Search	Insert	Empty	Drop	17	InnoDB	utf8mb4_general_ci	48.0 KiB	-
other_trailer_documents		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
other_trucks		Browse	Structure	Search	Insert	Empty	Drop	19	InnoDB	utf8mb4_general_ci	16.0 KiB	-
other_trucks_documents		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
outside_accounts		Browse	Structure	Search	Insert	Empty	Drop	357	InnoDB	utf8mb4_general_ci	96.0 KiB	-
outside_account_documents		Browse	Structure	Search	Insert	Empty	Drop	63	InnoDB	utf8mb4_general_ci	32.0 KiB	-
outside_account_payments		Browse	Structure	Search	Insert	Empty	Drop	214	InnoDB	utf8mb4_general_ci	128.0 KiB	-
outsource_advance_details		Browse	Structure	Search	Insert	Empty	Drop	501	InnoDB	utf8mb4_general_ci	128.0 KiB	-
payment_types		Browse	Structure	Search	Insert	Empty	Drop	14	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
pdc		Browse	Structure	Search	Insert	Empty	Drop	53	InnoDB	utf8mb4_general_ci	64.0 KiB	-
personal_advance		Browse	Structure	Search	Insert	Empty	Drop	58	InnoDB	utf8mb4_general_ci	80.0 KiB	-
personal_advance_payments		Browse	Structure	Search	Insert	Empty	Drop	48	InnoDB	utf8mb4_general_ci	96.0 KiB	-
qashio_erp_transactions		Browse	Structure	Search	Insert	Empty	Drop	1,456	InnoDB	utf8mb4_general_ci	3.2 MiB	-
salary_documents		Browse	Structure	Search	Insert	Empty	Drop	37	InnoDB	utf8mb4_general_ci	32.0 KiB	-
salary_na		Browse	Structure	Search	Insert	Empty	Drop	194	InnoDB	utf8mb4_general_ci	16.0 KiB	-
suppliers		Browse	Structure	Search	Insert	Empty	Drop	44	InnoDB	utf8mb4_general_ci	32.0 KiB	-
tax_submitted		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
tir_sold_payment_log		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
tir_stock_additions		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_general_ci	16.0 KiB	-
tir_stock_settings		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_general_ci	16.0 KiB	-
trailers		Browse	Structure	Search	Insert	Empty	Drop	26	InnoDB	utf8mb4_general_ci	48.0 KiB	-
trailer_documents		Browse	Structure	Search	Insert	Empty	Drop	26	InnoDB	utf8mb4_general_ci	32.0 KiB	-
trips		Browse	Structure	Search	Insert	Empty	Drop	2,735	InnoDB	utf8mb4_general_ci	544.0 KiB	-
trip_charges		Browse	Structure	Search	Insert	Empty	Drop	2,735	InnoDB	utf8mb4_general_ci	288.0 KiB	-
trip_documents		Browse	Structure	Search	Insert	Empty	Drop	2,557	InnoDB	utf8mb4_general_ci	192.0 KiB	-
trip_documents_files		Browse	Structure	Search	Insert	Empty	Drop	442	InnoDB	utf8mb4_general_ci	80.0 KiB	-
trip_expenses		Browse	Structure	Search	Insert	Empty	Drop	4,100	InnoDB	utf8mb4_general_ci	560.0 KiB	-
trip_financials		Browse	Structure	Search	Insert	Empty	Drop	2,736	InnoDB	utf8mb4_general_ci	480.0 KiB	-
trip_investors		Browse	Structure	Search	Insert	Empty	Drop	677	InnoDB	utf8mb4_general_ci	64.0 KiB	-
trip_paid_by_client		Browse	Structure	Search	Insert	Empty	Drop	3,705	InnoDB	utf8mb4_general_ci	416.0 KiB	-
trip_resources		Browse	Structure	Search	Insert	Empty	Drop	2,736	InnoDB	utf8mb4_general_ci	496.0 KiB	-
truckmaintenance		Browse	Structure	Search	Insert	Empty	Drop	1,496	InnoDB	utf8_general_ci	576.0 KiB	-
truckmaintenance_payments		Browse	Structure	Search	Insert	Empty	Drop	1,157	InnoDB	utf8mb4_general_ci	1.6 MiB	-
truckmaintenance_receipts		Browse	Structure	Search	Insert	Empty	Drop	150	InnoDB	utf8mb4_general_ci	32.0 KiB	-
trucks		Browse	Structure	Search	Insert	Empty	Drop	29	InnoDB	utf8_general_ci	64.0 KiB	-
truck_documents		Browse	Structure	Search	Insert	Empty	Drop	43	InnoDB	utf8mb4_general_ci	32.0 KiB	-
users		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	utf8mb4_general_ci	64.0 KiB	-
vehicle_status		Browse	Structure	Search	Insert	Empty	Drop	20	InnoDB	utf8mb4_general_ci	32.0 KiB	-
85 tables	Sum							51,668	InnoDB	utf8mb4_general_ci	16.3 MiB	0 B

Check all

Data dictionary