| id |
int(11)
|
|
|
|
| application_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| applicant_user_id |
int(11)
|
|
|
|
| applicant_employee_id |
int(11)
|
|
|
|
| applicant_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| department_id |
int(11)
|
|
|
|
| department_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| period_start |
date
|
|
|
|
| period_end |
date
|
|
|
|
| apply_date |
date
|
|
|
|
| status |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| total_amount |
decimal(14,2)
|
|
|
|
| note |
text
|
utf8mb4_unicode_ci
|
|
|
| submitted_at |
datetime
|
|
|
|
| admin_review_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| admin_review_at |
datetime
|
|
|
|
| admin_review_note |
text
|
utf8mb4_unicode_ci
|
|
|
| gm_approve_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| gm_approve_at |
datetime
|
|
|
|
| gm_approve_note |
text
|
utf8mb4_unicode_ci
|
|
|
| paid_at |
datetime
|
|
|
|
| paid_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| created_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
