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 bigint(20)
user_id bigint(20)
type enum('WORK', 'LEAVE', 'WORK_OVERTIME') utf8mb4_unicode_ci
check_in_time datetime
check_out_time datetime
check_in_lat decimal(10,8)
check_in_lng decimal(11,8)
check_out_lat decimal(10,8)
check_out_lng decimal(11,8)
ot_start_time datetime
ot_end_time datetime
ot_status enum('PENDING', 'APPROVED', 'REJECTED') utf8mb4_unicode_ci
ot_approved_by bigint(20)
ot_approved_at timestamp
ot_remarks text utf8mb4_unicode_ci
remarks text utf8mb4_unicode_ci
total_hours decimal(8,2)
ot_hours decimal(8,2)
status enum('PENDING', 'APPROVED', 'REJECTED', 'COMPLETED') utf8mb4_unicode_ci
created_at timestamp
updated_at timestamp
over_time_status enum('PENDING', 'APPROVED', 'REJECTED') utf8mb4_unicode_ci
over_time_approver_id bigint(20)
over_time_approved_at datetime
start_over_time datetime
end_over_time datetime
leave_type enum('SICK_LEAVE', 'PERSONAL_LEAVE', 'ANNUAL_LEAVE', 'MATERNITY_LEAVE', 'PATERNITY_LEAVE', 'BEREAVEMENT_LEAVE', 'EMERGENCY_LEAVE', 'STUDY_LEAVE', 'COMPENSATORY_LEAVE', 'UNPAID_LEAVE', 'NATIONAL_HOLIDAY_LEAVE') utf8mb4_unicode_ci
leave_start_date date
leave_end_date date
leave_reason text utf8mb4_unicode_ci
leave_approver_id bigint(20)
leave_status enum('PENDING', 'APPROVED', 'REJECTED') utf8mb4_unicode_ci
leave_approved_at timestamp
leave_rejection_reason text utf8mb4_unicode_ci
metadata longtext utf8mb4_bin
image_attachments longtext utf8mb4_bin