McDewey

2.3.207.2 permission (FI-1683) Type: long Rule (RI-335): Type: Validation (Insert/Update/Delete) Rule Name: Standard Functional Role Resource Restrictio Description: The Resources and Permissions associated w changed in any way Test Condition: ON INSERT/UPDATE/DELETE IN FunctionRole FuntionRole WHERE pkid = @fkFunctionRole Error Message: Cannot modify the Permission and Resources Remedy: Create a new Role with the desired resources 2.3.207.3 pkid (FI-1680) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. 2.3.207.4 tkresource (FI-1682) Type: enum Rule (RI-335): Type: Validation (Insert/Update/Delete) Rule Name: Standard Functional Role Resource Restrictio Description: The Resources and Permissions associated w changed in any way Test Condition: ON INSERT/UPDATE/DELETE IN FunctionRole FuntionRole WHERE pkid = @fkFunctionRole Error Message: Cannot modify the Permission and Resources Remedy: Create a new Role with the desired resources Uniqueness: No multicolumn uniqueness constraints 2.3.208 gatekeeper (TI-138) Description: Gatekeeper information in not in Device table Fields: 2.3.208.1 enabledevice (FI-1181) Type: bool Default Value: TRUE 2.3.208.2 fkdevice (FI-778) Type: guid (Indexed, Cascade Delete) Rule (RI-113): Type: Validation (Insert/Update) Rule Name: Gatekeeper device