Tables [dbo].[RPPres_ICModelsToRPPresModelTypes]
PropertyValue
HeapTrue
Row Count (~)0
Created12:58:43 AM Thursday, March 21, 2019
Last Modified1:13:59 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
MapIDint4
False
1 - 1
Foreign Keys FK_RPPres_ICModelsToRPPresModelTypes_ModelID_ICModels: [dbo].[ICModels].ModelIDModelIDint4
False
Foreign Keys FK_RPPres_ICModelsToRPPresModelTypes_ModelTypeID_RPPres_ModelTypes: [dbo].[RPPres_ModelTypes].ModelTypeIDModelTypeIDint4
True
NameColumns
FK_RPPres_ICModelsToRPPresModelTypes_ModelID_ICModelsModelID->[dbo].[ICModels].[ModelID]
FK_RPPres_ICModelsToRPPresModelTypes_ModelTypeID_RPPres_ModelTypesModelTypeID->[dbo].[RPPres_ModelTypes].[ModelTypeID]
CREATE TABLE [dbo].[RPPres_ICModelsToRPPresModelTypes]
(
[MapID] [int] NOT NULL IDENTITY(1, 1),
[ModelID] [int] NOT NULL,
[ModelTypeID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPPres_ICModelsToRPPresModelTypes] ADD CONSTRAINT [FK_RPPres_ICModelsToRPPresModelTypes_ModelID_ICModels] FOREIGN KEY ([ModelID]) REFERENCES [dbo].[ICModels] ([ModelID])
GO
ALTER TABLE [dbo].[RPPres_ICModelsToRPPresModelTypes] ADD CONSTRAINT [FK_RPPres_ICModelsToRPPresModelTypes_ModelTypeID_RPPres_ModelTypes] FOREIGN KEY ([ModelTypeID]) REFERENCES [dbo].[RPPres_ModelTypes] ([ModelTypeID])
GO