| id |
int(11)
|
|
|
|
| ip_address |
varchar(45)
|
latin1_general_ci
|
|
|
| username |
varchar(100)
|
latin1_general_ci
|
|
|
| password |
varchar(255)
|
latin1_general_ci
|
|
|
| salt |
varchar(255)
|
latin1_general_ci
|
|
|
| email |
varchar(254)
|
latin1_general_ci
|
|
|
| activation_code |
varchar(40)
|
latin1_general_ci
|
|
|
| forgotten_password_code |
varchar(40)
|
latin1_general_ci
|
|
|
| forgotten_password_time |
int(11)
|
|
|
|
| remember_code |
varchar(40)
|
latin1_general_ci
|
|
|
| created_on |
int(11)
|
|
|
|
| last_login |
int(11)
|
|
|
|
| active |
tinyint(1)
|
|
|
|
| first_name |
varchar(50)
|
latin1_general_ci
|
|
|
| last_name |
varchar(50)
|
latin1_general_ci
|
|
|
| company |
varchar(100)
|
latin1_general_ci
|
|
|
| phone |
varchar(20)
|
latin1_general_ci
|
|
|
| menu |
text
|
latin1_general_ci
|
|
|
| sub_menu |
text
|
latin1_general_ci
|
|
|
| segmen |
varchar(20)
|
latin1_general_ci
|
|
|
| idDokter |
varchar(20)
|
latin1_general_ci
|
|
|
| idLokasi |
int(30)
|
|
|
|
| idUserLevel |
int(30)
|
|
|
|
| idUser |
int(11)
|
|
|
|