CREATE TABLE [dbo].[RTFeatureOptions_AllowWHTransfers]
(
[TechnicianID] [int] NULL,
[WarehouseID] [int] NULL,
[BinID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RTFeatureOptions_AllowWHTransfers] ADD CONSTRAINT [CHK_AllowWHTransfers_WarehouseIDBinID] CHECK (([WarehouseID] IS NOT NULL AND [BinID] IS NULL OR [WarehouseID] IS NULL AND [BinID] IS NOT NULL))
GO
ALTER TABLE [dbo].[RTFeatureOptions_AllowWHTransfers] ADD CONSTRAINT [FK_RTFeatureOptions_AllowWHTransfers_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[RTFeatureOptions_AllowWHTransfers] ADD CONSTRAINT [FK_RTFeatureOptions_AllowWHTransfers_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO
ALTER TABLE [dbo].[RTFeatureOptions_AllowWHTransfers] ADD CONSTRAINT [FK_RTFeatureOptions_AllowWHTransfers_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO