ai.surenasolutions.in / 127.0.0.1 / sgm_crm

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 :

Switch to visual builder

Saved bookmarked search:

Column:

Alias:

Show:

Sort:

Sort order:

Criteria:

Ins:	And:
Del:	Or:

Modify:

Or: And:
Ins Del

Ins Del

Add/Delete criteria rows:

Add/Delete columns:

Use tables

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