Columns
| Name |
Type |
Description |
| UserId |
uniqueidentifier |
User ID
|
| PasswordFormat |
int |
Password format (0=Plaintext, 1=Hashed, 2=Encrypted)
|
| MobilePIN |
nvarchar |
User's mobile PIN (currently not used)
|
| Email |
nvarchar |
User's e-mail address
|
| LoweredEmail |
nvarchar |
User's e-mail address (lowercase)
|
| PasswordQuestion |
nvarchar |
Password question
|
| PasswordAnswer |
nvarchar |
Answer to password question
|
| IsApproved |
bit |
1=Approved, 0=Not approved
|
| IsLockedOut |
bit |
1=Locked out, 0=Not locked out
|
| CreateDate |
datetime |
Date and time this account was created
|
| LastLoginDate |
datetime |
Date and time of this user's last login
|
| LastPasswordChangedDate |
datetime |
Date and time this user's password was last changed
|
| LastLockoutDate |
datetime |
Date and time this user was last locked out
|
| FailedPasswordAttemptCount |
int |
Number of consecutive failed login attempts
|
| FailedPasswordAttemptWindowStart |
datetime |
Date and time of first failed login if FailedPasswordAttemptCount is nonzero
|
| FailedPasswordAnswerAttemptCount |
int |
Number of consecutive failed password answer attempts
|
| FailedPasswordAnswerAttemptWindowStart |
datetime |
Date and time of first failed password answer if FailedPasswordAnswerAttemptCount is nonzero
|
| Comment |
ntext |
Additional text
|
| ApplicationId |
uniqueidentifier |
Application ID
|
| UserName |
nvarchar |
User name
|
| MobileAlias |
nvarchar |
User's mobile alias (currently not used)
|
| IsAnonymous |
bit |
1=Anonymous user, 0=Not an anonymous user
|
| LastActivityDate |
datetime |
Date and time of last activity by this user
|
ASP.NET 2.0 Provider Database