| id | int(11) |
|
|
|
| leave_request_no | varchar(255) |
|
|
|
| empid | int(11) |
|
|
|
| period_from | date |
|
|
|
| period_to | date |
|
|
|
| total_days | float(10,2) |
|
|
|
| approved_date_from | date |
|
|
|
| approved_date_to | date |
|
|
|
| total_approval_days | double(10,2) |
|
|
|
| between_date | varchar(255) |
|
|
|
| leave_reason | text |
|
|
|
| leave_type | varchar(40) |
|
|
|
| approve_status | enum | -- |
|
N
|
| half_day | enum | -- |
|
0
|
| from_half_day | int(1) |
|
|
0
|
| to_half_day | int(1) |
|
|
0
|
