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(11)
breakdown_id int(11) Browse foreign values Browse foreign values
material_id int(11) Browse foreign values Browse foreign values
material_code varchar(100) utf8mb4_unicode_ci
material_name varchar(255) utf8mb4_unicode_ci
brand varchar(100) utf8mb4_unicode_ci
order_date date
required_qty decimal(10,2)
required_unit varchar(50) utf8mb4_unicode_ci
stock_qty decimal(10,2)
stock_unit varchar(50) utf8mb4_unicode_ci
order_qty decimal(10,2)
approved_qty decimal(10,2)
actual_qty decimal(10,2)
received_qty decimal(10,2)
received_date datetime
received_by varchar(100) utf8mb4_unicode_ci
item_remarks text utf8mb4_unicode_ci
is_paid tinyint(1)
is_checked tinyint(1)
checked_by varchar(100) utf8mb4_unicode_ci
checked_at datetime
paid_by varchar(100) utf8mb4_unicode_ci
paid_at datetime
created_at timestamp
updated_at timestamp
sort_order int(11)