user.tail04d718.ts.net / 127.0.0.1 / invoice_db

alnaqeeb_charity

bagisto

biotimedb

ecommerce_db

emp_track_db

enjazi_db

enjaz_workflow

enterprise_workflow

goal_tracker

hr_complaint_app

icehrm_db

ims

information_schema

inventory_management

invoice_db

jobapplications

kalkun

mysql

opencart_db

performance_schema

phpmyadmin

supermarket_app

test

the_old_database

velstore

workflow

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.
Favourite tables Maximum number of favourite 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.

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

v		invoice_db ip_clients
client_id : int(11)
client_date_created : datetime
client_date_modified : datetime
client_name : text
client_company : varchar(150)
client_address_1 : text
client_address_2 : text
client_city : text
client_state : text
client_zip : text
client_country : text
client_phone : text
client_fax : text
client_mobile : text
client_email : text
client_web : text
client_vat_id : text
client_tax_code : text
client_language : varchar(255)
client_active : int(1)
client_surname : varchar(255)
client_invoicing_contact : varchar(50)
client_title : varchar(50)
client_einvoicing_active : tinyint(1)
client_einvoicing_version : varchar(25)
client_avs : varchar(16)
client_insurednumber : varchar(30)
client_veka : varchar(30)
client_birthdate : date
client_gender : int(1)

v		invoice_db ip_client_custom
client_custom_id : int(11)
client_id : int(11)
client_custom_fieldid : int(11)
client_custom_fieldvalue : text

Customise appearance of the navigation panel.

Customise the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

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.

v		invoice_db ip_client_notes
client_note_id : int(11)
client_id : int(11)
client_note_date : date
client_note : longtext

v		invoice_db ip_custom_fields
custom_field_id : int(11)
custom_field_table : varchar(50)
custom_field_label : varchar(50)
custom_field_type : varchar(255)
custom_field_location : int(11)
custom_field_order : int(11)

v		invoice_db ip_custom_values
custom_values_id : int(11)
custom_values_field : int(11)
custom_values_value : text

v		invoice_db ip_email_templates
email_template_id : int(11)
email_template_title : text
email_template_type : varchar(255)
email_template_body : longtext
email_template_subject : text
email_template_from_name : text
email_template_from_email : text
email_template_cc : text
email_template_bcc : text
email_template_pdf_template : varchar(255)

v		invoice_db ip_families
family_id : int(11)
family_name : text

v		invoice_db ip_imports
import_id : int(11)
import_date : datetime

v		invoice_db ip_import_details
import_detail_id : int(11)
import_id : int(11)
import_lang_key : varchar(35)
import_table_name : varchar(35)
import_record_id : int(11)

v		invoice_db ip_invoices
invoice_id : int(11)
user_id : int(11)
client_id : int(11)
invoice_group_id : int(11)
invoice_status_id : tinyint(2)
is_read_only : tinyint(1)
invoice_password : varchar(90)
invoice_date_created : date
invoice_time_created : time
invoice_date_modified : datetime
invoice_date_due : date
invoice_number : varchar(100)
invoice_discount_amount : decimal(20,2)
invoice_discount_percent : decimal(20,2)
invoice_terms : longtext
invoice_url_key : char(32)
payment_method : int(11)
creditinvoice_parent_id : int(11)

v		invoice_db ip_invoice_amounts
invoice_amount_id : int(11)
invoice_id : int(11)
invoice_sign : enum('1','-1')
invoice_item_subtotal : decimal(20,2)
invoice_item_tax_total : decimal(20,2)
invoice_tax_total : decimal(20,2)
invoice_total : decimal(20,2)
invoice_paid : decimal(20,2)
invoice_balance : decimal(20,2)

v		invoice_db ip_invoice_groups
invoice_group_id : int(11)
invoice_group_name : text
invoice_group_identifier_format : varchar(255)
invoice_group_next_id : int(11)
invoice_group_left_pad : int(2)

v		invoice_db ip_invoice_items
item_id : int(11)
invoice_id : int(11)
item_tax_rate_id : int(11)
item_product_id : int(11)
item_date_added : date
item_task_id : int(11)
item_name : text
item_description : longtext
item_quantity : decimal(20,8)
item_price : decimal(20,2)
item_discount_amount : decimal(20,2)
item_order : int(2)
item_is_recurring : tinyint(1)
item_product_unit : varchar(50)
item_product_unit_id : int(11)
item_date : date

v		invoice_db ip_invoice_item_amounts
item_amount_id : int(11)
item_id : int(11)
item_subtotal : decimal(20,2)
item_tax_total : decimal(20,2)
item_discount : decimal(20,2)
item_total : decimal(20,2)

