Tables [dbo].[OEMPartsInfo]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:35 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_OEMPartsInfo_SupplyID: SupplyIDSupplyIDint4
False
1 - 1
SupplyManufacturervarchar(100)100
False
OEMPartNovarchar(100)100
False
Regionint4
False
Voltageint4
True
NormalizedPartNovarchar(100)100
False
ConsumableTypeIDint4
False
VolumeTypesmallint2
True
((0))
ConsumableYieldint4
False
CoverageFactorfloat8
True
ImportDatedatetime8
False
(getdate())
LastUpdateDatedatetime8
False
(getdate())
UserInterventionsmallint2
True
Remarksnvarchar(100)200
True
SBSIDint4
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_OEMPartsInfo_SupplyID: SupplyIDPK_OEMPartsInfo_SupplyIDSupplyID
True
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