Table HLPDTEST.STATEGPS.T_GPS_PASSWORD_CONFIGURATION Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
MIN_LENGTH number 22  √  null
MAX_LENGTH number 22  √  null
SPECIALCHARS_FLAG varchar2 20  √  null
NUMERICS_FLAG varchar2 20  √  null
UPPERCASE_FLAG varchar2 20  √  null
LOWERCASE_FLAG varchar2 20  √  null
ENFORCE_PASSWORD_HISTORY number 22  √  3 Number of passwords to be remembered
PASSWORD_AGE number 22  √  45 Number of days for Password Validity
MIN_WAIT_PERIOD_FOR_RESET number 22  √  0 Minium no. of days required to reset Password again by User
INVALID_ATTEMPTS_TO_LOCK number 22  √  0 No. of invalid attempts accepted before locking the account
EXCLUDE_DICTIONARY_WORD varchar2 5  √  'false' Excluding Dictionary word and proper name in the password
EXCLUDE_USERNAME varchar2 5  √  'false' Excluding User name in the Password
ALERT_USER_ABOUT_EXPIRY_BEFORE number 22  √  null
MAINTAIN_PASSWORD_HISTORY number 22  √  null
ALLOWED_NO_OF_REPEATED_CHARS number 22  √  null

Table contained 1 rows at Mon May 23 01:05 IST 2022