CREATE TABLE [dbo].[OEMPartsCompatibility]
(
[Manufacturer] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Model] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SupplyID] [int] NOT NULL,
[NormalizedModel] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ModelID] [int] NULL,
[UserIntervention] [smallint] NULL,
[Remarks] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SBSID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OEMPartsCompatibility] ADD CONSTRAINT [PK_OEMPartsCompatibility_Manufacturer_Model_SupplyID] PRIMARY KEY CLUSTERED ([Manufacturer], [Model], [SupplyID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OEMPartsCompatibility] ADD CONSTRAINT [FK_OEMPartsCompatibility_ModelID_VendorModel_ModelID] FOREIGN KEY ([ModelID]) REFERENCES [dbo].[VendorModel] ([ModelID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[OEMPartsCompatibility] ADD CONSTRAINT [FK_OEMPartsCompatibility_SupplyID_OEMPartsInfo_SupplyID] FOREIGN KEY ([SupplyID]) REFERENCES [dbo].[OEMPartsInfo] ([SupplyID])
GO