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(11)
create_time datetime(6)
create_user varchar(150) utf8mb4_general_ci
change_time datetime(6)
change_user varchar(150) utf8mb4_general_ci
status smallint(6)
use_ot smallint(6)
weekend1 smallint(6)
weekend2 smallint(6)
start_of_week smallint(6)
max_hrs decimal(4,1)
day_change time(6)
paring_rule smallint(6)
punch_period smallint(6)
daily_ot tinyint(1)
daily_ot_rule char(32) utf8mb4_general_ci
weekly_ot tinyint(1)
weekly_ot_rule char(32) utf8mb4_general_ci
weekend_ot tinyint(1)
weekend_ot_rule char(32) utf8mb4_general_ci
holiday_ot tinyint(1)
holiday_ot_rule char(32) utf8mb4_general_ci
late_in2absence int(11)
early_out2absence int(11)
miss_in smallint(6)
late_in_hrs int(11)
miss_out smallint(6)
early_out_hrs int(11)
require_capture tinyint(1)
require_work_code tinyint(1)
require_punch_state tinyint(1)
email_send_time time(6)
global_frequency smallint(6)
global_send_day smallint(6)
max_absent smallint(6)
max_early_out smallint(6)
max_late_in smallint(6)
sending_day smallint(6)
weekend1_color_setting varchar(30) utf8mb4_general_ci
weekend2_color_setting varchar(30) utf8mb4_general_ci
ot_pay_code_id int(11)
overtime_policy smallint(6)
enable_compensatory tinyint(1)
bot_uid varchar(100) utf8mb4_general_ci
enable_workcode_calculation tinyint(1)
enable_workcode_punch_state smallint(6)