|
id
|
int(11)
|
|
|
|
|
employee_id
|
int(11)
|
|
|
|
|
leave_type
|
varchar(50)
|
|
|
|
|
start_date
|
date
|
|
|
|
|
start_time
|
time
|
|
|
|
|
end_date
|
date
|
|
|
|
|
end_time
|
time
|
|
|
|
|
days
|
decimal(5,1)
|
|
|
0.0
|
|
reason
|
text
|
|
|
|
|
status
|
varchar(30)
|
|
|
pending
|
|
approved_by
|
int(11)
|
|
|
|
|
approved_at
|
datetime
|
|
|
|
|
rejected_reason
|
text
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
leave_type_id
|
int(11)
|
|
|
|
|
hours
|
decimal(6,2)
|
|
|
0.00
|