time
|
int(11)
|
|
|
|
endtime
|
int(11)
|
|
|
|
closed
|
int(11)
|
|
|
|
chat_id
|
varchar(64)
|
utf8_bin
|
|
|
external_id
|
varchar(32)
|
utf8_bin
|
|
|
fullname
|
varchar(255)
|
utf8_bin
|
|
|
internal_id
|
varchar(32)
|
utf8_bin
|
|
|
group_id
|
varchar(32)
|
utf8_bin
|
|
|
area_code
|
varchar(255)
|
utf8_bin
|
|
|
html
|
longtext
|
utf8_bin
|
|
|
plaintext
|
longtext
|
utf8_bin
|
|
|
transcript_text
|
text
|
utf8_bin
|
|
|
transcript_html
|
text
|
utf8_bin
|
|
|
email
|
varchar(255)
|
utf8_bin
|
|
|
company
|
varchar(255)
|
utf8_bin
|
|
|
phone
|
varchar(255)
|
utf8_bin
|
|
|
call_me_back
|
tinyint(1)
|
|
|
|
iso_language
|
varchar(8)
|
utf8_bin
|
|
|
iso_country
|
varchar(5)
|
utf8_bin
|
|
|
host
|
varchar(64)
|
utf8_bin
|
|
|
ip
|
varchar(64)
|
utf8_bin
|
|
|
gzip
|
tinyint(1)
|
|
|
|
transcript_sent
|
tinyint(1)
|
|
|
|
transcript_receiver
|
varchar(255)
|
utf8_bin
|
|
|
question
|
varchar(255)
|
utf8_bin
|
|
|
customs
|
text
|
utf8_bin
|
|
|
subject
|
text
|
utf8_bin
|
|
|
voucher_id
|
varchar(32)
|
utf8_bin
|
|
|
wait
|
int(11)
|
|
|
|
duration
|
int(11)
|
|
|
|
accepted
|
tinyint(1)
|
|
|
|
ended
|
tinyint(1)
|
|
|
|
chat_type
|
tinyint(1)
|
|
|
|
ref_url
|
varchar(2048)
|
utf8_bin
|
|
|