DEPRECATED_21_02_aspnet_Membership


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ApplicationId uniqueidentifier 16 null
DEPRECATED_21_02_aspnet_Applications.ApplicationId FK__aspnet_Me__Appli__7737525AR
UserId uniqueidentifier 16 null
DEPRECATED_21_02_aspnet_Users.UserId FK__aspnet_Me__UserI__039D293FR
Password nvarchar 256 null
PasswordFormat int 4 ((0))
PasswordSalt nvarchar 256 null
MobilePIN nvarchar 32 √ null
Email nvarchar 512 √ null
LoweredEmail nvarchar 512 √ null
PasswordQuestion nvarchar 512 √ null
PasswordAnswer nvarchar 256 √ null
IsApproved bit 1 null
IsLockedOut bit 1 null
CreateDate datetime 16,3 null
LastLoginDate datetime 16,3 null
LastPasswordChangedDate datetime 16,3 null
LastLockoutDate datetime 16,3 null
FailedPasswordAttemptCount int 4 null
FailedPasswordAttemptWindowStart datetime 16,3 null
FailedPasswordAnswerAttemptCount int 4 null
FailedPasswordAnswerAttemptWindowStart datetime 16,3 null
Comment ntext 1073741823 √ null

Indexes

Constraint Name Type Sort Column(s)
PK__aspnet_Membershi__6A7C75BA Primary key Asc UserId

Relationships

Close relationships within degrees of separation