CREATE TABLE [dbo].[OEMPartsInfo]
(
[SupplyID] [int] NOT NULL IDENTITY(1, 1),
[SupplyManufacturer] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OEMPartNo] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Region] [int] NOT NULL,
[Voltage] [int] NULL,
[NormalizedPartNo] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ConsumableTypeID] [int] NOT NULL,
[VolumeType] [smallint] NULL CONSTRAINT [DF_OEMPartsInfo_VolumeType] DEFAULT ((0)),
[ConsumableYield] [int] NOT NULL,
[CoverageFactor] [float] NULL,
[ImportDate] [datetime] NOT NULL CONSTRAINT [DF_OEMPartsInfo_ImportDate] DEFAULT (getdate()),
[LastUpdateDate] [datetime] NOT NULL CONSTRAINT [DF_OEMPartsInfo_LastUpdateDate] DEFAULT (getdate()),
[UserIntervention] [smallint] NULL,
[Remarks] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SBSID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OEMPartsInfo] ADD CONSTRAINT [PK_OEMPartsInfo_SupplyID] PRIMARY KEY CLUSTERED ([SupplyID]) ON [PRIMARY]
GO