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)
reference_no varchar(30) utf8mb4_unicode_ci
employee_id int(10)
department_id int(10)
employee_name varchar(200) utf8mb4_unicode_ci
overtime_date date
day_type enum('regular', 'rest_day', 'special_holiday', 'regular_holiday') utf8mb4_unicode_ci
scheduled_start time
scheduled_end time
time_in datetime
time_out datetime
break_minutes int(11)
elapsed_minutes int(11)
worked_minutes int(11)
ot_minutes int(11)
rule_id int(10)
calc_notes varchar(500) utf8mb4_unicode_ci
needs_review tinyint(1)
review_reason varchar(500) utf8mb4_unicode_ci
reason varchar(500) utf8mb4_unicode_ci
remarks varchar(500) utf8mb4_unicode_ci
status enum('draft', 'pending', 'approved', 'rejected', 'cancelled') utf8mb4_unicode_ci
source enum('manual', 'bulk') utf8mb4_unicode_ci
batch_id int(10) Browse foreign values Browse foreign values
encoded_by int(10)
encoded_at datetime
decided_by int(10)
decided_at datetime
decision_remarks varchar(500) utf8mb4_unicode_ci
updated_by int(10)
updated_at datetime
deleted_at datetime
deleted_by int(10)
Display order: