Samuele E. Locatelli
13 lines
456 B
SQL
13 lines
456 B
SQL
CREATE TABLE [ext].[DiesRaw] (
|
|
[CodDies] NVARCHAR (50) NOT NULL,
|
|
[HoleNum] INT NOT NULL,
|
|
[CodItem] NVARCHAR (50) NOT NULL,
|
|
[CodDiesGroup] NVARCHAR (50) NOT NULL,
|
|
[Price] DECIMAL (9, 3) NOT NULL,
|
|
[ExpLife] DECIMAL (9, 2) NOT NULL,
|
|
[ActLife] DECIMAL (9, 2) NOT NULL,
|
|
[Active] INT NOT NULL,
|
|
CONSTRAINT [PK_DiesDet] PRIMARY KEY CLUSTERED ([CodDies] ASC)
|
|
);
|
|
|