McDewey

2.3.224 headsetenduserdevicemap (TI-24010) Description: To associate Headset to EndUser. Fields: 2.3.224.1 fkdevice (FI-28416) Type: guid (Cascade Delete, Null OK) Migration Source: Device Rule (RFI-725): Type: Inter-field Condition and Constraint Test Condition: fkEndUser IS NOT NULL Constraint: fkDevice IS NULL Remarks: Both fkDevice and fkEndUser together cann Rule (RFI-726): Type: Inter-field Condition and Constraint Test Condition: fkEndUser IS NULL Constraint: fkDevice IS NOT NULL Remarks: Both fkEndUser and fkDevice together cann 2.3.224.2 fkenduser (FI-28418) Type: guid (Cascade Delete, Null OK) 2.3.224.3 headset (FI-28417) Type: string [132] Validation: ^[a-zA-Z0-9]{1,132}$ Remarks: Serial number of the HeadSet. 2.3.224.4 pkid (FI-28415) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. Uniqueness: No multicolumn uniqueness constraints Constraints: Rule (RFI-727): Type: Inter-field Condition and Constraint Constraint: NOT EXISTS ( select M.headset from HeadsetE Headset group by M.headset having count(M Remarks: One headset cannot be associated with more Rule (RFI-728): Type: Inter-field Condition and Constraint Constraint: NOT EXISTS ( select M.headset from HeadsetE Headset group by M.headset having count(M Remarks: Max 15 record is allowed for device associati Rule (RFI-729): Type: Inter-field Condition and Constraint Constraint: NOT EXISTS ( select M.headset from HeadsetE Headset AND fkdevice IS NOT NULL AND fkE count(M.fkEndUser) >0)