|
id
|
int(11)
|
|
|
|
|
username
|
varchar(50)
|
|
|
|
|
salt
|
varchar(32)
|
|
|
|
|
password
|
varchar(64)
|
|
|
|
|
token
|
varchar(512)
|
|
|
|
|
status
|
tinyint(1)
|
|
|
0
|
|
permission
|
text
|
|
|
|
|
name
|
varchar(150)
|
|
|
|
|
sex
|
varchar(1)
|
|
|
|
|
id_card
|
varchar(13)
|
|
|
|
|
address
|
varchar(64)
|
|
|
|
|
phone
|
varchar(20)
|
|
|
|
|
provinceID
|
smallint(3)
|
|
|
|
|
province
|
varchar(64)
|
|
|
|
|
zipcode
|
varchar(5)
|
|
|
|
|
country
|
varchar(2)
|
|
|
TH
|
|
created_at
|
datetime
|
|
|
|
|
active
|
tinyint(1)
|
|
|
1
|
|
social
|
enum
|
-- |
|
user
|
|
line_uid
|
varchar(33)
|
|
|
|
|
telegram_id
|
varchar(20)
|
|
|
|
|
activatecode
|
varchar(64)
|
|
|
|
|
address2
|
varchar(64)
|
|
|
|
|
birthday
|
date
|
|
|
|
|
company
|
varchar(64)
|
|
|
|
|
phone1
|
varchar(20)
|
|
|
|
|
tax_id
|
varchar(13)
|
|
|
|
|
token_expires
|
datetime
|
|
|
|
|
visited
|
int(11)
|
|
|
0
|
|
website
|
varchar(255)
|
|
|
|