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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(10)
item_name varchar(255) utf8mb4_unicode_ci
alias_name varchar(255) utf8mb4_unicode_ci
item_code varchar(50) utf8mb4_unicode_ci
packing varchar(50) utf8mb4_unicode_ci
hsn_sac_id bigint(20)
ledger_id bigint(20)
item_cat_id int(10)
godown_id int(10)
uom_id int(10)
brand_id int(10)
company_id int(10)
item_type enum('GOODS', 'SERVICE') utf8mb4_unicode_ci
valuation_method enum('FIFO', 'WAC', 'STANDARD') utf8mb4_unicode_ci
standard_cost decimal(10,2)
price_basis enum('MRP', 'BASE') utf8mb4_unicode_ci
mrp decimal(10,2)
profit_logic varchar(100) utf8mb4_unicode_ci
price_type varchar(100) utf8mb4_unicode_ci
profit_value decimal(10,2)
price decimal(10,2)
average_price decimal(10,2)
last_purchase_price decimal(10,2)
purchase_price decimal(10,2)
sale_price_delete decimal(10,2)
tax_rate decimal(10,2)
stock_quantity int(10)
opening_value int(11)
max_qty int(10)
min_qty int(10)
reorder_days int(10)
low_stock_alert tinyint(1)
is_subsidy_item enum('Y', 'N') utf8mb4_unicode_ci
is_edit_mrp enum('Y', 'N') utf8mb4_unicode_ci
branch_id int(10)
item_name_key varchar(255) utf8mb4_unicode_ci
name_norm varchar(255) utf8mb4_unicode_ci
aliases_norm varchar(512) utf8mb4_unicode_ci
delete_status tinyint(1)
created_at datetime
updated_at datetime