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
payroll_id int(10)
driver_id int(10)
vehicle_id int(10)
car_code varchar(30) utf8mb4_unicode_ci
plate_number varchar(20) utf8mb4_unicode_ci
vehicle_type varchar(30) utf8mb4_unicode_ci
car_owner varchar(255) utf8mb4_unicode_ci
cutoff_start date
cutoff_end date
payroll_date date
status enum('draft', 'for_review', 'approved', 'paid', 'cancelled') utf8mb4_unicode_ci
earnings_json longtext utf8mb4_unicode_ci
deductions_json longtext utf8mb4_unicode_ci
car_rate_snapshot longtext utf8mb4_unicode_ci
total_earnings decimal(12,2)
total_deductions decimal(12,2)
total_receivable decimal(12,2)
payroll_remarks varchar(500) utf8mb4_unicode_ci
payment_method varchar(20) utf8mb4_unicode_ci
amount_paid decimal(12,2)
date_paid date
reference_number varchar(100) utf8mb4_unicode_ci
submitted_by int(10)
approved_by int(10)
approved_at datetime
created_by int(10)
created_at timestamp
updated_at timestamp