McDewey

Test Condition: ON INSERT/UPDATE INTO EndUserCustomer return currentTime (INTO timestamp); Uniqueness: fkenduser + fkcustomer is unique. (MFI-1041) 2.3.188 enduserdevicemap (TI-229) Description: Control association between users and devices (many to many) Fields: 2.3.188.1 defaultprofile (FI-1657) Type: bool Default Value: FALSE Remarks: This device is the default EM profile for this user. 2.3.188.2 description (FI-1936) Type: string [200] Default Value: EMPTY Validation: ^[^""""]{0,128}$ Remarks: User-entered description of a controlled device (allows Unico 2.3.188.3 fkdevice (FI-1656) Type: guid (Cascade Delete) Rule (RI-281): Type: Active (Insert/Update/Delete records) Rule Name: enduserdevicemap versionstamp Description: on change to anything in enduserdevicemap versionstamp Test Condition: update devicerelatedversionstamp 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 Token EndUser can be associated with CDT o