| id |
int(11)
|
|
|
|
| last_ip_address |
varbinary(45)
|
|
|
|
| ip_address |
varbinary(45)
|
|
|
|
| username |
varchar(100)
|
utf8_general_ci
|
|
|
| password |
varchar(40)
|
utf8_general_ci
|
|
|
| salt |
varchar(40)
|
utf8_general_ci
|
|
|
| email |
varchar(100)
|
utf8_general_ci
|
|
|
| activation_code |
varchar(40)
|
utf8_general_ci
|
|
|
| forgotten_password_code |
varchar(40)
|
utf8_general_ci
|
|
|
| forgotten_password_time |
int(11)
|
|
|
|
| remember_code |
varchar(40)
|
utf8_general_ci
|
|
|
| created_on |
int(11)
|
|
|
|
| last_login |
int(11)
|
|
|
|
| active |
tinyint(1)
|
|
|
|
| first_name |
varchar(50)
|
utf8_general_ci
|
|
|
| last_name |
varchar(50)
|
utf8_general_ci
|
|
|
| company |
varchar(100)
|
utf8_general_ci
|
|
|
| phone |
varchar(20)
|
utf8_general_ci
|
|
|
| avatar |
varchar(55)
|
utf8_general_ci
|
|
|
| gender |
varchar(20)
|
utf8_general_ci
|
|
|
| group_id |
int(10)
|
|
|
|
| warehouse_id |
int(10)
|
|
|
|
| biller_id |
int(10)
|
|
|
|
| company_id |
int(11)
|
|
|
|
| show_cost |
tinyint(1)
|
|
|
|
| show_price |
tinyint(1)
|
|
|
|
| award_points |
int(11)
|
|
|
|
| view_right |
tinyint(1)
|
|
|
|
| edit_right |
tinyint(1)
|
|
|
|
| allow_discount |
tinyint(1)
|
|
|
|