CREATE TABLE [dbo].[TCODeliveryAndSetup]
(
[TCOValueSetID] [int] NOT NULL,
[Shipping] [decimal] (12, 5) NULL,
[Installation] [decimal] (12, 5) NULL,
[Customization] [decimal] (12, 5) NULL,
[NetworkConnection] [decimal] (12, 5) NULL,
[Misc1Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc1Cost] [decimal] (12, 5) NULL,
[Misc2Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc2Cost] [decimal] (12, 5) NULL,
[Misc3Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc3Cost] [decimal] (12, 5) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCODeliveryAndSetup] ADD CONSTRAINT [PK_TCODeliveryAndSetup_TCOValueSetID] PRIMARY KEY CLUSTERED ([TCOValueSetID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCODeliveryAndSetup] ADD CONSTRAINT [FK_TCODeliveryAndSetup_TCOValueSetID_TCOValueSet_ID] FOREIGN KEY ([TCOValueSetID]) REFERENCES [dbo].[TCOValueSet] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO