CREATE TABLE [dbo].[TCOService]
(
[TCOValueSetID] [int] NOT NULL,
[Misc1Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc1ServiceMinutes] [int] NULL,
[Misc1Yield] [int] NULL,
[Misc2Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc2ServiceMinutes] [int] NULL,
[Misc2Yield] [int] NULL,
[Misc3Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc3ServiceMinutes] [int] NULL,
[Misc3Yield] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOService] ADD CONSTRAINT [PK_TCOService_TCOValueSetID] PRIMARY KEY CLUSTERED ([TCOValueSetID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOService] ADD CONSTRAINT [FK_TCOService_TCOValueSetID_TCOValueSet_ID] FOREIGN KEY ([TCOValueSetID]) REFERENCES [dbo].[TCOValueSet] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO