|
id
|
int(10) unsigned
|
|
|
|
|
department_id
|
int(10) unsigned
|
|
|
|
|
name
|
varchar(120)
|
|
|
|
|
schedule_start
|
time
|
|
|
08:00:00.000000
|
|
schedule_end
|
time
|
|
|
17:00:00.000000
|
|
regular_minutes
|
int(11)
|
|
|
480
|
|
ot_basis
|
enum
|
-- |
|
outside_schedule
|
|
min_ot_minutes
|
int(11)
|
|
|
30
|
|
rounding_mode
|
enum
|
-- |
|
down
|
|
rounding_increment
|
int(11)
|
|
|
15
|
|
default_break_minutes
|
int(11)
|
|
|
0
|
|
max_ot_minutes_per_day
|
int(11)
|
|
|
0
|
|
max_session_minutes
|
int(11)
|
|
|
960
|
|
allow_overnight
|
tinyint(1)
|
|
|
1
|
|
restday_holiday_all_ot
|
tinyint(1)
|
|
|
1
|
|
rest_days
|
varchar(20)
|
|
|
0
|
|
is_active
|
tinyint(1)
|
|
|
1
|
|
updated_by
|
int(10) unsigned
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
|