dbo.QBMPwdPolicy
Password policies
TableType TUsage USERDATARows 4SizeMB 0.032
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QBMPwdPolicy | varchar(38) | no | Password policy | PKUID |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
CheckScriptName | nvarchar(256) | yes | Check script | |
DisplayName | nvarchar(128) | yes | Display name | |
Description | nvarchar(2048) | yes | Description | |
ErrorMessage | nvarchar(-1) | yes | Error message | |
IsDefault | bit(1) | yes | Default policy | |
MinLen | int(4) | yes | Min. length | |
MaxLen | int(4) | yes | Max. length | |
MinLetters | int(4) | yes | Min. number letters | |
MinLettersLowerCase | int(4) | yes | Min. number lowercase | |
MinLettersUpperCase | int(4) | yes | Min. number uppercase | |
MinNumbers | int(4) | yes | Min. number digits | |
MinSpecialChar | int(4) | yes | Min. number special characters | |
IsElementPropertiesDenied | bit(1) | yes | Prohibited name properties | |
SpecialCharsAllowed | nvarchar(-1) | yes | Allowed special characters | |
SpecialCharsDenied | nvarchar(-1) | yes | Prohibited special characters | |
MaxAge | int(4) | yes | Validity period (max. # days) | |
MaxRepeatLen | int(4) | yes | Max. identical characters in succession | |
MaxRepeatCount | int(4) | yes | Max. identical characters at all | |
HistoryLen | int(4) | yes | Password history | |
MinPasswordQuality | int(4) | yes | Min. password strength | |
MaxBadAttempts | int(4) | yes | Max. failed logins | |
DefaultInitialPassword | varchar(990) | yes | Initial password | |
CreateScriptName | nvarchar(256) | yes | Generating script | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsLowerLetterNotAllowed | bit(1) | yes | Do not generate lowercase letters | |
IsUpperLetterNotAllowed | bit(1) | yes | Do not generate uppercase letters | |
IsNumberNotAllowed | bit(1) | yes | Do not generate digits | |
IsSpecialNotAllowed | bit(1) | yes | Do not generate special characters | |
MandatoryCharacterClasses | int(4) | yes | Required number of character classes | |
AdditionalPwdRequirements | nvarchar(-1) | yes | Additional requirements | |
UID_AERoleOwner | varchar(38) | yes | Owner (Application Role) | FKUID |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL450 | QBMObjectHasPwdPolicy.UID_QBMPwdPolicy | QBMPwdPolicy.UID_QBMPwdPolicy |
| QER_RFRL410 | QBMPwdPolicy.UID_AERoleOwner | BaseTree.UID_Org |
Triggers
GEN_T1F4E6318405687DE77AC2B806 SQL_TRIGGER
GEN_T2086620A4B1B1E30DADE8A1F5 SQL_TRIGGER
GEN_T5A53A61E57A65634F99A6F788 SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.GEN_T5A53A61E57A65634F99A6F788 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonAndAERoles | SQL expression dependency | OBJECT_OR_COLUMN |
| QBMObjectHasPwdPolicy | foreign key references table | QBM_RFRL450: QBMObjectHasPwdPolicy.UID_QBMPwdPolicy -> QBMPwdPolicy.UID_QBMPwdPolicy |
| BaseTree | referenced by foreign key from table | QER_RFRL410: QBMPwdPolicy.UID_AERoleOwner -> BaseTree.UID_Org |
| cs-qer-customizer-qer-customizer-person.cs | decompiled C# reference | classes Person, MP, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass11_1; methods _003C_LoadShoppingCartPattern_003Eb__0, _003C_LoadShoppingCartPattern_003Eb__1, _003C_LoadShoppingCartPattern_003Eb__3, _003C_LoadShoppingCartPattern_003Eb__2, _003C_UpdateShoppingCartPattern_003Eb__0, _003C_UpdateShoppingCartPattern_003Eb__1; references AccProduct, AERole, Delegation, DialogColumn, DialogGroup, DialogParameter; markers reads entity values, writes entity values, saves entities, references DB/Dialog objects, IT Shop related markers, Job/process related markers |