Tables [dbo].[OEMPartsCompatibility]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:26 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_OEMPartsCompatibility_Manufacturer_Model_SupplyID: Manufacturer\Model\SupplyIDManufacturervarchar(100)100
False
Cluster Primary Key PK_OEMPartsCompatibility_Manufacturer_Model_SupplyID: Manufacturer\Model\SupplyIDModelvarchar(100)100
False
Cluster Primary Key PK_OEMPartsCompatibility_Manufacturer_Model_SupplyID: Manufacturer\Model\SupplyIDForeign Keys FK_OEMPartsCompatibility_SupplyID_OEMPartsInfo_SupplyID: [dbo].[OEMPartsInfo].SupplyIDSupplyIDint4
False
NormalizedModelvarchar(100)100
False
Foreign Keys FK_OEMPartsCompatibility_ModelID_VendorModel_ModelID: [dbo].[VendorModel].ModelIDModelIDint4
True
UserInterventionsmallint2
True
Remarksnvarchar(100)200
True
SBSIDint4
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_OEMPartsCompatibility_Manufacturer_Model_SupplyID: Manufacturer\Model\SupplyIDPK_OEMPartsCompatibility_Manufacturer_Model_SupplyIDManufacturer, Model, SupplyID
True
NameUpdateDeleteColumns
FK_OEMPartsCompatibility_ModelID_VendorModel_ModelIDCascadeCascadeModelID->[dbo].[VendorModel].[ModelID]
FK_OEMPartsCompatibility_SupplyID_OEMPartsInfo_SupplyIDSupplyID->[dbo].[OEMPartsInfo].[SupplyID]
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