CREATE TABLE dbo.Items (
  Id INT IDENTITY,
  OperationId INT NOT NULL,
  CONSTRAINT PK_Items_Id PRIMARY KEY CLUSTERED (Id)
) ON [PRIMARY]
GO

ALTER TABLE dbo.Items
ADD CONSTRAINT FK_Items_Operations_Id FOREIGN KEY (OperationId) REFERENCES dbo.Operations (Id)
GO

CREATE TABLE dbo.Assemblies (
  Id INT IDENTITY,
  ParentId INT NULL,
  CONSTRAINT PK_Assemblies_Id PRIMARY KEY CLUSTERED (Id)
) ON [PRIMARY]
GO

ALTER TABLE dbo.Assemblies
ADD CONSTRAINT FK_Assemblies_Assemblies_Id FOREIGN KEY (ParentId) REFERENCES dbo.Assemblies (Id)
GO

CREATE TABLE dbo.tempTable (
  Position VARCHAR(50) NOT NULL,
  Overhang DECIMAL NOT NULL,
  Runtime DECIMAL NOT NULL,
  AmountCuttingEdge INT NULL,
  AmountPlates INT NULL,
  Durability DECIMAL NOT NULL,
  Note VARCHAR(50) NULL
) ON [PRIMARY]
GO