Generated using SQL Data Dictionary demo version.
Column | Data Type | Identity | Nullable | Default | |
---|---|---|---|---|---|
FK | ApplicationId | uniqueidentifier | |||
PK, FK | UserId | uniqueidentifier | |||
Password | nvarchar(128) | ||||
PasswordFormat | int | 0 | |||
PasswordSalt | nvarchar(128) | ||||
MobilePIN | nvarchar(16) | X | |||
nvarchar(256) | X | ||||
LoweredEmail | nvarchar(256) | X | |||
PasswordQuestion | nvarchar(256) | X | |||
PasswordAnswer | nvarchar(128) | X | |||
IsApproved | bit | ||||
IsLockedOut | bit | ||||
CreateDate | datetime | ||||
LastLoginDate | datetime | ||||
LastPasswordChangedDate | datetime | ||||
LastLockoutDate | datetime | ||||
FailedPasswordAttemptCount | int | ||||
FailedPasswordAttemptWindowStart | datetime | ||||
FailedPasswordAnswerAttemptCount | int | ||||
FailedPasswordAnswerAttemptWindowStart | datetime | ||||
Comment | ntext | X |