| id |
int(11)
|
|
|
|
| application_id |
int(11)
|
|
|
|
| leave_type |
enum('exit_permit', 'daily_leave', 'weekend_leave', 'emergency_leave', 'vacation')
|
utf8mb4_unicode_ci
|
|
|
| leave_date |
date
|
|
|
|
| return_date |
date
|
|
|
|
| leave_time |
time
|
|
|
|
| return_time |
time
|
|
|
|
| destination |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| purpose |
text
|
utf8mb4_unicode_ci
|
|
|
| guardian_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| guardian_phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| guardian_relation |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('pending', 'approved', 'rejected', 'returned')
|
utf8mb4_unicode_ci
|
|
|
| approved_by |
int(11)
|
|
|
|
| approved_at |
timestamp
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
