Tables [dbo].[SCHReportRepairCodes]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:59:19 AM Thursday, March 21, 2019
Last Modified1:15:06 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Foreign Keys FK_SCHReportRepairCodes_ReportID_SCHReports: [dbo].[SCHReports].ReportIDReportIDint4
False
Foreign Keys FK_SCHReportRepairCodes_RepairCodeID_SCRepairCodes: [dbo].[SCRepairCodes].RepairCodeIDRepairCodeIDint4
True
RepairCodevarchar(255)255
True
NameColumns
FK_SCHReportRepairCodes_RepairCodeID_SCRepairCodesRepairCodeID->[dbo].[SCRepairCodes].[RepairCodeID]
FK_SCHReportRepairCodes_ReportID_SCHReportsReportID->[dbo].[SCHReports].[ReportID]
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