CREATE TABLE [dbo].[OEMPartsPrices]
(
[SupplyID] [int] NOT NULL,
[Region] [int] NOT NULL,
[CurrencyID] [smallint] NOT NULL CONSTRAINT [DF_OEMPartsPrices_CurrencyID] DEFAULT ((1033)),
[SuggestedRetailPrice] [float] NOT NULL,
[LastUpdateDate] [datetime] NULL,
[LocalizedPartDescription] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserIntervention] [smallint] NULL,
[Remarks] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SBSID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OEMPartsPrices] ADD CONSTRAINT [PK_OEMPartsPrices_SupplyID_Region_CurrencyID] PRIMARY KEY CLUSTERED ([SupplyID], [Region], [CurrencyID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OEMPartsPrices] ADD CONSTRAINT [FK_OEMPartsPrices_SupplyID_OEMPartsInfo_SupplyID] FOREIGN KEY ([SupplyID]) REFERENCES [dbo].[OEMPartsInfo] ([SupplyID])
GO