McDewey

Error Message: 2.3.188.4 fkenduser (FI-1655) Type: guid (Cascade Delete) Rule (RI-327): Type: Validation (Insert/Update) Rule Name: No more than one EndUser Associated to dev Description: Only one user may be specified as the user fo Test Condition: ON INSERT/UPDATE IN EndUserDeviceMap IF WHERE fkDevice = @deviceID AND tkUserAs Error Message: Cannot associate multiple users with a device Remedy: Make sure the User and Device are correct an Rule (RI-938): Type: Validation (Insert/Update) Rule Name: Only CDT can be associated with token user Description: Only CDT can be associated with Token EndU Test Condition: On I/U of DeviceNumPlanMap: If tkUserProfil THEN THROW EXCEPTION Error Message: Token EndUser can be associated with CDT o 2.3.188.5 pkid (FI-1654) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. 2.3.188.6 tkuserassociation (FI-2484) Type: enum Rule (RI-327): Type: Validation (Insert/Update) Rule Name: No more than one EndUser Associated to dev Description: Only one user may be specified as the user fo Test Condition: ON INSERT/UPDATE IN EndUserDeviceMap IF WHERE fkDevice = @deviceID AND tkUserAs Error Message: Cannot associate multiple users with a device Remedy: Make sure the User and Device are correct an Uniqueness: fkdevice + fkenduser + tkuserassociation is unique. (MFI-80) 2.3.189 enduserdirgroupmap (TI-232) Description: Many to many relationship between EndUser and DirGroup