PasswordComplexity


Description

Password complexity requirements defining password strength rules and complexity criteria for system security. This table manages password complexity settings including character requirements, length specifications, and complexity rules, supporting security policy enforcement, password validation, and user account security for healthcare system access control.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ComplexityName Unknown 0 null

Complexity name - Descriptive name for the password complexity rule set

MinComplexityScore Unknown 0 null

Minimum complexity score - Minimum complexity score required for password acceptance

pkPCID int identity 4 null
PasswordPolicy.fkComplexityID FK_PasswordPolicy_PasswordComplexity R

Primary key - Unique identifier for each password complexity configuration

Title varchar 200 null

Complexity title - Descriptive title for the password complexity rule set

RegEx varchar 500 null

Regular expression - Regular expression pattern used to validate password complexity

RequireLowercase Unknown 0 null

Lowercase requirement - Boolean flag requiring lowercase letters in passwords

RequireNumbers Unknown 0 null

Number requirement - Boolean flag requiring numeric characters in passwords

RequireSpecialChars Unknown 0 null

Special character requirement - Boolean flag requiring special characters in passwords

RequireUppercase Unknown 0 null

Uppercase requirement - Boolean flag requiring uppercase letters in passwords

Indexes

Constraint Name Type Sort Column(s)
PK_PasswordComplexity Primary key Asc pkPCID

Relationships