McDewey

Type: guid (Cascade Delete) 2.3.19.3 fkdevice (FI-2077) Type: guid (Cascade Delete) 2.3.19.4 pkid (FI-2079) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. 2.3.19.5 tkuserassociation (FI-2390) Type: enum Uniqueness: fkdevice + fkapplicationuser + tkuserassociation is unique. (MFI-76) 2.3.20 applicationuserdirgroupmap (TI-238) Description: Similar to UserGroupMap to group ApplicationUser into a DirGroup Fields: 2.3.20.1 fkapplicationuser (FI-1685) Type: guid (Cascade Delete) 2.3.20.2 fkdirgroup (FI-1686) Type: guid (Cascade Delete) Rule (RI-201): Type: Validation (Update/Delete) Rule Name: Standard CCM Super Users Group Restriction Description: The CCM Super Users Group must contain at locking primary administrator out of the syst Test Condition: ON DELETE FROM ApplicationUserDirGroup (SELECT COUNT(*) FROM ApplicationUserDir UPDATE ApplicationUserDirGroupMap IF (Di <> new_fkDirGroup) THEN throw exception Error Message: CCM Super User Group must contain at least Remedy: Add another Application User to be the CCM 2.3.20.3 isstandard (FI-2052) Type: bool (Not Modifiable) Default Value: FALSE Remarks: If standard set true during installation. Standard groups are 2.3.20.4 pkid (FI-1684) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. Uniqueness: fkdirgroup + fkapplicationuser is unique. (MFI-75)