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)
snapshot_id bigint(20) Browse foreign values Browse foreign values
employee_id int(10)
employee_code varchar(50) utf8mb4_unicode_ci
attendance_date date
attendance_day_id bigint(20)
finance_year_id smallint(5)
day_classification varchar(40) ascii_bin
attendance_resolution_status varchar(40) ascii_bin
attendance_finalized tinyint(1)
check_in_local_time datetime
check_out_local_time datetime
duration_minutes decimal(10,2)
source_mode varchar(30) ascii_bin
shift_type_id int(10)
shift_code varchar(30) utf8mb4_unicode_ci
shift_name varchar(100) utf8mb4_unicode_ci
shift_start_time time
shift_end_time time
shift_required_minutes smallint(5)
shift_grace_in_minutes smallint(5)
shift_grace_out_minutes smallint(5)
approved_leave_fraction decimal(3,2)
leave_day_portion varchar(20) ascii_bin
approved_overtime_minutes int(10)
evidence_count int(10)
evidence_hash char(64) ascii_bin
flags_json longtext utf8mb4_unicode_ci
source_snapshot_json longtext utf8mb4_unicode_ci
row_hash char(64) ascii_bin
created_at datetime