CREATE TABLE [dbo].[SCTechnicianQualifications]
(
[TechnicianQualificationID] [int] NOT NULL IDENTITY(1, 1),
[TechnicianID] [int] NOT NULL,
[QualificationCodeID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCTechnicianQualifications] ADD CONSTRAINT [PK__SCTechni__C6EACAAE5443F38C] PRIMARY KEY CLUSTERED ([TechnicianQualificationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCTechnicianQualifications] ADD CONSTRAINT [FK_SCTechnicianQualifications_QualificationCodeID_SCQualificationCodes] FOREIGN KEY ([QualificationCodeID]) REFERENCES [dbo].[SCQualificationCodes] ([QualificationCodeID])
GO
ALTER TABLE [dbo].[SCTechnicianQualifications] ADD CONSTRAINT [FK_SCTechnicianQualifications_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO