Production.Product

Columns

• //

  ${escapify(column.description)}
  ProductID
  [int] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  Name
  [Name] NOT NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  ProductNumber
  [nvarchar](25) NOT NULL
• //

  ${escapify(column.description)}
  MakeFlag
  [Flag] NOT NULL DEFAULT ((1))

  //

  USER-DEFINED DATA TYPE

  [bit] NOT NULL
• //

  ${escapify(column.description)}
  FinishedGoodsFlag
  [Flag] NOT NULL DEFAULT ((1))

  //

  USER-DEFINED DATA TYPE

  [bit] NOT NULL
• //

  ${escapify(column.description)}
  Color
  [nvarchar](15) NULL
• //

  ${escapify(column.description)}
  SafetyStockLevel
  [smallint] NOT NULL

  //

  CONSTRAINT: Check constraint [SafetyStockLevel] > (0)

  ([SafetyStockLevel]>(0))
• //

  ${escapify(column.description)}
  ReorderPoint
  [smallint] NOT NULL

  //

  CONSTRAINT: Check constraint [ReorderPoint] > (0)

  ([ReorderPoint]>(0))
• //

  ${escapify(column.description)}
  StandardCost
  [money] NOT NULL

  //

  CONSTRAINT: Check constraint [SafetyStockLevel] > (0)

  ([StandardCost]>=(0.00))
• //

  ${escapify(column.description)}
  ListPrice
  [money] NOT NULL

  //

  CONSTRAINT: Check constraint [ListPrice] >= (0.00)

  ([ListPrice]>=(0.00))
• //

  ${escapify(column.description)}
  Size
  [nvarchar](5) NULL
• //

  ${escapify(column.description)}
  SizeUnitMeasureCode
  [nchar](3) NULL
• //

  ${escapify(column.description)}
  WeightUnitMeasureCode
  [nchar](3) NULL
• //

  ${escapify(column.description)}
  Weight
  [decimal](8, 2) NULL

  //

  CONSTRAINT: Check constraint [Weight] > (0.00)

  ([Weight]>(0.00))
• //

  ${escapify(column.description)}
  DaysToManufacture
  [int] NOT NULL

  //

  CONSTRAINT: Check constraint [DaysToManufacture] >= (0)

  ([DaysToManufacture]>=(0))
• //

  ${escapify(column.description)}
  ProductLine
  [nchar](2) NULL

  //

  CONSTRAINT: Check constraint [ProductLine]='r' OR [ProductLine]='m' OR [ProductLine]='t' OR [ProductLine]='s' OR [ProductLine]='R' OR [ProductLine]='M' OR [ProductLine]='T' OR [ProductLine]='S' OR [ProductLine] IS NULL

  (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL)
• //

  ${escapify(column.description)}
  Class
  [nchar](2) NULL

  //

  CONSTRAINT: Check constraint [Class]='h' OR [Class]='m' OR [Class]='l' OR [Class]='H' OR [Class]='M' OR [Class]='L' OR [Class] IS NULL

  (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL)
• //

  ${escapify(column.description)}
  Style
  [nchar](2) NULL

  //

  CONSTRAINT: Check constraint [Style]='u' OR [Style]='m' OR [Style]='w' OR [Style]='U' OR [Style]='M' OR [Style]='W' OR [Style] IS NULL

  (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL)
• //

  ${escapify(column.description)}
  ProductSubcategoryID
  [int] NULL
• //

  ${escapify(column.description)}
  ProductModelID
  [int] NULL
• //

  ${escapify(column.description)}
  SellStartDate
  [datetime] NOT NULL
• //

  ${escapify(column.description)}
  SellEndDate
  [datetime] NULL
• //

  ${escapify(column.description)}
  DiscontinuedDate
  [datetime] NULL
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_Product_ProductID
  UNIQUE CLUSTERED
  ProductID
• //

  Unique nonclustered index.
  AK_Product_ProductNumber
  UNIQUE NONCLUSTERED
  ProductNumber
• //

  Unique nonclustered index.
  AK_Product_Name
  UNIQUE NONCLUSTERED
  Name
• //

  Unique nonclustered index. Used to support replication samples.
  AK_Product_rowguid
  UNIQUE NONCLUSTERED
  rowguid

Foreign Keys

• //

  Foreign key constraint referencing ProductModel.ProductModelID.
  FK_Product_ProductModel_ProductModelID
  Production.ProductModel
  ProductModelID ⥱ ProductModelID
• //

  Foreign key constraint referencing ProductSubcategory.ProductSubcategoryID.
  FK_Product_ProductSubcategory_ProductSubcategoryID
  Production.ProductSubcategory
  ProductSubcategoryID ⥱ ProductSubcategoryID
• //

  Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
  FK_Product_UnitMeasure_SizeUnitMeasureCode
  Production.UnitMeasure
  SizeUnitMeasureCode ⥱ UnitMeasureCode
• //

  Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
  FK_Product_UnitMeasure_WeightUnitMeasureCode
  Production.UnitMeasure
  WeightUnitMeasureCode ⥱ UnitMeasureCode

Check Constraints

• //

  Check constraint [SellEndDate] >= [SellStartDate] OR [SellEndDate] IS NULL
  CK_Product_SellEndDate
  ([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL)

Sample Data