McDewey

2.3.101 devicejson (TI-21073) Description: Defines the product specific configuration for devices in JSON format Fields: 2.3.101.1 data (FI-28396) Type: json (Null OK) Remarks: JSON blob to store all the device data 2.3.101.2 fkdevice (FI-28395) Type: guid (Unique, Indexed, Cascade Delete) Migration Source: convert from Device Remarks: Pkid of the Device corresponding to the JSON column of Devi 2.3.101.3 pkid (FI-28394) Type: guid (Unique, Not Modifiable) Default Value: newid() Migration Source: Generated Remarks: Unique ID to identify a record. Uniqueness: No multicolumn uniqueness constraints 2.3.102 devicemanagementdynamic (TI-2593) Description: Stores the timestamp for remote wipe/lock state change request or acknowlege Fields: 2.3.102.1 datetimestamp (FI-25662) Type: long Default Value: 0 Remarks: Time stamp for the last remote/wipe state change. Rule (RI-400): Type: Active (Insert/Update) Rule Name: Update the DateTimeStamp for Dynamic reco Description: When a record in a Dynamic table is updated value Test Condition: ON INSERT/UPDATE INTO *Dynamic: LET cur currentTime (INTO DateTimeStamp); Rule (RI-400): Type: Active (Insert/Update) This field is modified by this rule. Rule Name: Update the DateTimeStamp for Dynamic reco Description: When a record in a Dynamic table is updated value Test Condition: ON INSERT/UPDATE INTO *Dynamic: LET cur currentTime (INTO DateTimeStamp);