Samuele Locatelli
37 lines
1.7 KiB
Transact-SQL
37 lines
1.7 KiB
Transact-SQL
CREATE TABLE [dbo].[StoricoCartellini] (
|
|
[IdxEv] INT IDENTITY (1, 1) NOT NULL,
|
|
[DataEv] DATETIME NOT NULL,
|
|
[CodEvento] NVARCHAR (10) NULL,
|
|
[ModDate] DATETIME NULL,
|
|
[UDC] NVARCHAR (50) NOT NULL,
|
|
[CodCS] NCHAR (2) NULL,
|
|
[CodCliente] NVARCHAR (6) NULL,
|
|
[RagSociale] NVARCHAR (35) NULL,
|
|
[Particolare] NVARCHAR (15) NULL,
|
|
[DescParticolare] NVARCHAR (30) NULL,
|
|
[DisegnoGrezzo] NVARCHAR (30) NULL,
|
|
[Esponente] NVARCHAR (6) NULL,
|
|
[CodImpianto] NVARCHAR (50) NULL,
|
|
[DescImpianto] NVARCHAR (50) NULL,
|
|
[CodStampo] NVARCHAR (8) NULL,
|
|
[Figura] NVARCHAR (4) NULL,
|
|
[DataFus] DATETIME NULL,
|
|
[TurnoFus] INT NULL,
|
|
[CodImballo] NVARCHAR (15) NULL,
|
|
[CodSoggetto] NCHAR (17) NULL,
|
|
[NumCont] INT NULL,
|
|
[Tara] FLOAT (53) NULL,
|
|
[Qta] DECIMAL (10, 2) NULL,
|
|
[CodStato] NVARCHAR (50) NULL,
|
|
[IdxPosizione] INT NULL,
|
|
[PesoTot] FLOAT (53) NULL,
|
|
[PesoCad] FLOAT (53) NULL,
|
|
[Note] NVARCHAR (500) NULL,
|
|
CONSTRAINT [PK_StoricoEventi] PRIMARY KEY CLUSTERED ([IdxEv] ASC) WITH (FILLFACTOR = 95)
|
|
);
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'NON MODIFICARE: nel codice si usano questi campi x chiamate...', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'StoricoCartellini', @level2type = N'COLUMN', @level2name = N'CodEvento';
|
|
|