Tables [dbo].[RTFeatureOptions_AllowWHTransfers]
PropertyValue
HeapTrue
Row Count (~)0
Created12:58:54 AM Thursday, March 21, 2019
Last Modified1:16:24 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Foreign Keys FK_RTFeatureOptions_AllowWHTransfers_TechnicianID_SCTechnicians: [dbo].[SCTechnicians].TechnicianIDTechnicianIDint4
True
Foreign Keys FK_RTFeatureOptions_AllowWHTransfers_WarehouseID_ICWarehouses: [dbo].[ICWarehouses].WarehouseIDWarehouseIDint4
True
Foreign Keys FK_RTFeatureOptions_AllowWHTransfers_BinID_ICBins: [dbo].[ICBins].BinIDBinIDint4
True
NameConstraint
CHK_AllowWHTransfers_WarehouseIDBinID([WarehouseID] IS NOT NULL AND [BinID] IS NULL OR [WarehouseID] IS NULL AND [BinID] IS NOT NULL)
NameColumns
FK_RTFeatureOptions_AllowWHTransfers_BinID_ICBinsBinID->[dbo].[ICBins].[BinID]
FK_RTFeatureOptions_AllowWHTransfers_TechnicianID_SCTechniciansTechnicianID->[dbo].[SCTechnicians].[TechnicianID]
FK_RTFeatureOptions_AllowWHTransfers_WarehouseID_ICWarehousesWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
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