McDewey

Rule (RI-400): Type: Active (Insert/Update) Rule Name: Update the DateTimeStamp for Dynamic rec Description: When a record in a Dynamic table is update value Test Condition: ON INSERT/UPDATE INTO *Dynamic: LET cu currentTime (INTO DateTimeStamp); Rule (RI-400): Type: Active (Insert/Update) This field is modified by this rule. Rule Name: Update the DateTimeStamp for Dynamic rec Description: When a record in a Dynamic table is update value Test Condition: ON INSERT/UPDATE INTO *Dynamic: LET cu currentTime (INTO DateTimeStamp); 2.3.18.2 fkapplicationusercapfmap (FI-3310) Type: guid (Unique, Cascade Delete) 2.3.18.3 fkprocessnode (FI-2878) Type: guid (Cascade Delete, Null OK) Default Value: NULL Check Constraint: fkProcessNode != '00000000-1111-0000-0000-000000000000' Remarks: The server to which this user, with this certificate, has opene 2.3.18.4 pkid (FI-3309) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. 2.3.18.5 userstate (FI-3016) Type: long Default Value: 0 Uniqueness: No multicolumn uniqueness constraints 2.3.19 applicationuserdevicemap (TI-297) Description: Maps controllability between App Users & Devices. Fields: 2.3.19.1 description (FI-2076) Type: string [200] Default Value: EMPTY Validation: ^[^""""]{0,50}$ Remarks: ApplicationUser-entered description of a controlled device (all 2.3.19.2 fkapplicationuser (FI-2078)