CREATE TABLE [dbo].[SCQualificationCodeModelDetails]
(
[DetailID] [int] NOT NULL IDENTITY(1, 1),
[QualificationCodeID] [int] NOT NULL,
[ModelID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQualificationCodeModelDetails] ADD CONSTRAINT [PK__SCQualif__135C314D5AE13316] PRIMARY KEY CLUSTERED ([DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQualificationCodeModelDetails] ADD CONSTRAINT [FK_SCQualificationCodeModelDetails_ModelID_ICModels] FOREIGN KEY ([ModelID]) REFERENCES [dbo].[ICModels] ([ModelID])
GO
ALTER TABLE [dbo].[SCQualificationCodeModelDetails] ADD CONSTRAINT [FK_SCQualificationCodeModelDetails_QualificationCodeID_SCQualificationCodes] FOREIGN KEY ([QualificationCodeID]) REFERENCES [dbo].[SCQualificationCodes] ([QualificationCodeID])
GO