CREATE TABLE [dbo].[TCOSupplyCartridgePricelist]
(
[TCOValueSetID] [int] NOT NULL,
[PriceListID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOSupplyCartridgePricelist] ADD CONSTRAINT [PK_TCOSupplyCartridgePricelist_TCOValueSetID_PriceListID] PRIMARY KEY CLUSTERED ([TCOValueSetID], [PriceListID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOSupplyCartridgePricelist] ADD CONSTRAINT [FK_TCOSupplyCartridgePricelist_PriceListID_TCOValueSet_ID] FOREIGN KEY ([PriceListID]) REFERENCES [dbo].[TCOValueSet] ([ID])
GO
ALTER TABLE [dbo].[TCOSupplyCartridgePricelist] ADD CONSTRAINT [FK_TCOSupplyCartridgePricelist_TCOValueSetID_TCOSupply_TCOValueSetID] FOREIGN KEY ([TCOValueSetID]) REFERENCES [dbo].[TCOSupply] ([TCOValueSetID]) ON DELETE CASCADE ON UPDATE CASCADE
GO