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
agreement_id int(11)
agreement_no varchar(50) utf8mb4_unicode_ci
booking_id int(11)
customer_id int(11)
vehicle_id int(11)
generated_by int(11)
confirmed_by int(11)
status enum('Draft', 'Confirmed', 'Cancelled') utf8mb4_unicode_ci
customer_name varchar(150) utf8mb4_unicode_ci
customer_ic varchar(50) utf8mb4_unicode_ci
customer_phone varchar(50) utf8mb4_unicode_ci
customer_email varchar(150) utf8mb4_unicode_ci
customer_address text utf8mb4_unicode_ci
license_no varchar(100) utf8mb4_unicode_ci
license_expiry date
additional_driver_name varchar(150) utf8mb4_unicode_ci
additional_driver_ic varchar(50) utf8mb4_unicode_ci
additional_driver_phone varchar(50) utf8mb4_unicode_ci
additional_driver_address text utf8mb4_unicode_ci
additional_driver_license_no varchar(100) utf8mb4_unicode_ci
additional_driver_license_expiry date
vehicle_plate varchar(50) utf8mb4_unicode_ci
vehicle_brand varchar(100) utf8mb4_unicode_ci
vehicle_model varchar(100) utf8mb4_unicode_ci
vehicle_color varchar(50) utf8mb4_unicode_ci
vehicle_year varchar(20) utf8mb4_unicode_ci
rental_start_datetime datetime
rental_end_datetime datetime
pickup_location varchar(255) utf8mb4_unicode_ci
return_location varchar(255) utf8mb4_unicode_ci
mileage_out int(11)
mileage_in int(11)
fuel_level_out varchar(50) utf8mb4_unicode_ci
fuel_level_in varchar(50) utf8mb4_unicode_ci
destination varchar(255) utf8mb4_unicode_ci
daily_rate decimal(10,2)
weekly_rate decimal(10,2)
monthly_rate decimal(10,2)
extra_hour_charge decimal(10,2)
delivery_fee decimal(10,2)
collection_fee decimal(10,2)
service_tax decimal(10,2)
insurance_fee decimal(10,2)
miscellaneous_fee decimal(10,2)
total_amount decimal(10,2)
deposit_amount decimal(10,2)
amount_paid decimal(10,2)
balance_amount decimal(10,2)
payment_method varchar(100) utf8mb4_unicode_ci
accessories_json text utf8mb4_unicode_ci
inspection_checklist_json text utf8mb4_unicode_ci
general_remarks text utf8mb4_unicode_ci
customer_remarks text utf8mb4_unicode_ci
staff_remarks text utf8mb4_unicode_ci
customer_signature_name varchar(150) utf8mb4_unicode_ci
staff_signature_name varchar(150) utf8mb4_unicode_ci
confirmed_at datetime
cancelled_at datetime
created_at datetime
updated_at datetime