CREATE TABLE [dbo].[valorisenzori] (
    [Id]                    BIGINT         IDENTITY (1, 1) NOT NULL,
    [messageId]             VARCHAR (3)    NULL,
    [temperature]           NVARCHAR (200) NULL,
    [humidity]              NVARCHAR (200) NULL,
    [BPM]                   NVARCHAR (200) NULL,
    [ECG]                   NVARCHAR (200) NULL,
    [PartitionId]           VARCHAR (3)    NULL,
    [EventProcessedUtcTime] DATETIME       NULL,
    [EventEnqueuedUtcTime]  DATETIME       NULL,
    [IoTHub]                NVARCHAR (200) NULL,
    [user] VARCHAR(50) NULL,
    CONSTRAINT [PK_iotdevkittable] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [pacient-senzor] FOREIGN KEY ([user]) REFERENCES [Pacient]([user])
);