| ID |
int(11) |
|
|
|
|
| username |
varchar(50) |
latin1_swedish_ci |
|
|
|
| password |
varchar(255) |
latin1_swedish_ci |
|
|
|
| auth_key |
varchar(32) |
latin1_swedish_ci |
|
|
|
| password_hash |
varchar(255) |
latin1_swedish_ci |
|
|
|
| password_reset_token |
varchar(255) |
latin1_swedish_ci |
|
|
|
| status |
smallint(10) |
|
|
|
|
| PhotoUrl |
varchar(255) |
latin1_swedish_ci |
|
|
|
| Fullname |
varchar(255) |
latin1_swedish_ci |
|
|
|
| EmailAddress |
varchar(255) |
latin1_swedish_ci |
|
|
|
| IsActive |
bit(1) |
|
|
|
|
| SesID |
varchar(255) |
latin1_swedish_ci |
|
|
|
| MaxDateSesID |
datetime |
|
|
|
|
| ActivationCode |
varchar(255) |
latin1_swedish_ci |
|
|
|
| LoginAttemp |
int(11) |
|
|
|
|
| LastSubmtLogin |
datetime |
|
|
|
|
| LastSuccess |
datetime |
|
|
|
|
| Department_id |
int(11) |
|
|
|
|
| Branch_id |
int(11) |
|
|
|
|
| Role_id |
int(11) |
|
|
|
|
| IsCanResetUserPassword |
bit(1) |
|
|
|
|
| IsCanResetMemberPassword |
bit(1) |
|
|
|
|
| IsAdvanceEntryCatalog |
bit(1) |
|
|
|
|
| IsAdvanceEntryCollection |
bit(1) |
|
|
|
|
| CreateBy |
int(11) |
|
|
|
|
| CreateDate |
datetime |
|
|
|
|
| CreateTerminal |
varchar(100) |
latin1_swedish_ci |
|
|
|
| UpdateBy |
int(11) |
|
|
|
|
| UpdateDate |
datetime |
|
|
|
|
| UpdateTerminal |
varchar(100) |
latin1_swedish_ci |
|
|
|
| created_at |
int(11) |
|
|
|
|
| updated_at |
int(11) |
|
|
|
|
| KIILastUploadDate |
datetime |
|
|
|
|