Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Settings for the table structure (list of columns).
Table structure
Documentation Whether the table structure actions should be hidden. Restore default value
Documentation Whether column comments should be shown in table structure view Restore default value
Default transformations
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value

ledger_details

# Name Type Collation Attributes Null Default Comments Extra Action
1 bigint(20) UNSIGNED No None AUTO_INCREMENT Change Change Drop Drop
2 varchar(250) utf8mb4_unicode_ci No None Change Change Drop Drop
3 varchar(250) utf8mb4_unicode_ci No None Change Change Drop Drop
4 int(11) Yes NULL Change Change Drop Drop
5 enum('NA', 'NO', 'YES') utf8mb4_unicode_ci Yes NA Change Change Drop Drop
6 enum('NA', 'NO', 'YES') utf8mb4_unicode_ci Yes NA Change Change Drop Drop
7 bigint(20) Yes NULL Change Change Drop Drop
8 varchar(250) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
9 varchar(100) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
10 varchar(255) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
11 text utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
12 varchar(50) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
13 char(6) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
14 smallint(5) UNSIGNED Yes NULL Change Change Drop Drop
15 int(11) No None Change Change Drop Drop
16 smallint(5) UNSIGNED Yes NULL Change Change Drop Drop
17 tinyint(4) No 1 party_type Change Change Drop Drop
18 varchar(50) utf8mb4_unicode_ci No None Change Change Drop Drop
19 varchar(10) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
20 enum('NA', 'NO', 'YES') utf8mb4_unicode_ci No NA Change Change Drop Drop
21 int(11) Yes NULL Change Change Drop Drop
22 varchar(50) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
23 varchar(20) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
24 varchar(15) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
25 varchar(15) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
26 varchar(15) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
27 varchar(191) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
28 varchar(191) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
29 varchar(255) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
30 int(11) No None Change Change Drop Drop
31 int(10) UNSIGNED Yes NULL customer_segment Change Change Drop Drop
32 bigint(20) UNSIGNED Yes NULL Change Change Drop Drop
33 int(11) No None 1 - Customer, 2 - Supplier Change Change Drop Drop
34 bigint(20) UNSIGNED Yes NULL ledger_groups Change Change Drop Drop
35 int(10) UNSIGNED Yes NULL Change Change Drop Drop
36 decimal(18,0) Yes 0 Change Change Drop Drop
37 tinyint(1) No 0 Change Change Drop Drop
38 enum('NA', 'PLANT', 'GODOWN') utf8mb4_unicode_ci No NA Change Change Drop Drop
39 int(11) Yes NULL Change Change Drop Drop
40 int(10) UNSIGNED No 0 Change Change Drop Drop
41 tinyint(1) No 0 Change Change Drop Drop
42 varchar(50) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
43 int(10) UNSIGNED Yes NULL Change Change Drop Drop
44 int(10) UNSIGNED Yes NULL Change Change Drop Drop
45 varchar(10) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
46 enum('SYSTEM', 'BANK', 'TAX', 'CHARGES', 'DEBTOR',... utf8mb4_unicode_ci No None Change Change Drop Drop
47 enum('NA', 'REQUEST', 'CONFIRM') utf8mb4_unicode_ci Yes NA Change Change Drop Drop
48 enum('FREIGHT', 'DISCOUNT', 'PACKING', 'ROUND_OFF'... utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
49 enum('Y', 'N') utf8mb4_unicode_ci Yes N Change Change Drop Drop
50 varchar(200) utf8mb4_unicode_ci No None Change Change Drop Drop
51 enum('Y', 'N') utf8mb4_unicode_ci No N Change Change Drop Drop
52 enum('Y', 'N') utf8mb4_unicode_ci No N Change Change Drop Drop
53 int(11) No None Change Change Drop Drop
54 int(11) No 0 Change Change Drop Drop
55 int(11) No 0 Change Change Drop Drop
56 datetime No current_timestamp() Change Change Drop Drop
57 datetime Yes NULL ON UPDATE CURRENT_TIMESTAMP() Change Change Drop Drop
With selected: With selected:
Add column  Add column(s)  
Indexes Documentation
Action Keyname Type Unique Packed Column Cardinality Collation Null Comment
Edit Edit Rename Rename Drop Drop PRIMARY BTREE Yes No id 0 A No
Edit Edit Rename Rename Drop Drop uk_ledger_name_whatsapp BTREE Yes No ledger_name 0 A No
whatsapp_number 0 A Yes
branch_id 0 A No
trade_name 0 A Yes
Edit Edit Rename Rename Drop Drop idx_branch_id BTREE No No branch_id 0 A No
Edit Edit Rename Rename Drop Drop idx_company_contact_number BTREE No No company_contact_number 0 A Yes
Edit Edit Rename Rename Drop Drop idx_whatsapp_number BTREE No No whatsapp_number 0 A Yes
Edit Edit Rename Rename Drop Drop idx_email_id BTREE No No email_id 0 A Yes
Edit Edit Rename Rename Drop Drop idx_registration_type BTREE No No gst_registration_types_id 0 A Yes
Edit Edit Rename Rename Drop Drop idx_ledger_name BTREE No No ledger_name 0 A No
Edit Edit Rename Rename Drop Drop idx_ledger_group BTREE No No led_group_id 0 A Yes
parent_group_id 0 A Yes
Edit Edit Rename Rename Drop Drop idx_ledger_parent_group BTREE No No parent_group_id 0 A Yes
delete_status 0 A No
Edit Edit Rename Rename Drop Drop idx_led_group_id BTREE No No led_group_id 0 A Yes
Edit Edit Rename Rename Drop Drop idx_branch_active_subgroup_name BTREE No No branch_id 0 A No
delete_status 0 A No
ledger_name 0 A No
Edit Edit Rename Rename Drop Drop idx_branch_parent_group BTREE No No branch_id 0 A No
parent_group_id 0 A Yes
delete_status 0 A No
ledger_name 0 A No
Edit Edit Rename Rename Drop Drop idx_branch_led_group BTREE No No branch_id 0 A No
led_group_id 0 A Yes
delete_status 0 A No
ledger_name 0 A No
Edit Edit Rename Rename Drop Drop idx_led_group_active BTREE No No led_group_id 0 A Yes
delete_status 0 A No
id 0 A No
Edit Edit Rename Rename Drop Drop idx_ledger_type BTREE No No ledger_type 0 A No
Edit Edit Rename Rename Drop Drop idx_charge_kind BTREE No No charge_kind 0 A Yes
Edit Edit Rename Rename Drop Drop idx_branch_tax BTREE No No branch_id 0 A No
delete_status 0 A No
ledger_type 0 A No
Edit Edit Rename Rename Drop Drop idx_branch_fy_group BTREE No No branch_id 0 A No
finance_year_id 0 A No
led_group_id 0 A Yes
delete_status 0 A No
Edit Edit Rename Rename Drop Drop idx_ledger_rpt_1 BTREE No No branch_id 0 A No
finance_year_id 0 A No
led_group_id 0 A Yes
delete_status 0 A No
Create an index on columns
Partitions Documentation
Information
Space usage
Data 16.0 KiB
Index 304.0 KiB
Overhead 0 B
Effective 320.0 KiB
Total 320.0 KiB
Optimize table Optimize table
Row statistics
Format dynamic
Collation utf8mb4_unicode_ci
Next autoindex 1
Creation Sep 19, 2026 at 09:30 AM
Last update Sep 29, 2026 at 01:09 PM
Last check Sep 29, 2026 at 01:09 PM