CREATE TABLE [dbo].[Odette_storico] (
    [DataOraDelete] DATETIME      NOT NULL,
    [CampoUDC]      NVARCHAR (50) NOT NULL,
    [Campo1_1]      NVARCHAR (50) NOT NULL,
    [Campo1_2]      NVARCHAR (50) NOT NULL,
    [Campo1_3]      NVARCHAR (50) NOT NULL,
    [Campo1_4]      NVARCHAR (50) NOT NULL,
    [Campo1_5]      NVARCHAR (50) NOT NULL,
    [Campo2_1]      NVARCHAR (50) NOT NULL,
    [Campo2_2]      NVARCHAR (50) NOT NULL,
    [Campo2_3]      NVARCHAR (50) NOT NULL,
    [Campo2_4]      NVARCHAR (50) NOT NULL,
    [Campo2_5]      NVARCHAR (50) NOT NULL,
    [Campo3_1]      NVARCHAR (50) NOT NULL,
    [Campo3_2]      NVARCHAR (50) NOT NULL,
    [Campo3_3]      NVARCHAR (50) NOT NULL,
    [Campo3_4]      NVARCHAR (50) NOT NULL,
    [Campo3_5]      NVARCHAR (50) NOT NULL,
    [Campo4_1]      NVARCHAR (50) NOT NULL,
    [Campo4_2]      NVARCHAR (50) NOT NULL,
    [Campo4_3]      NVARCHAR (50) NOT NULL,
    [Campo4_4]      NVARCHAR (50) NOT NULL,
    [Campo4_5]      NVARCHAR (50) NOT NULL,
    [Campo5_1]      NVARCHAR (50) NOT NULL,
    [Campo5_2]      NVARCHAR (50) NOT NULL,
    [Campo5_3]      NVARCHAR (50) NOT NULL,
    [Campo5_4]      NVARCHAR (50) NOT NULL,
    [Campo5_5]      NVARCHAR (50) NOT NULL,
    [Campo6_1]      NVARCHAR (50) NOT NULL,
    [Campo6_2]      NVARCHAR (50) NOT NULL,
    [Campo6_3]      NVARCHAR (50) NOT NULL,
    [Campo6_4]      NVARCHAR (50) NOT NULL,
    [Campo6_5]      NVARCHAR (50) NOT NULL,
    [Campo7_1]      NVARCHAR (50) NOT NULL,
    [Campo7_2]      NVARCHAR (50) NOT NULL,
    [Campo7_3]      NVARCHAR (50) NOT NULL,
    [Campo7_4]      NVARCHAR (50) NOT NULL,
    [Campo7_5]      NVARCHAR (50) NOT NULL,
    [Campo8_1]      NVARCHAR (50) NOT NULL,
    [Campo8_2]      NVARCHAR (50) NOT NULL,
    [Campo8_3]      NVARCHAR (50) NOT NULL,
    [Campo8_4]      NVARCHAR (50) NOT NULL,
    [Campo8_5]      NVARCHAR (50) NOT NULL,
    [Campo9_1]      NVARCHAR (50) NOT NULL,
    [Campo9_2]      NVARCHAR (50) NOT NULL,
    [Campo9_3]      NVARCHAR (50) NOT NULL,
    [Campo9_4]      NVARCHAR (50) NOT NULL,
    [Campo9_5]      NVARCHAR (50) NOT NULL,
    [Campo10_1]     NVARCHAR (50) NOT NULL,
    [Campo10_2]     NVARCHAR (50) NOT NULL,
    [Campo10_3]     NVARCHAR (50) NOT NULL,
    [Campo10_4]     NVARCHAR (50) NOT NULL,
    [Campo10_5]     NVARCHAR (50) NOT NULL,
    [Campo11_1_1]   NVARCHAR (50) NOT NULL,
    [Campo11_1_2]   NVARCHAR (50) NOT NULL,
    [Campo11_1_3]   NVARCHAR (50) NOT NULL,
    [Campo11_1_4]   NVARCHAR (50) NOT NULL,
    [Campo11_1_5]   NVARCHAR (50) NOT NULL,
    [Campo11_2_1]   NVARCHAR (50) NOT NULL,
    [Campo11_2_2]   NVARCHAR (50) NOT NULL,
    [Campo11_2_3]   NVARCHAR (50) NOT NULL,
    [Campo11_2_4]   NVARCHAR (50) NOT NULL,
    [Campo11_2_5]   NVARCHAR (50) NOT NULL,
    [Campo12_1]     NVARCHAR (50) NOT NULL,
    [Campo12_2]     NVARCHAR (50) NOT NULL,
    [Campo12_3]     NVARCHAR (50) NOT NULL,
    [Campo12_4]     NVARCHAR (50) NOT NULL,
    [Campo12_5]     NVARCHAR (50) NOT NULL,
    [Campo13_1]     NVARCHAR (50) NOT NULL,
    [Campo13_2]     NVARCHAR (50) NOT NULL,
    [Campo13_3]     NVARCHAR (50) NOT NULL,
    [Campo13_4]     NVARCHAR (50) NOT NULL,
    [Campo13_5]     NVARCHAR (50) NOT NULL,
    [Campo14_1]     NVARCHAR (50) NOT NULL,
    [Campo14_2]     NVARCHAR (50) NOT NULL,
    [Campo14_3]     NVARCHAR (50) NOT NULL,
    [Campo14_4]     NVARCHAR (50) NOT NULL,
    [Campo14_5]     NVARCHAR (50) NOT NULL,
    [Campo15_1]     NVARCHAR (50) NOT NULL,
    [Campo15_2]     NVARCHAR (50) NOT NULL,
    [Campo15_3]     NVARCHAR (50) NOT NULL,
    [Campo15_4]     NVARCHAR (50) NOT NULL,
    [Campo15_5]     NVARCHAR (50) NOT NULL,
    [Campo16_1]     NVARCHAR (50) NOT NULL,
    [Campo16_2]     NVARCHAR (50) NOT NULL,
    [Campo16_3]     NVARCHAR (50) NOT NULL,
    [Campo16_4]     NVARCHAR (50) NOT NULL,
    [Campo16_5]     NVARCHAR (50) NOT NULL,
    [StatoOk]       BIT           NOT NULL,
    [CodCS]         NCHAR (2)     NOT NULL,
    [CodMag]        NVARCHAR (2)  CONSTRAINT [DF_Odette_storico_CodMag] DEFAULT ('') NOT NULL,
    [GrpBolla]      NVARCHAR (1)  CONSTRAINT [DF_Odette_storico_GrpBolla] DEFAULT ('') NOT NULL,
    [DataBolla]     NUMERIC (8)   CONSTRAINT [DF_Odette_storico_DataBolla] DEFAULT ((0)) NOT NULL,
    [NumBolla]      NUMERIC (6)   CONSTRAINT [DF_Odette_storico_NumBolla] DEFAULT ((0)) NOT NULL,
    [Particolare]   NVARCHAR (15) CONSTRAINT [DF_Odette_storico_Particolare] DEFAULT ('') NOT NULL,
    [CodLista]      NVARCHAR (12) CONSTRAINT [DF_Odette_storico_CodLista] DEFAULT ('') NOT NULL
);


GO
CREATE NONCLUSTERED INDEX [i_UDC]
    ON [dbo].[Odette_storico]([CampoUDC] ASC);

