id
|
varchar(32)
|
utf8_bin
|
|
|
extends
|
varchar(32)
|
utf8_bin
|
|
|
tid
|
varchar(32)
|
utf8_bin
|
|
|
email
|
varchar(128)
|
utf8_bin
|
|
|
info
|
text
|
utf8_bin
|
|
|
voided
|
tinyint(1)
|
|
|
|
paid
|
tinyint(1)
|
|
|
|
created
|
int(10)
|
|
|
|
first_used
|
int(10)
|
|
|
|
last_used
|
int(10)
|
|
|
|
expires
|
int(10)
|
|
|
|
edited
|
int(10)
|
|
|
|
chat_time
|
int(10)
|
|
|
|
chat_time_max
|
int(10)
|
|
|
|
chat_sessions
|
int(10)
|
|
|
|
chat_sessions_max
|
int(10)
|
|
|
|
chat_list
|
text
|
utf8_bin
|
|
|
visitor_id
|
varchar(32)
|
utf8_bin
|
|
|
business_type
|
tinyint(1)
|
|
|
|
company
|
varchar(255)
|
utf8_bin
|
|
|
tax_id
|
varchar(255)
|
utf8_bin
|
|
|
firstname
|
varchar(255)
|
utf8_bin
|
|
|
lastname
|
varchar(255)
|
utf8_bin
|
|
|
address_1
|
varchar(255)
|
utf8_bin
|
|
|
address_2
|
varchar(255)
|
utf8_bin
|
|
|
city
|
varchar(255)
|
utf8_bin
|
|
|
state
|
varchar(255)
|
utf8_bin
|
|
|
zip
|
varchar(255)
|
utf8_bin
|
|
|
country
|
varchar(5)
|
utf8_bin
|
|
|
phone
|
varchar(255)
|
utf8_bin
|
|
|
tn_id
|
varchar(255)
|
utf8_bin
|
|
|
price
|
double
|
|
|
|
currency
|
varchar(5)
|
utf8_bin
|
|
|
vat
|
double
|
|
|
|
payer_id
|
varchar(255)
|
utf8_bin
|
|
|
payment_details
|
text
|
utf8_bin
|
|
|
language
|
varchar(5)
|
utf8_bin
|
|
|