Samuele Locatelli
14 lines
556 B
SQL
14 lines
556 B
SQL
CREATE TABLE [RilPro].[StampoArticolo] (
|
|
[CodStampo] NVARCHAR (8) NOT NULL,
|
|
[InizioValidita] DATETIME NOT NULL,
|
|
[ProgFigure] NUMERIC (7) NOT NULL,
|
|
[FineValidita] DATETIME NULL,
|
|
[NumCommessa] NVARCHAR (20) NULL,
|
|
[NumFigure] NUMERIC (7) NULL,
|
|
[CodCliente] NVARCHAR (6) NOT NULL,
|
|
[CodArticolo] NVARCHAR (6) NOT NULL,
|
|
[Particolare] NVARCHAR (15) NOT NULL,
|
|
CONSTRAINT [PK_StampoArticolo] PRIMARY KEY CLUSTERED ([CodStampo] ASC, [InizioValidita] ASC, [ProgFigure] ASC)
|
|
);
|
|
|