Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkUPID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each password record |
||||
| fkUserID | int | 4 | null |
|
|
User reference - Links to AccessUser table for the user account |
|||||
| Password | varchar | 100 | √ | null |
|
|
Encrypted password - Legacy encrypted password field (deprecated in favor of PasswordHash) |
||||
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Creation date - Timestamp when the password was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the administrator who set this password |
||||
| DateChanged | datetime | 16,3 | √ | null |
|
|
Last change date - Timestamp when the password was last changed |
||||
| DateLocked | datetime | 16,3 | √ | null |
|
|
Lock date - Timestamp when the account was locked due to security violations |
||||
| MustChangePassword | bit | 1 | √ | null |
|
|
Force password change - Flag requiring user to change password on next login |
||||
| Active | bit | 1 | √ | null |
|
|
Active password - Flag indicating if this is the current active password |
||||
| Attempt | int | 4 | √ | null |
|
|
Failed attempts - Count of failed login attempts for account lockout management |
||||
| Salt | float | 8 | √ | null |
|
|
Password salt - Cryptographic salt value for secure password hashing |
||||
| PasswordHash | varbinary | 128 | √ | null |
|
|
Password hash - Secure hash of the user’s password using salt |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_UserPasswords | Primary key | Asc | pkUPID |
Relationships
Close relationships within degrees of separation
