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(10)
ref_no varchar(20) utf8mb4_unicode_ci
employee_id int(10) Browse foreign values Browse foreign values
ot_date date
time_in time
time_out time
start_dt datetime
end_dt datetime
break_minutes int(11)
total_hours decimal(6,2)
premium_hours decimal(6,2)
excess_hours decimal(6,2)
nd_hours decimal(6,2)
day_type varchar(10) utf8mb4_unicode_ci
rd_override tinyint(1)
hourly_rate decimal(10,4)
base_rate decimal(6,4)
ot_rate decimal(6,4)
nd_rate decimal(6,4)
amount decimal(12,2)
project varchar(120) utf8mb4_unicode_ci
reason text utf8mb4_unicode_ci
remarks text utf8mb4_unicode_ci
attachment_path varchar(255) utf8mb4_unicode_ci
attachment_name varchar(255) utf8mb4_unicode_ci
status enum('draft', 'submitted', 'approved', 'verified', 'rejected', 'returned', 'cancelled') utf8mb4_unicode_ci
last_reason text utf8mb4_unicode_ci
flagged tinyint(1)
flag_note text utf8mb4_unicode_ci
flagged_by int(10)
flagged_at datetime
cutoff_id int(10)
encoded_by int(10)
approved_by int(10)
approved_at datetime
verified_by int(10)
verified_at datetime
created_at datetime
updated_at datetime
deleted_at datetime
Display order: