McDewey

2.3.102.2 fkdevice (FI-25814) Type: guid (Unique, Indexed, Cascade Delete, Not Modifiable) Remarks: Foreign key to Device table Rule (RI-2152): Type: Active (Insert/Update) Rule Name: On Active Insert/Update of DeviceManageme DeviceManagementDynamic Description: On Insert/Update of DeviceManagementDyna Test Condition: ON INSERT/UPDATE: IF fkDevice IS NOT NUL ELSE Set pkid=pkid AND fkDevice=pkid Rule (RI-2152): Type: Active (Insert/Update) This field is modified by this rule. Rule Name: On Active Insert/Update of DeviceManageme DeviceManagementDynamic Description: On Insert/Update of DeviceManagementDyna Test Condition: ON INSERT/UPDATE: IF fkDevice IS NOT NUL ELSE Set pkid=pkid AND fkDevice=pkid 2.3.102.3 latestlockacknowledge (FI-25666) Type: long (Null OK) Remarks: Time stamp for last lock acknowledge. 2.3.102.4 latestlockrequest (FI-25665) Type: long (Null OK) Remarks: Time stamp for last lock request. 2.3.102.5 latestwipeacknowledge (FI-25664) Type: long (Null OK) Remarks: Time stamp for last wipe acknowledge. 2.3.102.6 latestwiperequest (FI-25663) Type: long (Null OK) Remarks: Time stamp for last wipe request. 2.3.102.7 pkid (FI-25661) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. Rule (RI-2152): Type: Active (Insert/Update) Rule Name: On Active Insert/Update of DeviceManageme DeviceManagementDynamic Description: On Insert/Update of DeviceManagementDyna Test Condition: ON INSERT/UPDATE: IF fkDevice IS NOT NUL ELSE Set pkid=pkid AND fkDevice=pkid