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 |