ai.surenasolutions.in / 127.0.0.1 / rajkamal_crm_schema_backup_20260919

There are no favorite tables.

New
aiskgl
competitive_exam
- competitive_exam
- competitive_exam_qa
edbroad
- ai
  - edbroad_ai
  - edbroad_ai_sumanth
- edbroad_phonepe_standard
fee_fay_india
information_schema
mysql
omr
- omr_platform
- omr_web
performance_schema
phpmyadmin
rajkamal_crm
- rajkamal_crm
- rajkamal_crm_schema_backup_20260919
scoobyai
sgm_crm
surena
- crm
  - surena_crm
  - surena_crm_control
- support
  - surena_support
  - surena_support_sjcebt
test
whatsapp_platform

Customize appearance of the navigation panel.

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 panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

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
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

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.

Databases display options.

Databases

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

Tables display options.

Tables

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 -

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 :

Untracked tables

	Table	Action
	alert_logs	Track table
	api_student	Track table
	audit_logs	Track table
	auth_group	Track table
	auth_group_permissions	Track table
	auth_login_otps	Track table
	auth_permission	Track table
	auth_user	Track table
	auth_user_aliases	Track table
	auth_user_groups	Track table
	auth_user_user_permissions	Track table
	bank_master	Track table
	call_followup_master	Track table
	caste_category	Track table
	cnc_jobs	Track table
	cnc_job_parts	Track table
	cnc_production_gallery_files	Track table
	cnc_production_gallery_files_backup_20260818-214821	Track table
	cnc_production_gallery_files_backup_20260818_171615	Track table
	cnc_production_gallery_files_backup_20260818_172626	Track table
	contra_vouchers	Track table
	coupon_limits	Track table
	coupon_redemptions	Track table
	crm_brochure_queue	Track table
	crm_customer_role	Track table
	crm_enquiry_links_old)	Track table
	crm_leads	Track table
	crm_lead_sources	Track table
	crm_lead_stages	Track table
	crm_quotations	Track table
	crm_service_details	Track table
	crm_service_types	Track table
	crm_tasks	Track table
	crm_tickets	Track table
	crm_tickets_exchange_machine_details	Track table
	crm_ticket_sales	Track table
	crm_ticket_service	Track table
	crm_ticket_status	Track table
	crm_ticket_status_old	Track table
	crm_visits	Track table
	customer_segment	Track table
	customer_tracking_locations	Track table
	daily_financial_summary	Track table
	daily_ledger_balance	Track table
	daily_ledger_movement	Track table
	dashboard_monthly_summary	Track table
	dashboard_summary_snapshot	Track table
	dashboard_yearly_summary	Track table
	date_range_filters	Track table
	discount_calculation_sheets	Track table
	discount_calculation_sheet_rows	Track table
	discount_categories	Track table
	discount_credit_note_entries	Track table
	discount_credit_note_entry_items	Track table
	discount_rebate_approvals	Track table
	discount_rebate_approval_rules	Track table
	discount_rebate_claims	Track table
	discount_rebate_claim_events	Track table
	discount_rebate_claim_number_series	Track table
	discount_rebate_config_audit	Track table
	discount_rebate_credit_allocations	Track table
	discount_rebate_credit_note_cancellations	Track table
	discount_rebate_credit_note_cancellation_events	Track table
	discount_rebate_credit_note_links	Track table
	discount_rebate_customer_agreements	Track table
	discount_rebate_document_reviews	Track table
	discount_rebate_gst_credit_note_generations	Track table
	discount_rebate_gst_hsn_plan_lines	Track table
	discount_rebate_gst_plan_runs	Track table
	discount_rebate_gst_posting_plan_lines	Track table
	discount_rebate_gst_posting_runs	Track table
	discount_rebate_gst_posting_run_lines	Track table
	discount_rebate_gst_reversal_compliance	Track table
	discount_rebate_gst_reversal_compliance_events	Track table
	discount_rebate_gst_source_trace	Track table
	discount_rebate_invoice_allocations	Track table
	discount_rebate_itc_evidence	Track table
	discount_rebate_itc_tracking	Track table
	discount_rebate_itc_tracking_audit	Track table
	discount_rebate_posting_runs	Track table
	discount_rebate_posting_run_lines	Track table
	discount_rebate_reversal_allocation_lines	Track table
	discount_rebate_reversal_events	Track table
	discount_rebate_reversal_outstanding_lines	Track table
	discount_rebate_reversal_periods	Track table
	discount_rebate_reversal_period_events	Track table
	discount_rebate_reversal_runs	Track table
	discount_rebate_reversal_run_lines	Track table
	discount_rebate_reversal_settings	Track table
	discount_rebate_schemes	Track table
	discount_rebate_scheme_slabs	Track table
	discount_rebate_scheme_targets	Track table
	discount_rebate_settings	Track table
	discount_rebate_tax_allocations	Track table
	discount_rule_targets	Track table
	dispatch_details	Track table
	django_admin_log	Track table
	django_content_type	Track table
	django_migrations	Track table
	django_session	Track table
	dynamic_pricing_source_cache	Track table
	dynamic_sales_price_competitor_prices	Track table
	dynamic_sales_price_competitor_rules	Track table
	dynamic_sales_price_configs	Track table
	dynamic_sales_price_discounts	Track table
	dynamic_sales_price_margin_rules	Track table
	dynamic_sales_price_rules_v2	Track table
	dynamic_sales_price_rule_audit_v2	Track table
	einvoices_eway_bill	Track table
	einvoices_eway_log	Track table
	einvoice_eway_cancellation	Track table
	email_scraper_documents	Track table
	email_scraper_invoices	Track table
	email_scraper_messages	Track table
	email_scraper_profiles	Track table
	email_scraper_users	Track table
	email_smtp_settings	Track table
	employees	Track table
	employee_location_points	Track table
	employee_tracking_capture_policy	Track table
	employee_tracking_commands	Track table
	employee_tracking_sessions	Track table
	employee_tracking_settings	Track table
	employee_tracking_test_allowlist	Track table
	employee_visit_tracking	Track table
	exchange_items	Track table
	exchange_items_value	Track table
	expense_entries	Track table
	expense_entry_items	Track table
	expense_invoice_discounts	Track table
	expense_voucher	Track table
	expense_voucher_allocations	Track table
	expense_voucher_allocations_deleted	Track table
	e_invoice_details	Track table
	final_ledger_balance	Track table
	final_ledger_balance_del	Track table
	financial_years	Track table
	gst_api_credentials	Track table
	gst_authcode	Track table
	gst_registration_types	Track table
	invoice_inbox_accounts	Track table
	invoice_outstanding	Track table
	invoice_print_settings	Track table
	invoice_settings	Track table
	items	Track table
	items_branchwise_details	Track table
	items_brands	Track table
	items_category	Track table
	items_category_discounts_map	Track table
	items_company	Track table
	items_delivery_sources	Track table
	items_discount_categories	Track table
	items_discount_types	Track table
	items_godowns	Track table
	items_hsn_sac_deleted	Track table
	items_opening_stock	Track table
	items_scheme_discounts	Track table
	items_stock_ledger	Track table
	items_stock_summary	Track table
	items_tax_hsn_sac	Track table
	items_uom	Track table
	item_batch_daily_movement	Track table
	item_daily_movement	Track table
	item_daily_movement_dirty	Track table
	item_daily_movement_rebuild_log	Track table
	item_effective_pricing	Track table
	item_stock_summary	Track table
	item_transactions	Track table
	journal_vouchers	Track table
	journal_voucher_lines	Track table
	ledger_bank_accounts	Track table
	ledger_contact_details	Track table
	ledger_details	Track table
	ledger_entries_cash	Track table
	ledger_groups	Track table
	ledger_keys	Track table
	ledger_opening_balances	Track table
	ledger_party_shipping_details	Track table
	ledger_postings	Track table
	ledger_postings_audit	Track table
	ledger_shipping_details	Track table
	ledger_transactions	Track table
	ledger_types_deleted	Track table
	mastergst_tokens	Track table
	message_queue	Track table
	mobile_api_auth_attempts	Track table
	mobile_api_devices	Track table
	mobile_api_sessions	Track table
	mobile_crm_ticket_links	Track table
	mobile_customer_statement_shares	Track table
	mobile_field_operations	Track table
	mobile_field_operation_attachments	Track table
	mobile_notification_reads	Track table
	monthly_financial_summary	Track table
	parts	Track table
	parts_backup_20260818_170943	Track table
	parts_backup_20260818_172626	Track table
	parts_backup_20260818_173857	Track table
	party_comments	Track table
	party_type	Track table
	payment_details_draft	Track table
	payment_followup	Track table
	payment_followup_status	Track table
	payment_purchase_mapping	Track table
	payment_types	Track table
	payment_vouchers	Track table
	payment_voucher_allocations	Track table
	plant_details	Track table
	postings_audit_log	Track table
	posting_audit_log	Track table
	posting_control	Track table
	posting_period_control	Track table
	pricing_recompute_queue	Track table
	purchase_entries	Track table
	purchase_entries_old	Track table
	purchase_entry_items	Track table
	purchase_entry_items_old	Track table
	purchase_invoice_discounts	Track table
	purchase_orders	Track table
	purchase_order_items	Track table
	purchase_received_details_deleted	Track table
	purchase_reorder_vendor_mapping	Track table
	purchase_returns	Track table
	purchase_return_items	Track table
	purchase_return_items_old	Track table
	purchase_return_old	Track table
	qr_payment	Track table
	qr_payment_callback	Track table
	quotation_entries	Track table
	quotation_entry_items	Track table
	receipt_sales_mapping	Track table
	receipt_vouchers	Track table
	receipt_voucher_allocations	Track table
	report_data_entries	Track table
	sales_cancelled_entries	Track table
	sales_entries	Track table
	sales_entry_items	Track table
	sales_invoice_discounts	Track table
	sales_invoice_exchange	Track table
	sales_invoice_other_discounts	Track table
	sales_invoice_subsidy	Track table
	sales_returns	Track table
	sales_return_items	Track table
	sales_return_reasons	Track table
	sales_settings	Track table
	sales_targets	Track table
	sample_table	Track table
	setting_allowed_ips	Track table
	setting_branch_details	Track table
	setting_countries	Track table
	setting_district	Track table
	setting_main_menu	Track table
	setting_states	Track table
	setting_sub_menu	Track table
	stock_movement	Track table
	stock_movement_items	Track table
	stock_po_requisitions	Track table
	stock_po_requisition_items	Track table
	stock_po_vendor_allocations	Track table
	stock_po_vendor_item_rates	Track table
	subsidy_receipt_vouchers	Track table
	subsidy_receipt_voucher_allocations	Track table
	subsidy_schemes	Track table
	subsidy_scheme_application_form	Track table
	subsidy_scheme_documents	Track table
	subsidy_scheme_general_caste_rule	Track table
	subsidy_scheme_items	Track table
	subsidy_scheme_items_amount	Track table
	sub_item	Track table
	tally_posted_rows	Track table
	tally_posting_issues	Track table
	tally_source_batches	Track table
	tally_source_raw10	Track table
	tally_source_typed	Track table
	tally_transactions	Track table
	tds_cumulative	Track table
	tds_deductions	Track table
	tds_master	Track table
	telephony_calls	Track table
	telephony_call_events	Track table
	topbar_order_backup_20260823_120047	Track table
	transaction_additional_charges	Track table
	transaction_drafts	Track table
	transaction_draft_components	Track table
	transaction_draft_items	Track table
	transaction_expenditure_categories	Track table
	transaction_expenditure_vouchers	Track table
	transaction_idempotency_keys	Track table
	transaction_payment_vouchers_expense	Track table
	transaction_receipt_vouchers_old	Track table
	transaction_safety_events	Track table
	universal_discount_rules	Track table
	users_del	Track table
	user_branches	Track table
	user_details	Track table
	user_favorites	Track table
	user_financial_years	Track table
	user_permissions	Track table
	user_roles	Track table
	voucher_additional_charges	Track table
	voucher_numbering_config	Track table
	voucher_series_master	Track table
	voucher_series_master_old	Track table
	voucher_taxes	Track table
	voucher_types	Track table
	voucher_types_old	Track table
	voucher_type_ledger_mappings	Track table
	whatsapp_settings	Track table
	yearly_financial_summary	Track table
	z_bak_cleanup_20260905_b1fy13_att	Track table
	z_bak_cleanup_20260905_b1fy13_ops	Track table
	z_bak_mcrm_20260905_operations	Track table
	z_bak_mcrm_20260905_sales	Track table
	z_bak_mcrm_20260905_service	Track table
	z_bak_mcrm_20260905_tickets	Track table

Check all With selected: