| id |
int(11)
|
|
|
|
| ref_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| type |
enum('incoming', 'outgoing')
|
utf8mb4_unicode_ci
|
|
|
| direction |
enum('internal', 'external')
|
utf8mb4_unicode_ci
|
|
|
| subject |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| category_id |
int(11)
|
|
|
|
| priority |
enum('normal', 'urgent', 'confidential', 'top_secret')
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('new', 'in_progress', 'replied', 'archived', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| sender_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| sender_entity |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| sender_ref |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| sender_date |
date
|
|
|
|
| receiver_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| receiver_entity |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| department_id |
int(11)
|
|
|
|
| employee_id |
int(11)
|
|
|
|
| assigned_to |
int(11)
|
|
|
|
| correspondence_date |
date
|
|
|
|
| received_date |
date
|
|
|
|
| due_date |
date
|
|
|
|
| reply_date |
date
|
|
|
|
| summary |
text
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| tags |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| replied_by |
int(11)
|
|
|
|
| reply_ref |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| parent_id |
int(11)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
