Samuele E. Locatelli
15 lines
1.0 KiB
SQL
15 lines
1.0 KiB
SQL
CREATE TABLE [som_ita].[tmp_ImportRic_B] (
|
|
[GrpFun] NVARCHAR (250) CONSTRAINT [DF_tmp_ImportRic_B_NomeCostruttore] DEFAULT ('') NOT NULL,
|
|
[FamTec] NVARCHAR (250) CONSTRAINT [DF_tmp_ImportRic_B_CodCostruttore] DEFAULT ('') NOT NULL,
|
|
[TipoMacc] NVARCHAR (250) CONSTRAINT [DF_tmp_ImportRic_B_Destinazione] DEFAULT ('') NOT NULL,
|
|
[Descrizione] NVARCHAR (250) CONSTRAINT [DF_tmp_ImportRic_B_Descrizione] DEFAULT ('') NOT NULL,
|
|
[CodSomaschini] NVARCHAR (50) CONSTRAINT [DF_tmp_ImportRic_B_CodSomaschini] DEFAULT ('') NOT NULL,
|
|
[QtaMin] INT NOT NULL,
|
|
[QtaLotto] INT NOT NULL,
|
|
[Giacenza] INT CONSTRAINT [DF_tmp_ImportRic_B_Giacenza] DEFAULT ((0)) NOT NULL,
|
|
[Ubicazione] NVARCHAR (250) CONSTRAINT [DF_tmp_ImportRic_B_Descrizione1] DEFAULT ('') NOT NULL,
|
|
[Nota_1] NVARCHAR (250) CONSTRAINT [DF_tmp_ImportRic_B_Descrizione1_1] DEFAULT ('') NOT NULL,
|
|
[Nota_2] NVARCHAR (250) CONSTRAINT [DF_tmp_ImportRic_B_Nota_11] DEFAULT ('') NOT NULL
|
|
);
|
|
|