v		invoice_db ip_invoices_recurring
invoice_recurring_id : int(11)
invoice_id : int(11)
recur_start_date : date
recur_end_date : date
recur_frequency : varchar(255)
recur_next_date : date

v		invoice_db ip_invoice_custom
invoice_custom_id : int(11)
invoice_id : int(11)
invoice_custom_fieldid : int(11)
invoice_custom_fieldvalue : text

v		invoice_db ip_invoice_sumex
sumex_id : int(11)
sumex_invoice : int(11)
sumex_reason : int(11)
sumex_diagnosis : varchar(500)
sumex_observations : varchar(500)
sumex_treatmentstart : date
sumex_treatmentend : date
sumex_casedate : date
sumex_casenumber : varchar(35)

v		invoice_db ip_invoice_tax_rates
invoice_tax_rate_id : int(11)
invoice_id : int(11)
tax_rate_id : int(11)
include_item_tax : int(1)
invoice_tax_rate_amount : decimal(10,2)

v		invoice_db ip_item_lookups
item_lookup_id : int(11)
item_name : varchar(100)
item_description : longtext
item_price : decimal(10,2)

v		invoice_db ip_login_log
login_name : varchar(100)
log_count : int(11)
log_create_timestamp : datetime

v		invoice_db ip_merchant_responses
merchant_response_id : int(11)
invoice_id : int(11)
merchant_response_successful : tinyint(1)
merchant_response_date : date
merchant_response_driver : varchar(35)
merchant_response : varchar(255)
merchant_response_reference : varchar(255)

v		invoice_db ip_payments
payment_id : int(11)
invoice_id : int(11)
payment_method_id : int(11)
payment_date : date
payment_amount : decimal(20,2)
payment_note : longtext

v		invoice_db ip_payment_custom
payment_custom_id : int(11)
payment_id : int(11)
payment_custom_fieldid : int(11)
payment_custom_fieldvalue : text

v		invoice_db ip_payment_methods
payment_method_id : int(11)
payment_method_name : text

Navigation panel

Customise appearance of the navigation panel.

Navigation tree

Customise the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

v		invoice_db ip_products
product_id : int(11)
family_id : int(11)
product_sku : text
product_name : text
product_description : longtext
product_price : decimal(20,2)
purchase_price : decimal(20,2)
provider_name : text
tax_rate_id : int(11)
unit_id : int(11)
product_tariff : int(11)

v		invoice_db ip_projects
project_id : int(11)
client_id : int(11)
project_name : text

v		invoice_db ip_quotes
quote_id : int(11)
invoice_id : int(11)
user_id : int(11)
client_id : int(11)
invoice_group_id : int(11)
quote_status_id : tinyint(2)
quote_date_created : date
quote_date_modified : datetime
quote_date_expires : date
quote_number : varchar(100)
quote_discount_amount : decimal(20,2)
quote_discount_percent : decimal(20,2)
quote_url_key : char(32)
quote_password : varchar(90)
notes : longtext

v		invoice_db ip_quote_amounts
quote_amount_id : int(11)
quote_id : int(11)
quote_item_subtotal : decimal(20,2)
quote_item_tax_total : decimal(20,2)
quote_tax_total : decimal(20,2)
quote_total : decimal(20,2)

v		invoice_db ip_quote_custom
quote_custom_id : int(11)
quote_id : int(11)
quote_custom_fieldid : int(11)
quote_custom_fieldvalue : text

v		invoice_db ip_quote_items
item_id : int(11)
quote_id : int(11)
item_tax_rate_id : int(11)
item_product_id : int(11)
item_date_added : date
item_name : text
item_description : text
item_quantity : decimal(20,8)
item_price : decimal(20,2)
item_discount_amount : decimal(20,2)
item_order : int(2)
item_product_unit : varchar(50)
item_product_unit_id : int(11)

v		invoice_db ip_quote_item_amounts
item_amount_id : int(11)
item_id : int(11)
item_subtotal : decimal(20,2)
item_tax_total : decimal(20,2)
item_discount : decimal(20,2)
item_total : decimal(20,2)

v		invoice_db ip_quote_tax_rates
quote_tax_rate_id : int(11)
quote_id : int(11)
tax_rate_id : int(11)
include_item_tax : int(1)
quote_tax_rate_amount : decimal(20,2)

v		invoice_db ip_sessions
id : varchar(128)
ip_address : varchar(45)
timestamp : int(10) unsigned
data : blob

v		invoice_db ip_settings
setting_id : int(11)
setting_key : varchar(50)
setting_value : longtext