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 :

Database structure

Choose which details to show in the database structure (list of tables).

Database structure

Show table charset Show or hide a column displaying the charset for all tables.
Show table comments Show or hide a column displaying the comments for all tables.
Show creation timestamp Show or hide a column displaying the Creation timestamp for all tables.
Show last update timestamp Show or hide a column displaying the Last update timestamp for all tables.
Show last check timestamp Show or hide a column displaying the Last check timestamp for all tables.

Page number: > >>

Filters

Containing the word:

Table	Action							Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11.	Type	Collation	Size	Overhead
agent_tracking_role_permissions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
alert_logs		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	utf8mb4_unicode_ci	144.0 KiB	-
api_student		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
attendance_employee_calendar_assignments		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
attendance_employee_shift_assignments		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
attendance_monthly_close_day_snapshots		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
attendance_monthly_close_employee_snapshots		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
attendance_monthly_close_snapshots		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
attendance_monthly_periods		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
attendance_monthly_period_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
attendance_operations_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
attendance_shift_types		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
attendance_work_calendars		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
attendance_work_calendar_dates		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
attendance_work_calendar_weekly_offs		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
audit_logs		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	144.0 KiB	-
auth_group		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
auth_group_permissions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
auth_login_otps		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
auth_permission		Browse	Structure	Search	Insert	Empty	Drop	32	InnoDB	utf8mb4_general_ci	32.0 KiB	-
auth_user		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
auth_user_aliases		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
auth_user_groups		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
auth_user_user_permissions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
bank_master		Browse	Structure	Search	Insert	Empty	Drop	40	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
biometric_connector_instances		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
biometric_devices		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
biometric_device_audit_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
biometric_device_capability_profiles		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
biometric_device_commands		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
biometric_device_configuration_state		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
biometric_device_enrollments		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
biometric_device_users		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
biometric_employee_mappings		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
biometric_events_raw		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
biometric_sync_state		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
call_followup_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
camcom		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
camcom_settings		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
caste_category		Browse	Structure	Search	Insert	Empty	Drop	22	InnoDB	utf8_unicode_ci	16.0 KiB	-
cnc_jobs		Browse	Structure	Search	Insert	Empty	Drop	23	InnoDB	utf8mb4_general_ci	80.0 KiB	-
cnc_job_parts		Browse	Structure	Search	Insert	Empty	Drop	74	InnoDB	utf8mb4_general_ci	48.0 KiB	-
cnc_production_gallery_files		Browse	Structure	Search	Insert	Empty	Drop	10	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
cnc_production_gallery_files_backup_20260818-214821		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
cnc_production_gallery_files_backup_20260818_171615		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
cnc_production_gallery_files_backup_20260818_172626		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
contra_vouchers		Browse	Structure	Search	Insert	Empty	Drop	30	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
coupon_limits		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_general_ci	16.0 KiB	-
coupon_redemptions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
crm_brochure_queue		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
crm_customer_role		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8_unicode_ci	16.0 KiB	-
crm_enquiry_links_old)		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
crm_leads		Browse	Structure	Search	Insert	Empty	Drop	19	InnoDB	utf8_unicode_ci	96.0 KiB	-
crm_lead_sources		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	utf8_unicode_ci	48.0 KiB	-
crm_lead_stages		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	utf8_unicode_ci	48.0 KiB	-
crm_quotations		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
crm_service_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
crm_service_types		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	utf8_unicode_ci	32.0 KiB	-
crm_tasks		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
crm_tickets		Browse	Structure	Search	Insert	Empty	Drop	49	InnoDB	utf8mb4_general_ci	112.0 KiB	-
crm_tickets_exchange_machine_details		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	utf8_unicode_ci	16.0 KiB	-
crm_ticket_sales		Browse	Structure	Search	Insert	Empty	Drop	38	InnoDB	utf8mb4_general_ci	64.0 KiB	-
crm_ticket_service		Browse	Structure	Search	Insert	Empty	Drop	11	InnoDB	utf8mb4_general_ci	80.0 KiB	-
crm_ticket_status		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8_unicode_ci	64.0 KiB	-
crm_ticket_status_old		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	utf8_unicode_ci	32.0 KiB	-
crm_visits		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
customer_segment		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	utf8mb4_general_ci	16.0 KiB	-
customer_tracking_locations		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
daily_financial_summary		Browse	Structure	Search	Insert	Empty	Drop	160	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
daily_ledger_balance		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
daily_ledger_movement		Browse	Structure	Search	Insert	Empty	Drop	11	InnoDB	utf8_unicode_ci	128.0 KiB	-
dashboard_monthly_summary		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
dashboard_summary_snapshot		Browse	Structure	Search	Insert	Empty	Drop	13	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
dashboard_yearly_summary		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
date_range_filters		Browse	Structure	Search	Insert	Empty	Drop	14	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
discount_calculation_sheets		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_calculation_sheet_rows		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
discount_categories		Browse	Structure	Search	Insert	Empty	Drop	13	InnoDB	utf8_unicode_ci	16.0 KiB	-
discount_credit_note_entries		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
discount_credit_note_entry_items		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
discount_rebate_approvals		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
discount_rebate_approval_rules		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_claims		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	176.0 KiB	-
discount_rebate_claim_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_claim_number_series		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_config_audit		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_credit_allocations		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_credit_note_cancellations		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_credit_note_cancellation_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
discount_rebate_credit_note_links		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_customer_agreements		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_document_reviews		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_gst_credit_note_generations		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_gst_hsn_plan_lines		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_gst_plan_runs		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_gst_posting_plan_lines		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_gst_posting_runs		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
discount_rebate_gst_posting_run_lines		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_gst_reversal_compliance		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_gst_reversal_compliance_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_gst_source_trace		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
discount_rebate_invoice_allocations		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_itc_evidence		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_itc_tracking		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_itc_tracking_audit		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_posting_runs		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_posting_run_lines		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_reversal_allocation_lines		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_reversal_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_reversal_outstanding_lines		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_reversal_periods		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_reversal_period_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_reversal_runs		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
discount_rebate_reversal_run_lines		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_reversal_settings		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
discount_rebate_schemes		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_scheme_slabs		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_scheme_targets		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_settings		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_tax_allocations		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
discount_rule_targets		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
dispatch_details		Browse	Structure	Search	Insert	Empty	Drop	548	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
django_admin_log		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
django_content_type		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	utf8mb4_general_ci	32.0 KiB	-
django_migrations		Browse	Structure	Search	Insert	Empty	Drop	19	InnoDB	utf8mb4_general_ci	16.0 KiB	-
django_session		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
dynamic_pricing_source_cache		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
dynamic_sales_price_competitor_prices		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
dynamic_sales_price_competitor_rules		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_general_ci	32.0 KiB	-
dynamic_sales_price_configs		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8_unicode_ci	16.0 KiB	-
dynamic_sales_price_discounts		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	48.0 KiB	-
dynamic_sales_price_margin_rules		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8mb4_general_ci	48.0 KiB	-
dynamic_sales_price_rules_v2		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	80.0 KiB	-
dynamic_sales_price_rule_audit_v2		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
einvoices_eway_bill		Browse	Structure	Search	Insert	Empty	Drop	253	InnoDB	utf8_unicode_ci	1.5 MiB	-
einvoices_eway_log		Browse	Structure	Search	Insert	Empty	Drop	189	InnoDB	utf8mb4_unicode_ci	400.0 KiB	-
einvoice_eway_cancellation		Browse	Structure	Search	Insert	Empty	Drop	15	InnoDB	utf8_unicode_ci	16.0 KiB	-
email_scraper_documents		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	utf8mb4_unicode_ci	4.0 KiB	-
email_scraper_invoices		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
email_scraper_messages		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
email_scraper_profiles		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
email_scraper_users		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
email_smtp_settings		Browse	Structure	Search	Insert	Empty	Drop	36	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
employees		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
employee_attendance_correction_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
employee_attendance_correction_requests		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
employee_attendance_daily		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
employee_attendance_evidence		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
employee_attendance_overtime_reviews		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
employee_leave_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
employee_leave_requests		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
employee_leave_request_days		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
employee_leave_types		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
employee_location_points		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
employee_tracking_capture_policy		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
employee_tracking_commands		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
employee_tracking_operational_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
employee_tracking_policy_audit		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
employee_tracking_retention_policy		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
employee_tracking_sessions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
employee_tracking_settings		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
employee_tracking_test_allowlist		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
employee_visit_tracking		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
exchange_items		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	utf8mb4_general_ci	16.0 KiB	-
exchange_items_value		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	utf8_unicode_ci	16.0 KiB	-
expense_entries		Browse	Structure	Search	Insert	Empty	Drop	368	InnoDB	utf8mb4_unicode_ci	208.0 KiB	-
expense_entry_items		Browse	Structure	Search	Insert	Empty	Drop	339	InnoDB	utf8mb4_unicode_ci	176.0 KiB	-
expense_invoice_discounts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
expense_voucher		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
expense_voucher_allocations		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
expense_voucher_allocations_deleted		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
e_invoice_details		Browse	Structure	Search	Insert	Empty	Drop	285	InnoDB	utf8_unicode_ci	112.0 KiB	-
final_ledger_balance		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
final_ledger_balance_del		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
financial_years		Browse	Structure	Search	Insert	Empty	Drop	17	InnoDB	latin1_swedish_ci	48.0 KiB	-
gst_api_credentials		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8_unicode_ci	32.0 KiB	-
gst_authcode		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8_unicode_ci	16.0 KiB	-
gst_registration_types		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
invoice_inbox_accounts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
invoice_outstanding		Browse	Structure	Search	Insert	Empty	Drop	2,197	InnoDB	utf8mb4_unicode_ci	592.0 KiB	-
invoice_print_settings		Browse	Structure	Search	Insert	Empty	Drop	13	InnoDB	utf8_unicode_ci	16.0 KiB	-
invoice_settings		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8_unicode_ci	16.0 KiB	-
items		Browse	Structure	Search	Insert	Empty	Drop	1,105	InnoDB	utf8mb4_unicode_ci	656.0 KiB	-
items_branchwise_details		Browse	Structure	Search	Insert	Empty	Drop	1,175	InnoDB	utf8mb4_unicode_ci	176.0 KiB	-
items_brands		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
items_category		Browse	Structure	Search	Insert	Empty	Drop	33	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
items_category_discounts_map		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
items_company		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
items_delivery_sources		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
items_discount_categories		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
items_discount_types		Browse	Structure	Search	Insert	Empty	Drop	72	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
items_godowns		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
items_hsn_sac_deleted		Browse	Structure	Search	Insert	Empty	Drop	114	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
items_opening_stock		Browse	Structure	Search	Insert	Empty	Drop	1,100	InnoDB	utf8mb4_unicode_ci	352.0 KiB	-
items_scheme_discounts		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
items_stock_ledger		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
items_stock_summary		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
items_tax_hsn_sac		Browse	Structure	Search	Insert	Empty	Drop	22,479	InnoDB	utf8mb4_unicode_ci	6.3 MiB	-
items_uom		Browse	Structure	Search	Insert	Empty	Drop	46	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
item_batch_daily_movement		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
item_daily_movement		Browse	Structure	Search	Insert	Empty	Drop	3,088	InnoDB	utf8mb4_unicode_ci	3.3 MiB	-
item_daily_movement_dirty		Browse	Structure	Search	Insert	Empty	Drop	3,834	InnoDB	utf8mb4_unicode_ci	2.4 MiB	-
item_daily_movement_dirty_scope_fix_backup_20260922		Browse	Structure	Search	Insert	Empty	Drop	8,415	InnoDB	utf8mb4_unicode_ci	3.4 MiB	-
item_daily_movement_rebuild_log		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
item_effective_pricing		Browse	Structure	Search	Insert	Empty	Drop	3,511	InnoDB	utf8mb4_general_ci	1.8 MiB	-
item_stock_summary		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
item_transactions		Browse	Structure	Search	Insert	Empty	Drop	12,261	InnoDB	utf8mb4_unicode_ci	7.7 MiB	-
journal_vouchers		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
journal_voucher_lines		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
ledger_bank_accounts		Browse	Structure	Search	Insert	Empty	Drop	128	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
ledger_contact_details		Browse	Structure	Search	Insert	Empty	Drop	299	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
ledger_details		Browse	Structure	Search	Insert	Empty	Drop	3,357	InnoDB	utf8mb4_unicode_ci	4.4 MiB	-
ledger_entries_cash		Browse	Structure	Search	Insert	Empty	Drop	1,595	InnoDB	utf8mb4_unicode_ci	832.0 KiB	-
ledger_groups		Browse	Structure	Search	Insert	Empty	Drop	29	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
ledger_keys		Browse	Structure	Search	Insert	Empty	Drop	131	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
ledger_opening_balances		Browse	Structure	Search	Insert	Empty	Drop	344	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
ledger_party_shipping_details		Browse	Structure	Search	Insert	Empty	Drop	352	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
ledger_postings		Browse	Structure	Search	Insert	Empty	Drop	11,331	InnoDB	utf8mb4_unicode_ci	14.8 MiB	-
ledger_postings_audit		Browse	Structure	Search	Insert	Empty	Drop	~72,407	InnoDB	utf8mb4_general_ci	52.8 MiB	-
ledger_shipping_details		Browse	Structure	Search	Insert	Empty	Drop	1,127	InnoDB	utf8mb4_unicode_ci	320.0 KiB	-
ledger_transactions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	272.0 KiB	-
ledger_types_deleted		Browse	Structure	Search	Insert	Empty	Drop	34	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
mastergst_tokens		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
message_queue		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
mobile_api_auth_attempts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
mobile_api_devices		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
mobile_api_sessions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
mobile_collection_finance_audit		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
mobile_collection_finance_reviews		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
mobile_crm_ticket_links		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
mobile_customer_statement_shares		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
mobile_field_operations		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	144.0 KiB	-
mobile_field_operation_attachments		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
mobile_notification_reads		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
monthly_financial_summary		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
parts		Browse	Structure	Search	Insert	Empty	Drop	22	InnoDB	utf8mb4_general_ci	144.0 KiB	-
parts_backup_20260818_170943		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
parts_backup_20260818_172626		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	96.0 KiB	-
parts_backup_20260818_173857		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	96.0 KiB	-
party_comments		Browse	Structure	Search	Insert	Empty	Drop	10	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
party_type		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	utf8mb4_general_ci	16.0 KiB	-
payment_details_draft		Browse	Structure	Search	Insert	Empty	Drop	336	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
payment_followup		Browse	Structure	Search	Insert	Empty	Drop	11	InnoDB	utf8_unicode_ci	16.0 KiB	-
payment_followup_status		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_unicode_ci	32.0 KiB	-
payment_purchase_mapping		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
payment_types		Browse	Structure	Search	Insert	Empty	Drop	13	InnoDB	utf8_unicode_ci	16.0 KiB	-
payment_vouchers		Browse	Structure	Search	Insert	Empty	Drop	533	InnoDB	utf8mb4_unicode_ci	192.0 KiB	-
payment_voucher_allocations		Browse	Structure	Search	Insert	Empty	Drop	504	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
payroll_accounting_batches		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
payroll_accounting_component_mappings		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
250 tables	Sum							~154,810	InnoDB	utf8mb4_unicode_ci	116.0 MiB	0 B

Check all

Page number: > >>

Data dictionary