ASPNETDB Database

Table: aspnet_Membership

Description

Used by the SQL Membership Provider to store membership data.

Columns

Name  Type  Required?  Defaults To  Description 
ApplicationId  uniqueidentifier  Yes    Application ID
UserId  uniqueidentifier  Yes    User ID
Password  nvarchar(128)  Yes    Password (plaintext, hashed, or encrypted; base-64-encoded if hashed or encrypted)
PasswordFormat  int  Yes  ((0))  Password format (0=Plaintext, 1=Hashed, 2=Encrypted)
PasswordSalt  nvarchar(128)  Yes    Randomly generated 128-bit value used to salt password hashes; stored in base-64-encoded form
MobilePIN  nvarchar(16)  No    User's mobile PIN (currently not used)
Email  nvarchar(256)  No    User's e-mail address
LoweredEmail  nvarchar(256)  No    User's e-mail address (lowercase)
PasswordQuestion  nvarchar(256)  No    Password question
PasswordAnswer  nvarchar(128)  No    Answer to password question
IsApproved  bit  Yes    1=Approved, 0=Not approved
IsLockedOut  bit  Yes    1=Locked out, 0=Not locked out
CreateDate  datetime  Yes    Date and time this account was created
LastLoginDate  datetime  Yes    Date and time of this user's last login
LastPasswordChangedDate  datetime  Yes    Date and time this user's password was last changed
LastLockoutDate  datetime  Yes    Date and time this user was last locked out
FailedPasswordAttemptCount  int  Yes    Number of consecutive failed login attempts
FailedPasswordAttemptWindowStart  datetime  Yes    Date and time of first failed login if FailedPasswordAttemptCount is nonzero
FailedPasswordAnswerAttemptCount  int  Yes    Number of consecutive failed password answer attempts
FailedPasswordAnswerAttemptWindowStart  datetime  Yes    Date and time of first failed password answer if FailedPasswordAnswerAttemptCount is nonzero
Comment  ntext  No    Additional text

Relationships

Primary Table  Primary Key  Foreign Table  Foreign Key 
aspnet_Applications  ApplicationId  aspnet_Membership  ApplicationId 
aspnet_Users  UserId  aspnet_Membership  UserId 

Indexes

Name  Type  Columns 
aspnet_Membership_index  Non-unique, Clustered  ApplicationId, LoweredEmail 
PK__aspnet_Membershi__1367E606  Unique  UserId 

Referencing Views

Name 
vw_aspnet_MembershipUsers 

Definition

CREATE TABLE [aspnet_Membership]
(
    [ApplicationId] uniqueidentifier NOT NULL,
    [UserId] uniqueidentifier NOT NULL,
    [Password] nvarchar(128) NOT NULL,
    [PasswordFormat] int NOT NULL DEFAULT (((0))),
    [PasswordSalt] nvarchar(128) NOT NULL,
    [MobilePIN] nvarchar(16) NULL,
    [Email] nvarchar(256) NULL,
    [LoweredEmail] nvarchar(256) NULL,
    [PasswordQuestion] nvarchar(256) NULL,
    [PasswordAnswer] nvarchar(128) NULL,
    [IsApproved] bit NOT NULL,
    [IsLockedOut] bit NOT NULL,
    [CreateDate] datetime NOT NULL,
    [LastLoginDate] datetime NOT NULL,
    [LastPasswordChangedDate] datetime NOT NULL,
    [LastLockoutDate] datetime NOT NULL,
    [FailedPasswordAttemptCount] int NOT NULL,
    [FailedPasswordAttemptWindowStart] datetime NOT NULL,
    [FailedPasswordAnswerAttemptCount] int NOT NULL,
    [FailedPasswordAnswerAttemptWindowStart] datetime NOT NULL,
    [Comment] ntext NULL
    CONSTRAINT [PK_aspnet_Membership] PRIMARY KEY
    (
        [UserId]
    )
)

ASP.NET 2.0 Provider Database