| id |
bigint(20)
|
|
|
|
| correction_uuid |
char(36)
|
ascii_bin
|
|
|
| attendance_day_id |
bigint(20)
|
|
|
|
| employee_id |
int(10)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| attendance_date |
date
|
|
|
|
| request_type |
varchar(40)
|
ascii_bin
|
|
|
| reason_code |
varchar(40)
|
ascii_bin
|
|
|
| reason_text |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| requested_check_in_local_time |
datetime
|
|
|
|
| requested_check_out_local_time |
datetime
|
|
|
|
| clear_check_out |
tinyint(1)
|
|
|
|
| daily_updated_at_snapshot |
datetime
|
|
|
|
| before_snapshot_json |
longtext
|
utf8mb4_unicode_ci
|
|
|
| after_snapshot_json |
longtext
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('SUBMITTED', 'APPROVED', 'REJECTED', 'CANCELLED')
|
utf8mb4_unicode_ci
|
|
|
| requested_by_user_id |
smallint(5)
|
|
|
|
| requested_at_utc |
datetime
|
|
|
|
| reviewed_by_user_id |
smallint(5)
|
|
|
|
| reviewed_at_utc |
datetime
|
|
|
|
| review_comment |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| self_approval |
tinyint(1)
|
|
|
|
| applied_at_utc |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|