|
id
|
int(11)
|
|
|
|
|
company_id
|
int(11)
|
|
|
0
|
|
branch_id
|
int(11)
|
|
|
0
|
|
student_id
|
int(11)
|
|
|
0
|
|
admission_no
|
varchar(50)
|
|
|
|
|
tc_no
|
varchar(80)
|
|
|
|
|
request_date
|
date
|
|
|
|
|
leaving_date
|
date
|
|
|
|
|
leaving_reason
|
enum
|
-- |
|
Other
|
|
reason_details
|
text
|
|
|
|
|
fee_clearance
|
enum
|
-- |
|
Pending
|
|
library_clearance
|
enum
|
-- |
|
Pending
|
|
transport_clearance
|
enum
|
-- |
|
Pending
|
|
document_clearance
|
enum
|
-- |
|
Pending
|
|
fee_due_amount
|
decimal(12,2)
|
|
|
0.00
|
|
library_due_amount
|
decimal(12,2)
|
|
|
0.00
|
|
transport_due_amount
|
decimal(12,2)
|
|
|
0.00
|
|
clearance_status
|
enum
|
-- |
|
Pending
|
|
approval_status
|
enum
|
-- |
|
Draft
|
|
approved_by
|
varchar(150)
|
|
|
|
|
approved_date
|
date
|
|
|
|
|
issued_date
|
date
|
|
|
|
|
print_status
|
enum
|
-- |
|
Not Printed
|
|
student_final_status
|
enum
|
-- |
|
Active
|
|
qr_code
|
varchar(150)
|
|
|
|
|
qr_verify_url
|
varchar(255)
|
|
|
|
|
office_remarks
|
text
|
|
|
|
|
created_by
|
int(11)
|
|
|
0
|
|
updated_by
|
int(11)
|
|
|
0
|
|
delete_status
|
tinyint(1)
|
|
|
0
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|