CHECK Table Level|([Class]='h' OR [Class]='m' OR [Class]='l' OR [Class]='H' OR [Class]='M' OR [Class]='L' OR [Class] IS NULL)
CHECK Table Level|([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)|
CHECK Table Level|([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL)
CHECK Table Level|([Style]='u' OR [Style]='m' OR [Style]='w' OR [Style]='U' OR [Style]='M' OR [Style]='W' OR [Style] IS NULL)
DEFAULT on column FinishedGoodsFlag|((1))
DEFAULT on column MakeFlag|((1))
DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
FOREIGN KEY|ProductModelID
|REFERENCES AdventureWorks.Production.ProductModel (ProductModelID)
FOREIGN KEY|ProductSubcategoryID
|REFERENCES AdventureWorks.Production.ProductSubcategory (ProductSubcategoryID)
FOREIGN KEY|SizeUnitMeasureCode
|REFERENCES AdventureWorks.Production.UnitMeasure (UnitMeasureCode)
FOREIGN KEY|WeightUnitMeasureCode
|REFERENCES AdventureWorks.Production.UnitMeasure (UnitMeasureCode)
PRIMARY KEY (clustered)|ProductID