| id |
int(10)
|
|
|
|
| company_id |
int(10)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| employee_id |
int(10)
|
|
|
|
| template_id |
int(10)
|
|
|
|
| letter_type |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| letter_no |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| letter_subject |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| letter_body |
longtext
|
utf8mb4_unicode_ci
|
|
|
| request_status |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| approval_status |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| approved_by |
int(10)
|
|
|
|
| approved_at |
datetime
|
|
|
|
| rejected_by |
int(10)
|
|
|
|
| rejected_at |
datetime
|
|
|
|
| rejection_reason |
text
|
utf8mb4_unicode_ci
|
|
|
| generated_file_path |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| issued_date |
date
|
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(10)
|
|
|
|
| updated_by |
int(10)
|
|
|
|
| deleted_by |
int(10)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| deleted_at |
datetime
|
|
|
|