Description
Used by the SQL Membership Provider to store membership data.
Columns
| Name |
Type |
Description |
| ApplicationId |
uniqueidentifier |
Application ID
|
| UserId |
uniqueidentifier |
User ID
|
| Password |
nvarchar(128) |
Password (plaintext, hashed, or encrypted; base-64-encoded if hashed or encrypted)
|
| PasswordFormat |
int |
Password format (0=Plaintext, 1=Hashed, 2=Encrypted)
|
| PasswordSalt |
nvarchar(128) |
Randomly generated 128-bit value used to salt password hashes; stored in base-64-encoded form
|
| MobilePIN |
nvarchar(16) |
User's mobile PIN (currently not used)
|
| Email |
nvarchar(256) |
User's e-mail address
|
| LoweredEmail |
nvarchar(256) |
User's e-mail address (lowercase)
|
| PasswordQuestion |
nvarchar(256) |
Password question
|
| PasswordAnswer |
nvarchar(128) |
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
|
Relationships
| Primary Table |
Primary Key |
Foreign Table |
Foreign Key |
| aspnet_Applications |
ApplicationId |
aspnet_Membership |
ApplicationId |
| aspnet_Users |
UserId |
aspnet_Membership |
UserId |
ASP.NET 2.0 Provider Database