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 :

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							Type	Collation	Size	Overhead
alert_logs		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	144.0 KiB	-
api_student		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
audit_logs		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	144.0 KiB	-
auth_group		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
auth_group_permissions		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
auth_login_otps		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	64.0 KiB	-
auth_permission		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
auth_user		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
auth_user_aliases		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
auth_user_groups		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
auth_user_user_permissions		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
bank_master		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
call_followup_master		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	64.0 KiB	-
caste_category		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
cnc_jobs		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	80.0 KiB	-
cnc_job_parts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
cnc_production_gallery_files		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
cnc_production_gallery_files_backup_20260818-214821		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
cnc_production_gallery_files_backup_20260818_171615		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
cnc_production_gallery_files_backup_20260818_172626		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
contra_vouchers		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
coupon_limits		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
coupon_redemptions		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	64.0 KiB	-
crm_brochure_queue		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
crm_customer_role		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
crm_enquiry_links_old)		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
crm_leads		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	96.0 KiB	-
crm_lead_sources		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	48.0 KiB	-
crm_lead_stages		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	48.0 KiB	-
crm_quotations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
crm_service_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
crm_service_types		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	32.0 KiB	-
crm_tasks		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
crm_tickets		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	112.0 KiB	-
crm_tickets_exchange_machine_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
crm_ticket_sales		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	64.0 KiB	-
crm_ticket_service		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	80.0 KiB	-
crm_ticket_status		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	64.0 KiB	-
crm_ticket_status_old		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	32.0 KiB	-
crm_visits		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
customer_segment		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
customer_tracking_locations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
daily_financial_summary		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
daily_ledger_balance		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
daily_ledger_movement		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	128.0 KiB	-
dashboard_monthly_summary		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
dashboard_summary_snapshot		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
dashboard_yearly_summary		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
date_range_filters		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
discount_calculation_sheets		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_calculation_sheet_rows		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
discount_categories		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
discount_credit_note_entries		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
discount_credit_note_entry_items		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
discount_rebate_approvals		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
discount_rebate_approval_rules		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_claims		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	176.0 KiB	-
discount_rebate_claim_events		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_claim_number_series		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_config_audit		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_credit_allocations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_credit_note_cancellations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_credit_note_cancellation_events		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
discount_rebate_credit_note_links		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_customer_agreements		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_document_reviews		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_gst_credit_note_generations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_gst_hsn_plan_lines		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_gst_plan_runs		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_gst_posting_plan_lines		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_gst_posting_runs		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
discount_rebate_gst_posting_run_lines		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_gst_reversal_compliance		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_gst_reversal_compliance_events		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_gst_source_trace		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
discount_rebate_invoice_allocations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_itc_evidence		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_itc_tracking		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_itc_tracking_audit		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_posting_runs		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_posting_run_lines		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_reversal_allocation_lines		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_reversal_events		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_reversal_outstanding_lines		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_reversal_periods		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_reversal_period_events		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_reversal_runs		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
discount_rebate_reversal_run_lines		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
discount_rebate_reversal_settings		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
discount_rebate_schemes		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
discount_rebate_scheme_slabs		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_scheme_targets		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
discount_rebate_settings		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
discount_rebate_tax_allocations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
discount_rule_targets		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
dispatch_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
django_admin_log		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
django_content_type		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
django_migrations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
django_session		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
dynamic_pricing_source_cache		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
dynamic_sales_price_competitor_prices		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
dynamic_sales_price_competitor_rules		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
dynamic_sales_price_configs		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
dynamic_sales_price_discounts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
dynamic_sales_price_margin_rules		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
dynamic_sales_price_rules_v2		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	80.0 KiB	-
dynamic_sales_price_rule_audit_v2		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
einvoices_eway_bill		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
einvoices_eway_log		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
einvoice_eway_cancellation		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
email_scraper_documents		Browse	Structure	Search	Insert	Empty	Drop	MyISAM	utf8mb4_unicode_ci	4.0 KiB	-
email_scraper_invoices		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
email_scraper_messages		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
email_scraper_profiles		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
email_scraper_users		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
email_smtp_settings		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
employees		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
employee_location_points		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
employee_tracking_capture_policy		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
employee_tracking_commands		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
employee_tracking_sessions		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
employee_tracking_settings		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
employee_tracking_test_allowlist		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
employee_visit_tracking		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
exchange_items		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
exchange_items_value		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
expense_entries		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
expense_entry_items		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
expense_invoice_discounts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
expense_voucher		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
expense_voucher_allocations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
expense_voucher_allocations_deleted		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
e_invoice_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
final_ledger_balance		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
final_ledger_balance_del		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
financial_years		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	latin1_swedish_ci	48.0 KiB	-
gst_api_credentials		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	32.0 KiB	-
gst_authcode		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
gst_registration_types		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
invoice_inbox_accounts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
invoice_outstanding		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
invoice_print_settings		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
invoice_settings		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
items		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	208.0 KiB	-
items_branchwise_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
items_brands		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
items_category		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
items_category_discounts_map		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
items_company		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
items_delivery_sources		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
items_discount_categories		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
items_discount_types		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
items_godowns		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
items_hsn_sac_deleted		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
items_opening_stock		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
items_scheme_discounts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
items_stock_ledger		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	latin1_swedish_ci	16.0 KiB	-
items_stock_summary		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	latin1_swedish_ci	32.0 KiB	-
items_tax_hsn_sac		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
items_uom		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
item_batch_daily_movement		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
item_daily_movement		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	160.0 KiB	-
item_daily_movement_dirty		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
item_daily_movement_rebuild_log		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
item_effective_pricing		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
item_stock_summary		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	64.0 KiB	-
item_transactions		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
journal_vouchers		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
journal_voucher_lines		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
ledger_bank_accounts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
ledger_contact_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
ledger_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	320.0 KiB	-
ledger_entries_cash		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	176.0 KiB	-
ledger_groups		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
ledger_keys		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
ledger_opening_balances		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
ledger_party_shipping_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
ledger_postings		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	208.0 KiB	-
ledger_postings_audit		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	272.0 KiB	-
ledger_shipping_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
ledger_transactions		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	272.0 KiB	-
ledger_types_deleted		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
mastergst_tokens		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
message_queue		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	latin1_swedish_ci	16.0 KiB	-
mobile_api_auth_attempts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
mobile_api_devices		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
mobile_api_sessions		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
mobile_crm_ticket_links		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
mobile_customer_statement_shares		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
mobile_field_operations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	144.0 KiB	-
mobile_field_operation_attachments		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
mobile_notification_reads		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
monthly_financial_summary		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
parts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	96.0 KiB	-
parts_backup_20260818_170943		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	64.0 KiB	-
parts_backup_20260818_172626		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	96.0 KiB	-
parts_backup_20260818_173857		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	96.0 KiB	-
party_comments		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
party_type		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
payment_details_draft		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
payment_followup		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
payment_followup_status		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	32.0 KiB	-
payment_purchase_mapping		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
payment_types		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
payment_vouchers		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
payment_voucher_allocations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
plant_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
postings_audit_log		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
posting_audit_log		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
posting_control		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
posting_period_control		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
pricing_recompute_queue		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
purchase_entries		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
purchase_entries_old		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
purchase_entry_items		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
purchase_entry_items_old		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
purchase_invoice_discounts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
purchase_orders		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	latin1_swedish_ci	48.0 KiB	-
purchase_order_items		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	latin1_swedish_ci	48.0 KiB	-
purchase_received_details_deleted		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
purchase_reorder_vendor_mapping		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
purchase_returns		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	176.0 KiB	-
purchase_return_items		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	240.0 KiB	-
purchase_return_items_old		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
purchase_return_old		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
qr_payment		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
qr_payment_callback		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
quotation_entries		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
quotation_entry_items		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
receipt_sales_mapping		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
receipt_vouchers		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
receipt_voucher_allocations		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
report_data_entries		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	64.0 KiB	-
sales_cancelled_entries		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8_unicode_ci	16.0 KiB	-
sales_entries		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
sales_entry_items		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	144.0 KiB	-
sales_invoice_discounts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	48.0 KiB	-
sales_invoice_exchange		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
sales_invoice_other_discounts		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	32.0 KiB	-
sales_invoice_subsidy		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_general_ci	16.0 KiB	-
sales_returns		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
sales_return_items		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	208.0 KiB	-
sales_return_reasons		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
sales_settings		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
sales_targets		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
sample_table		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	latin1_swedish_ci	16.0 KiB	-
setting_allowed_ips		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	latin1_swedish_ci	16.0 KiB	-
setting_branch_details		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
setting_countries		Browse	Structure	Search	Insert	Empty	Drop	InnoDB	latin1_swedish_ci	32.0 KiB	-
250 tables	Sum							InnoDB	utf8mb4_general_ci	15.4 MiB	0 B

Check all

Page number: > >>

Data dictionary