Table idempiere9.adempiere.ad_passwordrule
Password Policies

 Generated by
Quality Systems & Solutions
Legend:
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
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
ad_passwordrule_id numeric 10
ad_client.ad_passwordrule_id adpasswordrule_adclient R
Password Policies
alphabeticalcharacter numeric 10  √  NULL::numeric Require at least # alphabetical in passwords
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
isdictmatchbackwards bpchar 1  √  'N'::bpchar Match dictionary words backwards
digitcharacter numeric 10  √  NULL::numeric Require at least # digit in passwords
isactive bpchar 1 'Y'::bpchar The record is active in the system
lowercasecharacter numeric 10  √  NULL::numeric Require at least # lower case char
maxlength numeric 10  √  NULL::numeric Maximum Length of Data
minlength numeric 10  √  NULL::numeric Minimum Length
name varchar 60 NULL::character varying Alphanumeric identifier of the entity
nonalphanumericcharacter numeric 10  √  NULL::numeric Require at least # non-alphanumeric char
numericalsequence numeric 10  √  NULL::numeric Length of numerical sequence to validate
pathdictionary varchar 255  √  NULL::character varying Path Dictionary
repeatcharacterregex numeric 10  √  NULL::numeric Length of repeated characters to validate
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10  √  NULL::numeric User who updated this records
uppercasecharacter numeric 10  √  NULL::numeric Require at least # upper case char
isusernamerule bpchar 1  √  'N'::bpchar Validate the password doesn't contain user name (ignore case and match backwards)
isusingdictionary bpchar 1  √  'N'::bpchar Using Dictionary
iswhitespace bpchar 1  √  'N'::bpchar Whitespace validation
ad_passwordrule_uu varchar 36  √  NULL::character varying AD_PasswordRule_UU
alphabeticalsequence numeric 10  √  NULL::numeric Lenght of alphabetical sequence to validate
qwertysequence numeric 10  √  NULL::numeric Lenght of QWERTY sequences to validate
days_reuse_password numeric 10  √  NULL::numeric Define number of day can reuser password

Table contained 0 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_passwordrule_id Primary key Asc ad_passwordrule_key
ad_passwordrule_uu Must be unique Asc ad_passwordrule_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.