McDewey

Description: on enduserASMap delete, delete NumPlanASM Test Condition: delete enduserASMap record 2.3.184.2 fkappserver (FI-2774) Type: guid (Cascade Delete) 2.3.184.3 fkenduser (FI-2773) Type: guid (Cascade Delete) 2.3.184.4 pkid (FI-2772) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. Uniqueness: No multicolumn uniqueness constraints 2.3.185 endusercapfmap (TI-354) Description: 1-N relation between End User to CAPF Fields: 2.3.185.1 authenticationstring (FI-2634) Type: string [50] Default Value: EMPTY 2.3.185.2 fkenduser (FI-2642) Type: guid (Indexed, Cascade Delete, Not Modifiable) Migration Source: EndUser.pkid 2.3.185.3 instanceid (FI-2643) Type: string [128] (Unique, Indexed, Not Modifiable) Validation: ^[a-zA-Z0-9]{1,128}$ Remarks: To distinguish multiplicity for a single user. Rule (RI-321): Type: Validation (Insert/Update) Rule Name: InstanceID unique across App and EndUserC Description: InstanceID must be unique across both User EndUserCAPFMap) Test Condition: ON INSERT/UPDATE IN ApplicationUserCAP COUNT(*) FROM <table> WHERE lower(Inst exception Error Message: Cannot insert duplicate instance ID in EndU Remedy: Make sure the instance ID is unique across b instances and try again. 2.3.185.4 packetcaptureduration (FI-2633)