Samuele Locatelli
15 lines
798 B
Transact-SQL
15 lines
798 B
Transact-SQL
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)
|
|
);
|
|
|
|
|
|
|