| id |
int(10)
|
|
|
|
| company_id |
int(10)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| employee_id |
int(10)
|
|
|
|
| document_type |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| document_title |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| document_no |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| issue_date |
date
|
|
|
|
| expiry_date |
date
|
|
|
|
| file_path |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| file_name |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| file_type |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| file_size |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| verification_status |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| verified_by |
int(10)
|
|
|
|
| verified_at |
datetime
|
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| is_mandatory |
tinyint(1)
|
|
|
|
| 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
|
|
|
|