Torna al Thread
CREATE TABLE [dbo].[VOLUMI](
[ID_VOLUME] [bigint] IDENTITY(1,1) NOT NULL,
[ID_LETTURA] [bigint] NULL,
[DataOraCreazione] [datetime] NULL CONSTRAINT [DF_VOLUMI_DataOraCreazione] DEFAULT (getdate()),
[DataOraRif] [datetime] NULL CONSTRAINT [DF_VOLUMI_DataOraUTC] DEFAULT ('01/01/2001 00:00:00'),
[VolumeCont] [int] NULL CONSTRAINT [DF_VOLUMI_Cont] DEFAULT (0),
[VolumeCorr] [int] NULL CONSTRAINT [DF_VOLUMI_Corr] DEFAULT (0),
[Legale] [bit] NULL CONSTRAINT [DF_VOLUMI_CorrQlf] DEFAULT (0),
[RegistroEventiPieno] [bit] NULL CONSTRAINT [DF_VOLUMI_RegistroEventiPieno] DEFAULT (0),
[Invalida] [bit] NULL CONSTRAINT [DF_VOLUMI_Vef] DEFAULT (0),
[Trucco] [bit] NULL CONSTRAINT [DF_VOLUMI_TRUCCO] DEFAULT ((0)),
CONSTRAINT [PK_VOLUMI] PRIMARY KEY CLUSTERED
(
[ID_VOLUME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]