Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
UserId | uniqueidentifier | 16 | null |
|
|
|||||
PasswordFormat | int | 4 | null |
|
|
|||||
MobilePIN | nvarchar | 32 | √ | null |
|
|
||||
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 |
|
|
||||
ApplicationId | uniqueidentifier | 16 | null |
|
|
|||||
UserName | nvarchar | 512 | null |
|
|
|||||
MobileAlias | nvarchar | 32 | √ | null |
|
|
||||
IsAnonymous | bit | 1 | null |
|
|
|||||
LastActivityDate | datetime | 16,3 | null |
|
|