McDewey

Validation: ^[a-fA-F0-9]{0,128}$ Remarks: Used for digest authentication 2.3.16.10 pkid (FI-1658) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. Rule (RI-398): Type: Active (Insert) Rule Name: Automatically Insert Credential (Password o Description: When an ApplicationUser is inserted, autom with default policy specified in CredentialPo Credential is updated for the first time. Test Condition: ON INSERT INTO ApplicationUser: Rule (RI-2138): Type: Validation (Delete) Rule Name: Self-Provisioing App User deletion not allow Description: Application User selected in the self provisio Test Condition: On Delete (select count(*) from globalsetting tkglobalsetting=TypeGlobalSetting.GLOBAL_ and settingvalue=applicationuser.pkid) < 1 Error Message: This Application User is being used in the Se deleted. 2.3.16.11 userrank (FI-27580) Type: enum (Indexed) Default Value: 1 Check Constraint: (UserRank >= 1) AND (UserRank <= 10) Remarks: Rank of application user. Access control groups assigned to t lower rank. Required reference to enum column of parent r Uniqueness: No multicolumn uniqueness constraints 2.3.17 applicationusercapfmap (TI-353) Description: 1-N relation between App User to CAPF Fields: 2.3.17.1 authenticationstring (FI-2622) Type: string [50] Default Value: EMPTY 2.3.17.2 fkapplicationuser (FI-2630) Type: guid (Indexed, Cascade Delete, Not Modifiable) Migration Source: ApplicationUser.pkid