| id |
bigint(20)
|
|
|
|
| instance_name |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| remote_jid |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| display_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| profile_picture_url |
longtext
|
utf8mb4_unicode_ci
|
|
|
| is_group |
tinyint(1)
|
|
|
|
| last_message_text |
text
|
utf8mb4_unicode_ci
|
|
|
| first_message_text |
text
|
utf8mb4_unicode_ci
|
|
|
| last_message_at |
datetime
|
|
|
|
| source_identifiers |
longtext
|
utf8mb4_unicode_ci
|
|
|
| payload_json |
longtext
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| assigned_queue_id |
int(11)
|
|
|
|
| assigned_user_id |
int(11)
|
|
|
|
| assigned_by_flow |
tinyint(1)
|
|
|
|
| assignment_source |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| assignment_meta |
longtext
|
utf8mb4_unicode_ci
|
|
|
| assigned_at |
datetime
|
|
|
|
| last_flow_protocol_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| first_response_at |
datetime
|
|
|
|
| response_time_seconds |
int(11)
|
|
|
|
| sla_status |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| transfers_count |
int(11)
|
|
|
|
| transferred_from_user_id |
int(11)
|
|
|
|
| transferred_to_user_id |
int(11)
|
|
|
|
| kanban_status |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| kanban_updated_at |
datetime
|
|
|
|
| kanban_deal_value |
decimal(12,2)
|
|
|
|