CREATE TABLE [dbo].[StoricoDtx2UDC] (
    [IdxEv]       INT           IDENTITY (1, 1) NOT NULL,
    [DataEv]      DATETIME      CONSTRAINT [DF_StoricoDtx2UDC_DataEv] DEFAULT (getdate()) NOT NULL,
    [DataMatrix]  NVARCHAR (50) NOT NULL,
    [CodStato]    NVARCHAR (50) CONSTRAINT [DF_StoricoDtx2UDC_CodStato] DEFAULT ('RX') NOT NULL,
    [UDC]         NVARCHAR (50) CONSTRAINT [DF_StoricoDtx2UDC_UDC] DEFAULT ('') NOT NULL,
    [DataOra]     DATETIME      CONSTRAINT [DF_StoricoDtx2UDC_DataOra] DEFAULT (getdate()) NOT NULL,
    [CodSoggetto] NCHAR (17)    CONSTRAINT [DF_StoricoDtx2UDC_CodSoggetto] DEFAULT ('') NOT NULL,
    [Particolare] NVARCHAR (15) CONSTRAINT [DF_StoricoDtx2UDC_Particolare] DEFAULT ('') NULL,
    CONSTRAINT [PK_StoricoDtx2UDC] PRIMARY KEY CLUSTERED ([IdxEv] ASC)
);



