Tables [dbo].[VendorModel]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:33 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_VendorModel_ModelID: ModelIDModelIDint4
False
Manufacturervarchar(100)100
False
Modelvarchar(100)100
False
NormalizedModelvarchar(100)100
False
IsSBSMatchbit1
True
((1))
Engine_Matchvarchar(100)100
True
Engine_Manuvarchar(100)100
True
FamilyUIDuniqueidentifier16
True
ToshibaModelIDint4
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_VendorModel_ModelID: ModelIDPK_VendorModel_ModelIDModelID
True
CREATE TABLE [dbo].[VendorModel]
(
[ModelID] [int] NOT NULL,
[Manufacturer] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Model] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NormalizedModel] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsSBSMatch] [bit] NULL CONSTRAINT [DF_VendorModel_IsSBSMatch] DEFAULT ((1)),
[Engine_Match] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Engine_Manu] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FamilyUID] [uniqueidentifier] NULL,
[ToshibaModelID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VendorModel] ADD CONSTRAINT [PK_VendorModel_ModelID] PRIMARY KEY CLUSTERED  ([ModelID]) ON [PRIMARY]
GO