| id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| guest_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| guest_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| user_language |
varchar(8)
|
utf8mb4_unicode_ci
|
|
|
| session_id |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| ip_address |
varchar(45)
|
utf8mb4_unicode_ci
|
|
|
| anon_uuid |
varchar(36)
|
utf8mb4_unicode_ci
|
|
|
| telegram_message_id |
bigint(20)
|
|
|
|
| telegram_message_thread_id |
bigint(20)
|
|
|
|
| telegram_last_typing_at |
datetime
|
|
|
|
| status |
enum('waiting', 'active', 'closed')
|
utf8mb4_unicode_ci
|
|
|
| opened_via |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| conversion_status |
enum('pending', 'converted', 'no_conversion')
|
utf8mb4_unicode_ci
|
|
|
| conversion_order_id |
int(11)
|
|
|
|
| conversion_value |
decimal(10,2)
|
|
|
|
| converted_at |
datetime
|
|
|
|
| admin_id |
int(11)
|
|
|
|
| typing_text |
text
|
utf8mb4_unicode_ci
|
|
|
| typing_at |
datetime
|
|
|
|
| last_message_at |
datetime
|
|
|
|
| unread_admin |
int(11)
|
|
|
|
| unread_user |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| closed_at |
datetime
|
|
|
|
