Tables [dbo].[RTFeatureOptions_TechnicianWarehouses]
PropertyValue
HeapTrue
Row Count (~)0
Created12:58:54 AM Thursday, March 21, 2019
Last Modified1:14:08 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Foreign Keys FK_RTFeatureOptions_TechnicianWarehouses_TechnicianID_SCTechnicians: [dbo].[SCTechnicians].TechnicianIDTechnicianIDint4
True
Foreign Keys FK_RTFeatureOptions_TechnicianWarehouses_WarehouseID_ICWarehouses: [dbo].[ICWarehouses].WarehouseIDWarehouseIDint4
True
NameColumns
FK_RTFeatureOptions_TechnicianWarehouses_TechnicianID_SCTechniciansTechnicianID->[dbo].[SCTechnicians].[TechnicianID]
FK_RTFeatureOptions_TechnicianWarehouses_WarehouseID_ICWarehousesWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
CREATE TABLE [dbo].[RTFeatureOptions_TechnicianWarehouses]
(
[TechnicianID] [int] NULL,
[WarehouseID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RTFeatureOptions_TechnicianWarehouses] ADD CONSTRAINT [FK_RTFeatureOptions_TechnicianWarehouses_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO
ALTER TABLE [dbo].[RTFeatureOptions_TechnicianWarehouses] ADD CONSTRAINT [FK_RTFeatureOptions_TechnicianWarehouses_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO