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
booking_id int(11)
receipt_no varchar(50) utf8mb4_unicode_ci
customer_id int(11)
vehicle_id int(11)
rental_type enum('walk_in_baru', 'walk_in_extension', 'walk_in_extra_cas', 'invois', 'agen') utf8mb4_unicode_ci
start_date date
time_out time
expected_end_date date
expected_end_time time
duration_unit enum('day', 'hour') utf8mb4_unicode_ci
with_driver tinyint(1)
driver_cost decimal(10,2)
rental_duration decimal(10,2)
actual_return_date date
actual_return_time time
rental_days int(11)
daily_rate decimal(10,2)
hourly_rate decimal(10,2)
insurance decimal(10,2)
discount_amount decimal(10,2)
extra_charges decimal(10,2)
early_return_discount decimal(10,2)
rental_refund_amount decimal(10,2)
rental_refund_status enum('none', 'pending', 'refunded') utf8mb4_unicode_ci
rental_refund_date date
rental_refund_proof varchar(255) utf8mb4_unicode_ci
extra_charges_reason text utf8mb4_unicode_ci
damage_charge decimal(10,2)
damage_notes text utf8mb4_unicode_ci
deposit decimal(10,2)
deposit_type enum('credit_card', 'bank_transfer', 'cash') utf8mb4_unicode_ci
deposit_ref varchar(100) utf8mb4_unicode_ci
deposit_proof varchar(255) utf8mb4_unicode_ci
deposit_status enum('received', 'not_received', 'refunded') utf8mb4_unicode_ci
deposit_refund_amount decimal(10,2)
deposit_refund_date date
deposit_refund_proof varchar(255) utf8mb4_unicode_ci
rental_payment_type enum('credit_card', 'bank_transfer', 'cash') utf8mb4_unicode_ci
rental_payment_ref varchar(100) utf8mb4_unicode_ci
rental_payment_proof varchar(255) utf8mb4_unicode_ci
payment_status enum('paid', 'unpaid', 'partial') utf8mb4_unicode_ci
amount_paid decimal(10,2)
balance_due decimal(10,2)
date_paid date
booking_status enum('active', 'completed', 'cancelled', 'extended', 'extend', 'pending', 'rejected') utf8mb4_unicode_ci
team varchar(50) utf8mb4_unicode_ci
remarks text utf8mb4_unicode_ci
cancellation_reason text utf8mb4_unicode_ci
rejection_reason text utf8mb4_unicode_ci
created_by int(11)
created_at datetime
updated_at datetime
pickup_mileage int(11)
pickup_mileage_image varchar(255) utf8mb4_unicode_ci
return_mileage int(11)
return_mileage_image varchar(255) utf8mb4_unicode_ci
sst_type varchar(10) utf8mb4_unicode_ci