McDewey

2.3.104.2 fkdevice (FI-3304) Type: guid (Unique, Cascade Delete) 2.3.104.3 fkdevicepool_devicemobility (FI-3165) Type: guid (Null OK) Default Value: NULL 2.3.104.4 pkid (FI-3303) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. 2.3.104.5 versionstamp (FI-3451) Type: string [47] (Null OK) Default Value: 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 Remarks: New guid is generated every time this device is updated Rule (RI-413): Type: Active (Insert/Update) This field is modified by this rule. Rule Name: DeviceMobilityDynamic versionstamp Description: update versionstamp in DeviceMobilityDyna Test Condition: update DeviceMobilityDynamic Rule (RI-413): Type: Active (Insert/Update) Rule Name: DeviceMobilityDynamic versionstamp Description: update versionstamp in DeviceMobilityDyna Test Condition: update DeviceMobilityDynamic Uniqueness: No multicolumn uniqueness constraints 2.3.105 devicemobilitygroup (TI-423) Description: Used for Device Mobility Fields: 2.3.105.1 description (FI-3170) Type: string [200] Default Value: EMPTY Validation: ^[^\x00-\x1F""%&<>]{0,50}$ 2.3.105.2 name (FI-3171) Type: string [50] (Unique) Validation: ^[a-zA-Z 0-9._-]{1,50}$ 2.3.105.3 pkid (FI-3172)