Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkPolicyID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each password policy configuration |
||||
| ExpireDays | int | 4 | √ | null |
|
|
Password expiration days - Number of days before password expires |
||||
| MinPasswordLength | int | 4 | √ | null |
|
|
Minimum password length - Minimum number of characters required for passwords |
||||
| fkComplexityID | int | 4 | √ | null |
|
|
Complexity reference - Links to PasswordComplexity table for complexity requirements (foreign key to PasswordComplexity.pkPCID) |
||||
| RepeatHistory | int | 4 | √ | null |
|
|
Password history count - Number of previous passwords that cannot be reused |
||||
| LoginAttempts | int | 4 | √ | null |
|
|
Maximum login attempts - Number of failed login attempts before account lockout |
||||
| LockoutMinutes | int | 4 | √ | null |
|
|
Lockout duration - Number of minutes account remains locked after failed attempts |
||||
| AllowReset | bit | 1 | √ | null |
|
|
Allow password reset - Boolean flag whether users can reset their own passwords |
||||
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation timestamp - Date and time when password policy was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the user who created this policy |
||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update timestamp - Date and time when password policy was last modified |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the user who last updated this policy |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PasswordPolicy | Primary key | Asc | pkPolicyID |
Relationships
Close relationships within degrees of separation
