CREATE TABLE [dbo].[SCHReportRepairCodes]
(
[ReportID] [int] NOT NULL,
[RepairCodeID] [int] NULL,
[RepairCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCHReportRepairCodes] ADD CONSTRAINT [FK_SCHReportRepairCodes_RepairCodeID_SCRepairCodes] FOREIGN KEY ([RepairCodeID]) REFERENCES [dbo].[SCRepairCodes] ([RepairCodeID])
GO
ALTER TABLE [dbo].[SCHReportRepairCodes] ADD CONSTRAINT [FK_SCHReportRepairCodes_ReportID_SCHReports] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[SCHReports] ([ReportID])
GO