CREATE TABLE [dbo].[TCOAcquisitionPricelist]
(
[TCOValueSetID] [int] NOT NULL,
[PriceListID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOAcquisitionPricelist] ADD CONSTRAINT [PK_TCOAcquisitionPricelist_TCOValueSetID_PriceListID] PRIMARY KEY CLUSTERED ([TCOValueSetID], [PriceListID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOAcquisitionPricelist] ADD CONSTRAINT [FK_TCOAcquisitionPricelist_PriceListID_TCOValueSet_ID] FOREIGN KEY ([PriceListID]) REFERENCES [dbo].[TCOValueSet] ([ID])
GO
ALTER TABLE [dbo].[TCOAcquisitionPricelist] ADD CONSTRAINT [FK_TCOAcquisitionPricelist_TCOValueSetID_TCOAcquisition_TCOValueSetID] FOREIGN KEY ([TCOValueSetID]) REFERENCES [dbo].[TCOAcquisition] ([TCOValueSetID]) ON DELETE CASCADE ON UPDATE CASCADE
GO