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