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 |
|
|
|
|