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