| 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)
|
|
|
|
| department_id |
int(11)
|
|
|
|
| dept_frequency |
smallint(6)
|
|
|
|
| dept_send_day |
smallint(6)
|
|
|
|
| email_send_time |
time(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)
|
|
|
|
