Drop files here

SQL upload ( 0 ) x-

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

  Create table
Name:
Number of columns: