| id |
bigint(20)
|
|
|
|
| request_uuid |
char(36)
|
ascii_bin
|
|
|
| employee_id |
int(10)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| leave_type_id |
int(10)
|
|
|
Browse foreign values
|
| date_from |
date
|
|
|
|
| date_to |
date
|
|
|
|
| total_requested_days |
decimal(6,2)
|
|
|
|
| request_reason |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| request_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)
|
|
|
|
| review_comment |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| reviewed_at_utc |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|