|
id
|
|
|
ref_number
|
|
|
type
|
|
|
direction
|
|
|
subject
|
|
|
category_id
|
|
|
priority
|
|
|
status
|
|
|
sender_name
|
|
|
sender_entity
|
|
|
sender_ref
|
|
|
sender_date
|
|
|
receiver_name
|
|
|
receiver_entity
|
|
|
department_id
|
|
|
employee_id
|
|
|
assigned_to
|
|
|
correspondence_date
|
|
|
received_date
|
|
|
due_date
|
|
|
reply_date
|
|
|
summary
|
|
|
notes
|
|
|
tags
|
|
|
replied_by
|
|
|
reply_ref
|
|
|
parent_id
|
|
|
created_by
|
|
|
created_at
|
|
|
updated_at
|
|
