competence-rs.com / localhost / herp

Navigation panel
Navigation tree
Databases
Tables

Navigation panel

Customize appearance of the 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 tree

Customize the 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

Databases

Databases display options.

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

Tables

Tables display options.

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-

Server: localhost »

Database: herp

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

Database structure

Choose which details to show in the database structure (list of 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.

Page number: > >>

Table	Action							Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11.	Type	Collation	Size	Overhead
accountcategory_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
accountgroupmaster		Browse	Structure	Search	Insert	Empty	Drop	150	InnoDB	latin1_swedish_ci	16 KiB	-
accountgroups		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32 KiB	-
accountledger		Browse	Structure	Search	Insert	Empty	Drop	1,251	InnoDB	latin1_swedish_ci	144 KiB	-
accountledger_dtls		Browse	Structure	Search	Insert	Empty	Drop	1,287	MyISAM	latin1_swedish_ci	51.6 KiB	-
accountsection		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
account_book		Browse	Structure	Search	Insert	Empty	Drop	11,477	InnoDB	latin1_swedish_ci	3.5 MiB	-
account_book_details		Browse	Structure	Search	Insert	Empty	Drop	38,948	InnoDB	latin1_swedish_ci	3.5 MiB	-
account_budget_entry		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_budget_entry_dtls		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_cost_category		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_fund_receipt		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_fund_receipt_dtls		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_gstr_3b		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_gstr_3b_inward_supplies		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_gstr_3b_itc		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_gstr_3b_outward_supplies		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_gstr_3b_payment_tax		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_gstr_3b_tds		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_gstr_3b_unregistered		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
account_invoice_billbook		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
account_multi_currency		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16 KiB	-
account_purchase_billbook		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
account_sale_billbook		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
account_service_billbook		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
acc_fin_yr_closing		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
activity_discription		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
addissue		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
addmrn		Browse	Structure	Search	Insert	Empty	Drop	9,297	InnoDB	latin1_swedish_ci	3.5 MiB	-
addmrnqty		Browse	Structure	Search	Insert	Empty	Drop	49,123	MyISAM	latin1_swedish_ci	5.6 MiB	-
addreturnqty		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
addreturnslip		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
add_service		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
add_service_jobcard		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
advance_management		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16 KiB	-
agent_type_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
allowmaster		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16 KiB	-
apprisal_policy_master		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
approval_dot_and_panel_entry		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
areas		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
assetmanager		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
asset_issue		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	16 KiB	-
asset_issue_details		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	16 KiB	-
asset_return		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16 KiB	-
asset_return_details		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16 KiB	-
attendance_biometric_punch		Browse	Structure	Search	Insert	Empty	Drop	84,119	InnoDB	latin1_swedish_ci	4.5 MiB	-
attendance_complesation		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
audittrail		Browse	Structure	Search	Insert	Empty	Drop	24,790	InnoDB	latin1_swedish_ci	3.9 MiB	-
auto_item_updating		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
bankaccounts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	64 KiB	-
banktrans		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	96 KiB	-
billoutstanding		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
bill_material		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
bill_other_overhead		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
bill_raw_material		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
bom		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	128 KiB	-
bom_location		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
bom_process_operational		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
bom_type		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
bonus_defination_master		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
boq_entry		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
boq_entry_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
break_down_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
break_down_type		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16 KiB	-
brought_opening_amount		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
buckets		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	48 KiB	-
cal_incentive_grade_wise		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
cashbankvoucher		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
cashbankvoucher_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
cashbank_adjustment		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
category_master		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16 KiB	-
chartdetails		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32 KiB	-
chartmaster		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	64 KiB	-
cheque_print_conf		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
city_master		Browse	Structure	Search	Insert	Empty	Drop	93	InnoDB	latin1_swedish_ci	16 KiB	-
clientmaster		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32 KiB	-
clientmaster_consignee_address		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
cl_emp		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
cogsglpostings		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	96 KiB	-
comments		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
companies		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16 KiB	-
company_branch		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
company_financial_years		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	latin1_swedish_ci	16 KiB	-
company_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
company_profile		Browse	Structure	Search	Insert	Empty	Drop	1,608	InnoDB	latin1_swedish_ci	144 KiB	-
company_profile_master		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	latin1_swedish_ci	16 KiB	-
comprative		Browse	Structure	Search	Insert	Empty	Drop	9,848	InnoDB	latin1_swedish_ci	1.5 MiB	-
comprative_detail		Browse	Structure	Search	Insert	Empty	Drop	52,701	InnoDB	latin1_swedish_ci	4.5 MiB	-
config		Browse	Structure	Search	Insert	Empty	Drop	71	InnoDB	latin1_swedish_ci	16 KiB	-
config_hr		Browse	Structure	Search	Insert	Empty	Drop	3	MyISAM	latin1_swedish_ci	2.1 KiB	-
config_hr_compensition		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
conf_bank_master		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
conf_ppc		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	32 KiB	-
conf_purch_approval		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16 KiB	-
conf_purch_app_details		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	32 KiB	-
conf_purch_app_po_range		Browse	Structure	Search	Insert	Empty	Drop	13	InnoDB	latin1_swedish_ci	32 KiB	-
conf_work_indent_details		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
contact_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
contact_information_master		Browse	Structure	Search	Insert	Empty	Drop	444	InnoDB	latin1_swedish_ci	64 KiB	-
contractbom		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	96 KiB	-
contractor_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
contractreqts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32 KiB	-
contracts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	112 KiB	-
costsheet		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
country_master		Browse	Structure	Search	Insert	Empty	Drop	45	InnoDB	latin1_swedish_ci	16 KiB	-
cp_head_approval		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
crm		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	96 KiB	-
crmsales_target		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_accounts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_accounts_new		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_accounts_new_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_addleadnote		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_add_to_do		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_daily_visit_entry		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_daily_visit_expense_entry		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_dot_request_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_followup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_leads		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_leads_pickitem		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_leadtodo		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_lead_groups		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_lead_groups_users		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_lead_items		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_lead_reference		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_login_history		Browse	Structure	Search	Insert	Empty	Drop	51,759	InnoDB	latin1_swedish_ci	2.5 MiB	-
crm_mst_daily_visit_entry		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_panel_entry		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_picklist		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_picklist_itemdata		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_quotes		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
crm_ta_da_claim_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_bin	16 KiB	-
crm_ta_da_claim_form1_old		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_bin	16 KiB	-
crm_ta_da_claim_form_main		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
cstest_estimation_bom		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
cstest_estimation_bom_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
cstest_estimation_bom_details_asmbly		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
csv_client_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
csv_client_master_new		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
currencies		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	latin1_swedish_ci	80 KiB	-
currency_master		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16 KiB	-
currency_master_conversion		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
custallocns		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	64 KiB	-
custbranch		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	128 KiB	-
custcontacts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
custnotes		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
customer_category		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
custom_duty		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
daily_attendance		Browse	Structure	Search	Insert	Empty	Drop	24,380	InnoDB	latin1_swedish_ci	2.5 MiB	-
daily_attendance_2		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
daily_jobwork		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
daily_jobwork_process		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
daily_process_qty_maintain		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
daily_process_sub_item_details		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
daily_production_breakdown		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
daily_production_process		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
daily_raw_material_consu		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
daily_rejection_process		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
daily_visit_entry		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dashboard_master		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_addmrn		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_addmrnqty		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
dbl_complaints_type_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_complaint_category		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_coplaint		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_customer_charges		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_dealer		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_dealer_charge_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_dealer_contact_information_maste		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_dealer_dispatch		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_dealer_dispatch_charge		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_dealer_dispatch_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_dealer_store		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_dealer_store_type		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_direct_po		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_direct_po_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_dispatch_charge_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_engineer_dealer_maste		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_engineer_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_enquiry_charge		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_enquiry_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_enquiry_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_nature_of_complaint		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_prefix_tbl		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_process_charge_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_process_sale_order		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_process_sale_order_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_sale_order_charge		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_sale_return		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dbl_sale_return_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
debtorsmaster		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	144 KiB	-
debtortrans		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	176 KiB	-
debtortranstaxes		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32 KiB	-
debtortype		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16 KiB	-
debtortypenotes		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
deduction_master		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16 KiB	-
deliveredschedule_item		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
deliverynotes		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32 KiB	-
depretiation_calc		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
depretiation_calc_details		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
deptmaster		Browse	Structure	Search	Insert	Empty	Drop	26	InnoDB	latin1_swedish_ci	16 KiB	-
deptmaster_hierarchy		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dept_indet_approval		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16 KiB	-
desigmaster		Browse	Structure	Search	Insert	Empty	Drop	64	InnoDB	latin1_swedish_ci	16 KiB	-
design_prepress_job_card		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
direct_mrn_config		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
direct_po		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
direct_po_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
direct_po_terms_conditions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
discountmatrix		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	64 KiB	-
dispatch		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
dispatch_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32 KiB	-
dms_crrer_mstr		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
dms_doc_followup		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
dms_doc_type		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
dms_doc_type_dtls		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
dms_doc_type_mstr		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
ediitemmapping		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	80 KiB	-
edimessageformat		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	48 KiB	-
edi_orders_segs		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	48 KiB	-
edi_orders_seg_groups		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
employee_address		Browse	Structure	Search	Insert	Empty	Drop	253	InnoDB	latin1_swedish_ci	80 KiB	-
empmaster		Browse	Structure	Search	Insert	Empty	Drop	253	InnoDB	latin1_swedish_ci	128 KiB	-
empmaster_revised_sal		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
emp_allowance_dtls		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
emp_attandence		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
emp_csleave_updation		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
emp_grade		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16 KiB	-
emp_grade_dtls		Browse	Structure	Search	Insert	Empty	Drop	74	MyISAM	latin1_swedish_ci	2.9 KiB	-
emp_leave		Browse	Structure	Search	Insert	Empty	Drop	412	InnoDB	latin1_swedish_ci	80 KiB	-
emp_leave_adjustment		Browse	Structure	Search	Insert	Empty	Drop	414	MyISAM	latin1_swedish_ci	41.5 KiB	-
emp_leave_apply		Browse	Structure	Search	Insert	Empty	Drop	1,259	InnoDB	latin1_swedish_ci	176 KiB	-
emp_leave_old		Browse	Structure	Search	Insert	Empty	Drop	418	InnoDB	latin1_swedish_ci	48 KiB	-
emp_loan_details		Browse	Structure	Search	Insert	Empty	Drop	54	InnoDB	latin1_swedish_ci	16 KiB	-
emp_loan_opening		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1 KiB	-
emp_openingbalance		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
emp_salary		Browse	Structure	Search	Insert	Empty	Drop	2,612	InnoDB	latin1_swedish_ci	160 KiB	-
emp_salary_grade		Browse	Structure	Search	Insert	Empty	Drop	15	InnoDB	latin1_swedish_ci	16 KiB	-
emp_salary_revise		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
emp_statutory_allow_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
enquiry		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
enquiry_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32 KiB	-
enquiry_followup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32 KiB	-
esiallowance_cal		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
esi_master		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16 KiB	-
estimation_hardware_part		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
estimation_sheet		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
estimation_sheet_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
estimation_summary		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
evenement		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16 KiB	-
event		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16 KiB	-
250 tables	Sum							367,343	InnoDB	latin1_swedish_ci	41.3 MiB	0 B

Check all

Page number: > >>

Print view Data dictionary