shackfitness.online / 127.0.0.1 / dailyplanet / invoices

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.

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.

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.

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

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

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 :

Column	Type	Collation
id	varchar(255)	utf8mb4_general_ci
reference_number	varchar(20)	utf8mb4_general_ci
job_id	varchar(255)	utf8mb4_general_ci
customer_name	varchar(255)	utf8mb4_general_ci
amount	decimal(10,2)
status	varchar(50)	utf8mb4_general_ci
created_at	timestamp
updated_at	timestamp
credit_time	varchar(100)	utf8mb4_general_ci
customer_email	varchar(255)	utf8mb4_general_ci
customer_phone	varchar(20)	utf8mb4_general_ci
customer_address	text	utf8mb4_general_ci
origin	varchar(255)	utf8mb4_general_ci
destination	varchar(255)	utf8mb4_general_ci
vessel	varchar(255)	utf8mb4_general_ci
voyage	varchar(255)	utf8mb4_general_ci
commodity	varchar(255)	utf8mb4_general_ci
mb_l	varchar(255)	utf8mb4_general_ci
deliver	varchar(255)	utf8mb4_general_ci
weight	varchar(100)	utf8mb4_general_ci
shipper	varchar(255)	utf8mb4_general_ci
consignee	varchar(255)	utf8mb4_general_ci
notify	varchar(255)	utf8mb4_general_ci
hb_l	varchar(255)	utf8mb4_general_ci
boe_no	varchar(255)	utf8mb4_general_ci
volume	varchar(100)	utf8mb4_general_ci
packages	varchar(100)	utf8mb4_general_ci
remarks	text	utf8mb4_general_ci
currency	varchar(10)	utf8mb4_general_ci
our_reference	varchar(255)	utf8mb4_general_ci
your_reference	varchar(255)	utf8mb4_general_ci
vat_percentage	decimal(5,2)
vat_amount	decimal(10,2)
total_amount	decimal(10,2)
amount_in_words	text	utf8mb4_general_ci
bank_name	varchar(255)	utf8mb4_general_ci
bank_account_name	varchar(255)	utf8mb4_general_ci
iban_aed	varchar(255)	utf8mb4_general_ci
iban_usd	varchar(255)	utf8mb4_general_ci
bic	varchar(255)	utf8mb4_general_ci
payment_terms	text	utf8mb4_general_ci
prepared_by	varchar(255)	utf8mb4_general_ci
authorized_by	varchar(255)	utf8mb4_general_ci
customer_price	decimal(10,2)
agent_price	decimal(10,2)
invoice_date	date

Column

Type

Collation

Operator

Value

varchar(255)

utf8mb4_general_ci

reference_number

varchar(20)

utf8mb4_general_ci

job_id

varchar(255)

utf8mb4_general_ci

customer_name

varchar(255)

utf8mb4_general_ci

amount

decimal(10,2)

status

varchar(50)

utf8mb4_general_ci

created_at

timestamp

updated_at

timestamp

credit_time

varchar(100)

utf8mb4_general_ci

customer_email

varchar(255)

utf8mb4_general_ci

customer_phone

varchar(20)

utf8mb4_general_ci

customer_address

text

utf8mb4_general_ci

origin

varchar(255)

utf8mb4_general_ci

destination

varchar(255)

utf8mb4_general_ci

vessel

varchar(255)

utf8mb4_general_ci

voyage

varchar(255)

utf8mb4_general_ci

commodity

varchar(255)

utf8mb4_general_ci

mb_l

varchar(255)

utf8mb4_general_ci

deliver

varchar(255)

utf8mb4_general_ci

weight

varchar(100)

utf8mb4_general_ci

shipper

varchar(255)

utf8mb4_general_ci

consignee

varchar(255)

utf8mb4_general_ci

notify

varchar(255)

utf8mb4_general_ci

hb_l

varchar(255)

utf8mb4_general_ci

boe_no

varchar(255)

utf8mb4_general_ci

volume

varchar(100)

utf8mb4_general_ci

packages

varchar(100)

utf8mb4_general_ci

remarks

text

utf8mb4_general_ci

currency

varchar(10)

utf8mb4_general_ci

our_reference

varchar(255)

utf8mb4_general_ci

your_reference

varchar(255)

utf8mb4_general_ci

vat_percentage

decimal(5,2)

vat_amount

decimal(10,2)

total_amount

decimal(10,2)

amount_in_words

text

utf8mb4_general_ci

bank_name

varchar(255)

utf8mb4_general_ci

bank_account_name

varchar(255)

utf8mb4_general_ci

iban_aed

varchar(255)

utf8mb4_general_ci

iban_usd

varchar(255)

utf8mb4_general_ci

bic

varchar(255)

utf8mb4_general_ci

payment_terms

text

utf8mb4_general_ci

prepared_by

varchar(255)

utf8mb4_general_ci

authorized_by

varchar(255)

utf8mb4_general_ci

customer_price

decimal(10,2)

agent_price

decimal(10,2)

invoice_date

date

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

id
reference_number
job_id
customer_name
amount
status
created_at
updated_at
credit_time
customer_email
customer_phone
customer_address
origin
destination
vessel
voyage
commodity
mb_l
deliver
weight
shipper
consignee
notify
hb_l
boe_no
volume
packages
remarks
currency
our_reference
your_reference
vat_percentage
vat_amount
total_amount
amount_in_words
bank_name
bank_account_name
iban_aed
iban_usd
bic
payment_terms
prepared_by
authorized_by
customer_price
agent_price
invoice_date

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Range search