| id |
int(10)
|
|
|
|
| document_code |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| title |
varchar(220)
|
utf8mb4_general_ci
|
|
|
| company |
enum('Top1Movers', 'Bambs Trucking Corp.', 'Shared / Both')
|
utf8mb4_general_ci
|
|
|
| department_id |
int(10)
|
|
|
|
| document_type_id |
int(10)
|
|
|
|
| other_document_type |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| category |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| uploaded_by |
int(11)
|
|
|
|
| current_approver_id |
int(11)
|
|
|
|
| additional_reviewer_id |
int(11)
|
|
|
|
| priority |
enum('Normal', 'Urgent', 'Critical')
|
utf8mb4_general_ci
|
|
|
| due_date |
date
|
|
|
|
| original_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| stored_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| file_path |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| file_size |
bigint(20)
|
|
|
|
| mime_type |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| is_confidential |
tinyint(1)
|
|
|
|
| status |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| remarks |
text
|
utf8mb4_general_ci
|
|
|
| submitted_at |
datetime
|
|
|
|
| approved_at |
datetime
|
|
|
|
| returned_at |
datetime
|
|
|
|
| rejected_at |
datetime
|
|
|
|
| archived_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| source_module |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| source_record_id |
int(11)
|
|
|
|
| source_reference_no |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| client_name |
varchar(180)
|
utf8mb4_general_ci
|
|
|
| auto_generated |
tinyint(1)
|
|
|
|