BigLitho/Large.Lito.Database/Make3_Treko3D/Docs/SQL Scripts/Technology.txt

11 lines
581 B
Plaintext

CREATE TABLE [dbo].[Technology] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[TechnologyName] NVARCHAR (50) DEFAULT ('Treko') NOT NULL,
[ImagePath] NVARCHAR (MAX) DEFAULT ('') NOT NULL,
[AnglesPath] NVARCHAR (MAX) DEFAULT ('') NOT NULL,
[Step] FLOAT (53) DEFAULT ((0)) NOT NULL,
[Radius] FLOAT (53) DEFAULT ((0)) NOT NULL,
[ArcWidth] INT DEFAULT ((0)) NOT NULL,
CONSTRAINT [PK_Technology] PRIMARY KEY CLUSTERED ([Id] ASC),
FOREIGN KEY ([Id]) REFERENCES [dbo].[Layers] ([Id])
);