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