CREATE TABLE [dbo].[SAConfigVolumeMapDevices]
(
[ConfigVolumeMapDeviceID] [int] NOT NULL IDENTITY(1, 1),
[ConfigQuoteID] [int] NULL,
[ConfigPrinterID] [int] NULL,
[DetailID] [int] NULL,
[ConfigQuoteDetailID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigVolumeMapDevices] ADD CONSTRAINT [PK_SAConfigVolumeMapDevices] PRIMARY KEY CLUSTERED ([ConfigVolumeMapDeviceID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigVolumeMapDevices] ADD CONSTRAINT [FK_SAConfigVolumeMapDevices_ConfigPrinterID_SAConfigPrinterDetails] FOREIGN KEY ([ConfigPrinterID], [DetailID]) REFERENCES [dbo].[SAConfigPrinterDetails] ([ConfigPrinterID], [DetailID])
GO
ALTER TABLE [dbo].[SAConfigVolumeMapDevices] ADD CONSTRAINT [FK_SAConfigVolumeMapDevices_ConfigQuoteDetailID_SAConfigQuoteDetails] FOREIGN KEY ([ConfigQuoteDetailID]) REFERENCES [dbo].[SAConfigQuoteDetails] ([ConfigQuoteDetailID])
GO
ALTER TABLE [dbo].[SAConfigVolumeMapDevices] ADD CONSTRAINT [FK_SAConfigVolumeMapDevices_ConfigQuoteID_SAConfigQuotes] FOREIGN KEY ([ConfigQuoteID]) REFERENCES [dbo].[SAConfigQuotes] ([ConfigQuoteID])
GO