Information for the PersonalDevice

Columns

• Id (datatype: int) Required Primary Key
• PersonAliasId (datatype: int) Required Primary Key
• DeviceRegistrationId (datatype: nvarchar(max)) Required Primary Key
• NotificationsEnabled (datatype: bit) Required Primary Key
• CreatedDateTime (datatype: datetime) Required Primary Key
• ModifiedDateTime (datatype: datetime) Required Primary Key
• CreatedByPersonAliasId (datatype: int) Required Primary Key
• ModifiedByPersonAliasId (datatype: int) Required Primary Key
• Guid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• PersonalDeviceTypeValueId (datatype: int) Required Primary Key
• PlatformValueId (datatype: int) Required Primary Key
• DeviceUniqueIdentifier (datatype: nvarchar(50)) Required Primary Key
• DeviceVersion (datatype: nvarchar(100)) Required Primary Key
• MACAddress (datatype: nvarchar(12)) Required Primary Key
• IsActive (datatype: bit) Required Primary Key
• SiteId (datatype: int) Required Primary Key
• Manufacturer (datatype: nvarchar(50)) Required Primary Key
• Model (datatype: nvarchar(50)) Required Primary Key
• Name (datatype: nvarchar(50)) Required Primary Key
• LastSeenDateTime (datatype: datetime) Required Primary Key
• LastVerifiedDateTime (datatype: datetime) Required Primary Key