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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
allocation_no varchar(40) utf8mb4_general_ci
order_id int(11)
truck_id int(11)
scheduled_date date
route_sequence int(11)
payment_mode varchar(40) utf8mb4_general_ci
cash_to_collect decimal(12,2)
pickup_location varchar(255) utf8mb4_general_ci
dropoff_location varchar(255) utf8mb4_general_ci
trip_type varchar(20) utf8mb4_general_ci
route_profile varchar(30) utf8mb4_general_ci
estimated_one_way_distance_km decimal(10,2)
estimated_total_distance_km decimal(10,2)
estimated_cargo_weight_kg decimal(12,2)
load_utilization_percent decimal(10,2)
truck_km_per_liter decimal(10,2)
recommended_km_per_liter decimal(10,2)
diesel_price_per_liter decimal(10,2)
cost_per_km decimal(10,2)
estimated_fuel_liters decimal(10,2)
estimated_fuel_cost decimal(12,2)
actual_start_odometer decimal(12,2)
actual_end_odometer decimal(12,2)
actual_distance_km decimal(10,2)
actual_fuel_liters decimal(10,2)
actual_km_per_liter decimal(10,2)
actual_fuel_cost decimal(12,2)
fuel_variance decimal(12,2)
distance_variance decimal(10,2)
status tinyint(1)
notes text utf8mb4_general_ci
cancel_reason varchar(255) utf8mb4_general_ci
canceled_at datetime
canceled_by int(11)
proof_path varchar(255) utf8mb4_general_ci
user_id int(11)
created_at datetime