Table: Simple Device Identifier

Temporary device identifier for support cases

ColumnName DataType Key  Not Null  Default Value Comment
ClientIdentifier UNIQUEIDENTIFIER   NN   Client device Identifier
SimpleIdentifier NVARCHAR(128)       Simple device identifier
ValidTill INTEGER       Time stamp for validity of the simple device identifier

 

How to create

CREATE TABLE SimpleDeviceIdentifier(
ClientIdentifier UNIQUEIDENTIFIER NOT NULL,
SimpleIdentifier NVARCHAR(128),
ValidTill INTEGER