dev.surenasolutions.in / 127.0.0.1 / rajkamal_crm

There are no favourite tables.

New
information_schema
mysql
payitsea_jnablr
performance_schema
phpmyadmin
rajkamal_crm
sgm_crm
surena
- surena_code_editor
- surena_crm
- edbroad
  - surena_edbroad_1
  - surena_edbroad_old
test

Customise 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.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise 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.

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
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	-
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_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_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	39	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
call_followup_master		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
caste_category		Browse	Structure	Search	Insert	Empty	Drop	15	InnoDB	utf8_unicode_ci	16.0 KiB	-
cnc_jobs		Browse	Structure	Search	Insert	Empty	Drop	18	InnoDB	utf8mb4_general_ci	80.0 KiB	-
cnc_job_parts		Browse	Structure	Search	Insert	Empty	Drop	67	InnoDB	utf8mb4_general_ci	48.0 KiB	-
contra_vouchers		Browse	Structure	Search	Insert	Empty	Drop	0	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	45	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	35	InnoDB	utf8mb4_general_ci	64.0 KiB	-
crm_ticket_service		Browse	Structure	Search	Insert	Empty	Drop	10	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	5	InnoDB	utf8mb4_general_ci	16.0 KiB	-
daily_financial_summary		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.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	46	InnoDB	utf8_unicode_ci	96.0 KiB	-
dashboard_monthly_summary		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
dashboard_summary_snapshot		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
dashboard_yearly_summary		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
date_range_filters		Browse	Structure	Search	Insert	Empty	Drop	14	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
discount_categories		Browse	Structure	Search	Insert	Empty	Drop	17	InnoDB	utf8_unicode_ci	16.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	7	InnoDB	utf8mb4_unicode_ci	16.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_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	96.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	-
einvoices_eway_bill		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_unicode_ci	16.0 KiB	-
einvoice_eway_cancellation		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_unicode_ci	16.0 KiB	-
email_smtp_settings		Browse	Structure	Search	Insert	Empty	Drop	33	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
employees		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
exchange_items		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
exchange_items_value		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_unicode_ci	16.0 KiB	-
expense_voucher		Browse	Structure	Search	Insert	Empty	Drop	18	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
expense_voucher_allocations		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
expense_voucher_allocations_deleted		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
e_invoice_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_unicode_ci	16.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	0	InnoDB	utf8_unicode_ci	32.0 KiB	-
gst_authcode		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_unicode_ci	16.0 KiB	-
gst_registration_types		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
invoice_outstanding		Browse	Structure	Search	Insert	Empty	Drop	210	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
invoice_print_settings		Browse	Structure	Search	Insert	Empty	Drop	9	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,474	InnoDB	utf8mb4_unicode_ci	848.0 KiB	-
items_brands		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
items_category		Browse	Structure	Search	Insert	Empty	Drop	34	InnoDB	utf8mb4_unicode_ci	48.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	1	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,470	InnoDB	utf8mb4_unicode_ci	272.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,473	InnoDB	utf8mb4_unicode_ci	6.3 MiB	-
items_uom		Browse	Structure	Search	Insert	Empty	Drop	44	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	1,369	InnoDB	utf8mb4_unicode_ci	528.0 KiB	-
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	4	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
ledger_contact_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
ledger_details		Browse	Structure	Search	Insert	Empty	Drop	2,563	InnoDB	utf8mb4_unicode_ci	3.7 MiB	-
ledger_entries_cash		Browse	Structure	Search	Insert	Empty	Drop	124	InnoDB	utf8mb4_unicode_ci	144.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	2,540	InnoDB	utf8mb4_unicode_ci	320.0 KiB	-
ledger_party_shipping_details		Browse	Structure	Search	Insert	Empty	Drop	50	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
ledger_postings		Browse	Structure	Search	Insert	Empty	Drop	1,181	InnoDB	utf8mb4_unicode_ci	816.0 KiB	-
ledger_postings_audit		Browse	Structure	Search	Insert	Empty	Drop	~72,441	InnoDB	utf8mb4_general_ci	52.8 MiB	-
ledger_shipping_details		Browse	Structure	Search	Insert	Empty	Drop	270	InnoDB	utf8mb4_unicode_ci	144.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	-
monthly_financial_summary		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
parts		Browse	Structure	Search	Insert	Empty	Drop	11	InnoDB	utf8mb4_general_ci	64.0 KiB	-
party_comments		Browse	Structure	Search	Insert	Empty	Drop	2	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	101	InnoDB	utf8mb4_unicode_ci	80.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	16.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	6	InnoDB	utf8_unicode_ci	16.0 KiB	-
payment_vouchers		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
payment_voucher_allocations		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
plant_details		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
postings_audit_log		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
posting_audit_log		Browse	Structure	Search	Insert	Empty	Drop	498	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
posting_control		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
posting_period_control		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
pricing_recompute_queue		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
purchase_entries		Browse	Structure	Search	Insert	Empty	Drop	19	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
purchase_entries_old		Browse	Structure	Search	Insert	Empty	Drop	1,232	InnoDB	utf8mb4_unicode_ci	672.0 KiB	-
purchase_entry_items		Browse	Structure	Search	Insert	Empty	Drop	61	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
purchase_entry_items_old		Browse	Structure	Search	Insert	Empty	Drop	7,375	InnoDB	utf8mb4_unicode_ci	2.9 MiB	-
purchase_invoice_discounts		Browse	Structure	Search	Insert	Empty	Drop	9	InnoDB	utf8mb4_general_ci	32.0 KiB	-
purchase_orders		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	32.0 KiB	-
purchase_order_items		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	latin1_swedish_ci	32.0 KiB	-
purchase_received_details		Browse	Structure	Search	Insert	Empty	Drop	19	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
purchase_returns		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
purchase_return_items		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	208.0 KiB	-
purchase_return_items_old		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
purchase_return_old		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
quotation_entries		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
quotation_entry_items		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
receipt_sales_mapping		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
receipt_vouchers		Browse	Structure	Search	Insert	Empty	Drop	21	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
receipt_voucher_allocations		Browse	Structure	Search	Insert	Empty	Drop	17	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
report_data_entries		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_general_ci	64.0 KiB	-
sales_cancelled_entries		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8_unicode_ci	16.0 KiB	-
sales_entries		Browse	Structure	Search	Insert	Empty	Drop	250	InnoDB	utf8mb4_unicode_ci	160.0 KiB	-
sales_entry_items		Browse	Structure	Search	Insert	Empty	Drop	2,586	InnoDB	utf8mb4_unicode_ci	640.0 KiB	-
sales_invoice_discounts		Browse	Structure	Search	Insert	Empty	Drop	137	InnoDB	utf8mb4_general_ci	96.0 KiB	-
sales_invoice_exchange		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
sales_invoice_other_discounts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
sales_invoice_subsidy		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
sales_returns		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
sales_return_items		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_unicode_ci	208.0 KiB	-
sales_return_reasons		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
sales_settings		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
sales_targets		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
sample_table		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
setting_allowed_ips		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16.0 KiB	-
setting_branch_details		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
setting_countries		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	32.0 KiB	-
setting_district		Browse	Structure	Search	Insert	Empty	Drop	31	InnoDB	latin1_swedish_ci	32.0 KiB	-
setting_main_menu		Browse	Structure	Search	Insert	Empty	Drop	20	InnoDB	latin1_swedish_ci	16.0 KiB	-
setting_states		Browse	Structure	Search	Insert	Empty	Drop	37	InnoDB	latin1_swedish_ci	32.0 KiB	-
setting_sub_menu		Browse	Structure	Search	Insert	Empty	Drop	110	InnoDB	latin1_swedish_ci	48.0 KiB	-
subsidy_receipt_vouchers		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
subsidy_receipt_voucher_allocations		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
subsidy_schemes		Browse	Structure	Search	Insert	Empty	Drop	36	InnoDB	utf8mb4_general_ci	32.0 KiB	-
subsidy_scheme_application_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_unicode_ci	48.0 KiB	-
subsidy_scheme_documents		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
subsidy_scheme_general_caste_rule		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_unicode_ci	16.0 KiB	-
subsidy_scheme_items		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
subsidy_scheme_items_amount		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_unicode_ci	16.0 KiB	-
tally_posted_rows		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
tally_posting_issues		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
tally_source_batches		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
tally_source_raw10		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
tally_source_typed		Browse	Structure	Search	Insert	Empty	Drop	~158,445	InnoDB	utf8mb4_unicode_ci	68.8 MiB	-
tally_transactions		Browse	Structure	Search	Insert	Empty	Drop	14	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
tds_cumulative		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
tds_deductions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
tds_master		Browse	Structure	Search	Insert	Empty	Drop	9	InnoDB	utf8mb4_general_ci	16.0 KiB	-
telephony_calls		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	80.0 KiB	-
telephony_call_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
transaction_additional_charges		Browse	Structure	Search	Insert	Empty	Drop	27	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
transaction_expenditure_categories		Browse	Structure	Search	Insert	Empty	Drop	17	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
transaction_expenditure_vouchers		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_unicode_ci	96.0 KiB	-
transaction_payment_vouchers_expense		Browse	Structure	Search	Insert	Empty	Drop	16	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
transaction_receipt_vouchers_old		Browse	Structure	Search	Insert	Empty	Drop	18	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
universal_discount_rules		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_unicode_ci	112.0 KiB	-
users		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	64.0 KiB	-
user_branches		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	latin1_swedish_ci	16.0 KiB	-
user_details		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
user_favorites		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
user_financial_years		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	latin1_swedish_ci	64.0 KiB	-
user_permissions		Browse	Structure	Search	Insert	Empty	Drop	636	InnoDB	latin1_swedish_ci	112.0 KiB	-
user_roles		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	latin1_swedish_ci	48.0 KiB	-
voucher_additional_charges		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
voucher_numbering_config		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	16.0 KiB	-
voucher_series_master		Browse	Structure	Search	Insert	Empty	Drop	17	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
voucher_series_master_old		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
voucher_taxes		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
voucher_types		Browse	Structure	Search	Insert	Empty	Drop	36	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
voucher_types_old		Browse	Structure	Search	Insert	Empty	Drop	28	InnoDB	utf8mb4_general_ci	32.0 KiB	-
voucher_type_ledger_mappings		Browse	Structure	Search	Insert	Empty	Drop	40	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
whatsapp_settings		Browse	Structure	Search	Insert	Empty	Drop	38	InnoDB	utf8mb4_unicode_ci	16.0 KiB	-
yearly_financial_summary		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
206 tables	Sum							~282,759	InnoDB	utf8mb4_unicode_ci	149.4 MiB	0 B

Check all

Data dictionary