将文件拖动至此

SQL upload ( 0 ) x-

服务器: localhost »数据库: herp
页面相关设置点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 记录数: 用时:
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: 查询时间:

数据库结构

设置在数据库结构(表列表)中显示哪些细节。

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

  新建数据表
名字:
字段数: