Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: shahiderp
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press 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 charset for all 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:
> >>
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
accounting_ledger 6,403 InnoDB latin1_swedish_ci 1.6 MiB -
accounting_master 17,342 InnoDB latin1_swedish_ci 2.7 MiB -
activity_product 117 InnoDB latin1_swedish_ci 32 KiB -
admin_security_login 2 InnoDB latin1_swedish_ci 32 KiB -
admin_security_pin 3 InnoDB latin1_swedish_ci 32 KiB -
admin_work_report 33,875 InnoDB latin1_swedish_ci 6.9 MiB -
analog_mtn_detail 20 InnoDB latin1_swedish_ci 32 KiB -
analog_mtn_master 9 InnoDB latin1_swedish_ci 32 KiB -
approval_master 9 InnoDB latin1_swedish_ci 32 KiB -
area_city 880 InnoDB latin1_swedish_ci 80 KiB -
area_country 35 InnoDB latin1_swedish_ci 32 KiB -
area_state 186 InnoDB latin1_swedish_ci 48 KiB -
attendence_record ~100,136 InnoDB latin1_swedish_ci 13.5 MiB -
attendence_record_o3 ~100,736 InnoDB latin1_swedish_ci 10 MiB -
attendence_record_o4 0 InnoDB latin1_swedish_ci 32 KiB -
a_version 117 InnoDB latin1_swedish_ci 32 KiB -
bank_master 51 InnoDB latin1_swedish_ci 32 KiB -
bulk_mail 0 InnoDB latin1_swedish_ci 32 KiB -
calling_master 23,841 InnoDB latin1_swedish_ci 2.9 MiB -
calling_priority_master ~84,385 InnoDB utf8mb4_general_ci 18 MiB -
calling_server_one ~1,167,172 InnoDB latin1_swedish_ci 502.6 MiB -
calltransfer_master 5 InnoDB latin1_swedish_ci 48 KiB -
cal_users 249 MyISAM utf8_unicode_ci 119.7 KiB 24 B
cal_users_logactivity 22,252 InnoDB latin1_swedish_ci 2.8 MiB -
cal_users_pending_work 11,500 InnoDB latin1_swedish_ci 1.7 MiB -
cal_users_systemdetails 386 InnoDB latin1_swedish_ci 128 KiB -
cal_user_details 15,025 InnoDB latin1_swedish_ci 752 KiB -
cal_user_entrydetails 139 InnoDB latin1_swedish_ci 32 KiB -
cal_user_salary 8 InnoDB latin1_swedish_ci 32 KiB -
cash_history 724 InnoDB latin1_swedish_ci 128 KiB -
cash_history_details 5,085 InnoDB latin1_swedish_ci 544 KiB -
chat_message 20,607 InnoDB latin1_swedish_ci 2.9 MiB -
client_comment 0 InnoDB latin1_swedish_ci 32 KiB -
client_master 1 InnoDB latin1_swedish_ci 32 KiB -
comment_master ~792,824 InnoDB latin1_swedish_ci 197.4 MiB -
company_assigndata 1,277 InnoDB latin1_swedish_ci 112 KiB -
company_document 4,029 InnoDB latin1_swedish_ci 496 KiB -
company_master 0 InnoDB latin1_swedish_ci 32 KiB -
company_rating 51 InnoDB latin1_swedish_ci 80 KiB -
company_rating_temp 0 InnoDB latin1_swedish_ci 32 KiB -
con_accounts_rating 0 InnoDB latin1_swedish_ci 32 KiB -
con_comment ~762,935 InnoDB latin1_swedish_ci 141.2 MiB -
con_flag_master 11,263 InnoDB latin1_swedish_ci 1.7 MiB -
con_master 34,317 InnoDB latin1_swedish_ci 20.7 MiB -
con_master_temp 23,338 InnoDB latin1_swedish_ci 2 MiB -
con_projects_rating 12 InnoDB latin1_swedish_ci 32 KiB -
con_quotation ~259,710 InnoDB latin1_swedish_ci 48.1 MiB -
con_rentalpayment 2,810 InnoDB latin1_swedish_ci 432 KiB -
con_rental_quotation 32,439 InnoDB latin1_swedish_ci 6.5 MiB -
con_rental_receipt 0 InnoDB latin1_swedish_ci 32 KiB -
con_salespayment 7,253 InnoDB latin1_swedish_ci 1.7 MiB -
con_sale_receipt 7 InnoDB latin1_swedish_ci 32 KiB -
credit_note_master 59 InnoDB latin1_swedish_ci 32 KiB -
currency_master 2 InnoDB latin1_swedish_ci 32 KiB -
daily_calling_master 2,444 InnoDB latin1_swedish_ci 176 KiB -
daily_calling_sheet ~1,463,688 InnoDB latin1_swedish_ci 203.2 MiB -
daily_production 12 InnoDB latin1_swedish_ci 32 KiB -
daily_rentalstock 6 InnoDB latin1_swedish_ci 32 KiB -
daily_salesstock 0 InnoDB latin1_swedish_ci 32 KiB -
dashboard_filter 1,711 InnoDB latin1_swedish_ci 288 KiB -
dashboard_unfollow 27,878 InnoDB latin1_swedish_ci 1.8 MiB -
delivery_comp ~69,534 InnoDB latin1_swedish_ci 8 MiB -
delivery_detail 20,938 InnoDB latin1_swedish_ci 1.8 MiB -
delivery_master 11,099 InnoDB latin1_swedish_ci 2.8 MiB -
delivery_spces 37,873 InnoDB latin1_swedish_ci 4 MiB -
department_job 65 InnoDB latin1_swedish_ci 32 KiB -
department_master 13 InnoDB latin1_swedish_ci 32 KiB -
document_master 41,440 InnoDB latin1_swedish_ci 7 MiB -
doc_special_image 634 InnoDB latin1_swedish_ci 112 KiB -
excel_data_comments 7,856 InnoDB latin1_swedish_ci 1.5 MiB -
excel_data_master 1,071 InnoDB latin1_swedish_ci 304 KiB -
excel_data_master_radon 1,102 InnoDB latin1_swedish_ci 240 KiB -
excel_quotation_comp 636 InnoDB latin1_swedish_ci 96 KiB -
excel_quotation_detail 683 InnoDB latin1_swedish_ci 208 KiB -
excel_quotation_master 348 InnoDB latin1_swedish_ci 128 KiB -
excel_quotation_specs 378 InnoDB latin1_swedish_ci 64 KiB -
fine_master 17 InnoDB latin1_swedish_ci 32 KiB -
followup_salequotation 1 InnoDB latin1_swedish_ci 32 KiB -
hr_leave_master 0 InnoDB latin1_swedish_ci 32 KiB -
incentive_master 19 InnoDB latin1_swedish_ci 32 KiB -
incoming_lead_generate 11,450 InnoDB latin1_swedish_ci 3.7 MiB -
invoice_comp ~64,709 InnoDB latin1_swedish_ci 8 MiB -
invoice_detail 19,450 InnoDB latin1_swedish_ci 1.8 MiB -
invoice_master 10,404 InnoDB latin1_swedish_ci 4 MiB -
invoice_print 1 InnoDB latin1_swedish_ci 32 KiB -
invoice_spces 35,037 InnoDB latin1_swedish_ci 4 MiB -
lead_comment 3,804 InnoDB latin1_swedish_ci 1.5 MiB -
lead_master 11,443 InnoDB latin1_swedish_ci 2.7 MiB -
leave_application 347 InnoDB latin1_swedish_ci 144 KiB -
leave_application_old 230 InnoDB latin1_swedish_ci 112 KiB -
leave_master 24 InnoDB latin1_swedish_ci 32 KiB -
leave_master_april 38 InnoDB latin1_swedish_ci 32 KiB -
leave_master_dec2019 35 InnoDB latin1_swedish_ci 16 KiB -
leave_master_feb_2020 34 InnoDB latin1_swedish_ci 16 KiB -
leave_master_month 39 InnoDB latin1_swedish_ci 32 KiB -
leave_master_temp 35 InnoDB latin1_swedish_ci 32 KiB -
leave_rollback 0 InnoDB latin1_swedish_ci 32 KiB -
ledger_list 88 InnoDB latin1_swedish_ci 32 KiB -
ledger_master 6 InnoDB latin1_swedish_ci 32 KiB -
location_master 0 InnoDB latin1_swedish_ci 32 KiB -
login_details 17,177 InnoDB latin1_swedish_ci 1.7 MiB -
log_master 46,003 InnoDB latin1_swedish_ci 6 MiB -
master_invoice 11,652 InnoDB latin1_swedish_ci 2.7 MiB -
menu_category 29 InnoDB latin1_swedish_ci 32 KiB -
menu_subcategory 511 InnoDB latin1_swedish_ci 96 KiB -
menu_useraccess ~69,055 InnoDB latin1_swedish_ci 5 MiB -
mobileapp_chat_comments 0 InnoDB latin1_swedish_ci 32 KiB -
mobileapp_collection_comment 0 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_collection_master 26 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_comments 0 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_company_visit 3 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_company_visit_comment 0 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_delivery_comment 0 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_delivery_master 3,054 InnoDB latin1_swedish_ci 1.5 MiB -
mobileapp_document_comment 0 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_document_master 4 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_group_master 0 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_group_members 0 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_group_messages 0 InnoDB latin1_swedish_ci 16 KiB -
mobileapp_site_visit 3 InnoDB latin1_swedish_ci 16 KiB -
mobile_master 27 InnoDB latin1_swedish_ci 32 KiB -
mrn_detail 5,957 InnoDB latin1_swedish_ci 352 KiB -
mrn_master 1,518 InnoDB latin1_swedish_ci 208 KiB -
mtf_detail 1,186 InnoDB latin1_swedish_ci 112 KiB -
mtf_master 349 InnoDB latin1_swedish_ci 96 KiB -
mtr_detail 8,813 InnoDB latin1_swedish_ci 464 KiB -
mtr_master 1,151 InnoDB latin1_swedish_ci 176 KiB -
newsalert 8 InnoDB latin1_swedish_ci 16 KiB -
notice_master 0 InnoDB latin1_swedish_ci 32 KiB -
notification_detail ~406,154 InnoDB latin1_swedish_ci 36.1 MiB -
notification_master ~65,155 InnoDB latin1_swedish_ci 10 MiB -
office_master 5 InnoDB latin1_swedish_ci 32 KiB -
official_holiday 10 InnoDB latin1_swedish_ci 32 KiB -
old1_petty_subcategory 50 InnoDB latin1_swedish_ci 16 KiB -
old1_petty_subcategorylast 26 InnoDB latin1_swedish_ci 16 KiB -
old1_podelivery_detail 6,086 InnoDB latin1_swedish_ci 352 KiB -
old1_podelivery_master 1,367 InnoDB latin1_swedish_ci 208 KiB -
old1_podoreturn_detail 0 InnoDB latin1_swedish_ci 16 KiB -
old1_podoreturn_master 0 InnoDB latin1_swedish_ci 16 KiB -
old1_purchase_amount 1,235 InnoDB latin1_swedish_ci 176 KiB -
old1_purchase_details 3,978 InnoDB latin1_swedish_ci 1.5 MiB -
old1_purchase_master 1,232 InnoDB latin1_swedish_ci 416 KiB -
old1_purchase_receipt 1,034 InnoDB latin1_swedish_ci 256 KiB -
oldd-rainloop_ab_properties 0 InnoDB utf8_general_ci 16 KiB -
old_petty_category 21 InnoDB latin1_swedish_ci 16 KiB -
old_petty_subcategory 60 InnoDB latin1_swedish_ci 16 KiB -
old_petty_subcategorylast 90 InnoDB latin1_swedish_ci 16 KiB -
old_prod_master 1,895 InnoDB latin1_swedish_ci 512 KiB -
old_purchase_details 3,576 InnoDB latin1_swedish_ci 464 KiB -
old_warehouse_master 408 InnoDB latin1_swedish_ci 80 KiB -
org_address 33,504 InnoDB latin1_swedish_ci 5.5 MiB -
org_address_temp 11 InnoDB latin1_swedish_ci 32 KiB -
org_comment ~145,635 InnoDB latin1_swedish_ci 25.1 MiB -
org_industry 43 InnoDB latin1_swedish_ci 32 KiB -
org_invoiceaddress 5,577 InnoDB latin1_swedish_ci 384 KiB -
org_master 33,464 InnoDB latin1_swedish_ci 18.9 MiB -
org_master_temp 13 InnoDB latin1_swedish_ci 32 KiB -
org_transfer 21,019 InnoDB latin1_swedish_ci 1.5 MiB -
packing_list_comp 0 InnoDB latin1_swedish_ci 32 KiB -
packing_list_detail 21 InnoDB latin1_swedish_ci 32 KiB -
packing_list_master 2 InnoDB latin1_swedish_ci 32 KiB -
packing_list_spces 0 InnoDB latin1_swedish_ci 32 KiB -
page_permission 285 InnoDB latin1_swedish_ci 64 KiB -
payment_collection 1,215 InnoDB latin1_swedish_ci 224 KiB -
payment_terms 46 InnoDB latin1_swedish_ci 32 KiB -
perform_sales_comp 19,965 InnoDB latin1_swedish_ci 2.7 MiB -
perform_sales_detail 5,737 InnoDB latin1_swedish_ci 432 KiB -
perform_sales_master 2,624 InnoDB latin1_swedish_ci 1.7 MiB -
perform_sales_spces 10,365 InnoDB latin1_swedish_ci 2.1 MiB -
petty_cash 6 InnoDB latin1_swedish_ci 32 KiB -
petty_cash_income 0 InnoDB latin1_swedish_ci 32 KiB -
petty_cash_new 3 InnoDB latin1_swedish_ci 16 KiB -
petty_cash_project 3 InnoDB latin1_swedish_ci 32 KiB -
petty_category 10 InnoDB latin1_swedish_ci 16 KiB -
petty_subcategory 51 InnoDB latin1_swedish_ci 16 KiB -
petty_subcategorylast 27 InnoDB latin1_swedish_ci 16 KiB -
podelivery_comp 0 InnoDB latin1_swedish_ci 48 KiB -
podelivery_detail 1,226 InnoDB latin1_swedish_ci 272 KiB -
podelivery_master 523 InnoDB latin1_swedish_ci 192 KiB -
podelivery_spces 232 InnoDB latin1_swedish_ci 64 KiB -
podoreturn_detail 4 InnoDB latin1_swedish_ci 48 KiB -
podoreturn_master 2 InnoDB latin1_swedish_ci 64 KiB -
po_detail 0 InnoDB latin1_swedish_ci 16 KiB -
po_master 0 InnoDB latin1_swedish_ci 16 KiB -
prformarental_invoice_comp 1,721 InnoDB latin1_swedish_ci 272 KiB -
prformarental_invoice_detail 348 InnoDB latin1_swedish_ci 80 KiB -
prformarental_invoice_master 220 InnoDB latin1_swedish_ci 128 KiB -
prformarental_invoice_spces 1,275 InnoDB latin1_swedish_ci 160 KiB -
prints_history 149 InnoDB latin1_swedish_ci 16 KiB -
production_activity 10,524 InnoDB latin1_swedish_ci 1.7 MiB -
production_comp 141 InnoDB latin1_swedish_ci 64 KiB -
production_master 6,158 InnoDB latin1_swedish_ci 1.6 MiB -
production_product 13,124 InnoDB latin1_swedish_ci 1.8 MiB -
product_analysis_master 128 InnoDB latin1_swedish_ci 48 KiB -
product_catalogue 1 InnoDB latin1_swedish_ci 16 KiB -
product_category_detail 756 InnoDB latin1_swedish_ci 112 KiB -
product_category_master 61 InnoDB latin1_swedish_ci 48 KiB -
product_mrn 3,311 InnoDB latin1_swedish_ci 528 KiB -
product_unit 13 InnoDB latin1_swedish_ci 32 KiB -
prod_comp 10,338 InnoDB latin1_swedish_ci 2.1 MiB -
prod_description 575 InnoDB latin1_swedish_ci 112 KiB -
prod_master 2,052 InnoDB latin1_swedish_ci 1.6 MiB -
prod_specs 2,150 InnoDB latin1_swedish_ci 288 KiB -
project_master 0 InnoDB latin1_swedish_ci 16 KiB -
purchase_amount 861 InnoDB latin1_swedish_ci 192 KiB -
purchase_comp 34 InnoDB latin1_swedish_ci 48 KiB -
purchase_details 884 InnoDB latin1_swedish_ci 256 KiB -
purchase_master 338 InnoDB latin1_swedish_ci 192 KiB -
purchase_receipt 51 InnoDB latin1_swedish_ci 64 KiB -
purchase_specs 264 InnoDB latin1_swedish_ci 48 KiB -
quotation_comp ~1,062,871 InnoDB latin1_swedish_ci 146.7 MiB -
quotation_details ~126,966 InnoDB latin1_swedish_ci 15.5 MiB -
quotation_master 47,608 InnoDB latin1_swedish_ci 34.5 MiB -
quotation_specs ~203,295 InnoDB latin1_swedish_ci 22.5 MiB -
radon_call 0 InnoDB latin1_swedish_ci 16 KiB -
rainloop_ab_contacts 50 InnoDB utf8_general_ci 32 KiB -
rainloop_ab_properties 24,433 InnoDB utf8_general_ci 8.1 MiB -
rainloop_system 1 InnoDB utf8_general_ci 32 KiB -
rainloop_users 10 InnoDB latin1_swedish_ci 32 KiB -
rating_individual 1 InnoDB latin1_swedish_ci 16 KiB -
rental_amount 3,444 InnoDB latin1_swedish_ci 416 KiB -
rental_delivery_comp 14,931 InnoDB latin1_swedish_ci 2.6 MiB -
rental_delivery_detail 3,945 InnoDB latin1_swedish_ci 608 KiB -
rental_delivery_master 2,045 InnoDB latin1_swedish_ci 480 KiB -
rental_delivery_spces 9,761 InnoDB latin1_swedish_ci 2.3 MiB -
rental_document_upload 206 InnoDB latin1_swedish_ci 64 KiB -
rental_extension_comp 2,839 InnoDB latin1_swedish_ci 576 KiB -
rental_extension_detail 553 InnoDB latin1_swedish_ci 128 KiB -
rental_extension_master 362 InnoDB latin1_swedish_ci 208 KiB -
rental_extension_spces 1,867 InnoDB latin1_swedish_ci 336 KiB -
rental_invoice_comp 25,771 InnoDB latin1_swedish_ci 8.1 MiB -
rental_invoice_detail 6,774 InnoDB latin1_swedish_ci 2 MiB -
rental_invoice_master 3,485 InnoDB latin1_swedish_ci 1.8 MiB -
rental_invoice_spces 17,372 InnoDB latin1_swedish_ci 2.8 MiB -
rental_missing_comp 152 InnoDB latin1_swedish_ci 16 KiB -
rental_missing_damage_detail_temp 2 InnoDB latin1_swedish_ci 16 KiB -
rental_missing_damage_master_temp 1 InnoDB latin1_swedish_ci 16 KiB -
rental_missing_detail 84 InnoDB latin1_swedish_ci 16 KiB -
rental_missing_master 21 InnoDB latin1_swedish_ci 16 KiB -
rental_pending_material 14,356 InnoDB latin1_swedish_ci 2.5 MiB -
rental_quotation_comp ~257,593 InnoDB latin1_swedish_ci 35.6 MiB -
rental_quotation_details 12,185 InnoDB latin1_swedish_ci 2.1 MiB -
rental_quotation_master 8,655 InnoDB latin1_swedish_ci 5.3 MiB -
rental_quotation_specs ~51,852 InnoDB latin1_swedish_ci 6.5 MiB -
rental_received_comp 5,342 InnoDB latin1_swedish_ci 1.9 MiB -
rental_received_detail 10,206 InnoDB latin1_swedish_ci 2.2 MiB -
rental_received_detail_temp 8,313 InnoDB latin1_swedish_ci 1.5 MiB -
rental_received_document 1,363 InnoDB latin1_swedish_ci 176 KiB -
rental_received_master 1,844 InnoDB latin1_swedish_ci 448 KiB -
rental_received_master_temp 1,051 InnoDB latin1_swedish_ci 288 KiB -
250 tables Sum ~8,317,854 InnoDB latin1_swedish_ci 1.7 GiB 24 B
Page number:
> >>

Create table
Name:
Number of columns: