CREATE TABLE [dbo].[SCQualificationCodeCallTypeDetails]
(
[DetailID] [int] NOT NULL IDENTITY(1, 1),
[QualificationCodeID] [int] NOT NULL,
[CallTypeID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQualificationCodeCallTypeDetails] ADD CONSTRAINT [PK__SCQualif__135C314DE40C0B12] PRIMARY KEY CLUSTERED ([DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQualificationCodeCallTypeDetails] ADD CONSTRAINT [FK_SCQualificationCodeCallTypeDetails_CallTypeID_SCCallTypes] FOREIGN KEY ([CallTypeID]) REFERENCES [dbo].[SCCallTypes] ([CallTypeID])
GO
ALTER TABLE [dbo].[SCQualificationCodeCallTypeDetails] ADD CONSTRAINT [FK_SCQualificationCodeCallTypeDetails_QualificationCodeID_SCQualificationCodes] FOREIGN KEY ([QualificationCodeID]) REFERENCES [dbo].[SCQualificationCodes] ([QualificationCodeID])
GO