Production.Product (table)

wikibot

Table

Production.Product

Column	Data Type	Nullable	Default	PK	Index
ProductID	int	not null		PK_Product_ProductID
Name	dbo.Name	not null			AK_Product_Name
ProductNumber	nvarchar(25)	not null			AK_Product_ProductNumber
MakeFlag	dbo.Flag	not null	((1))
FinishedGoodsFlag	dbo.Flag	not null	((1))
Color	nvarchar(15)	null
SafetyStockLevel	smallint	not null
ReorderPoint	smallint	not null
StandardCost	money	not null
ListPrice	money	not null
Size	nvarchar(5)	null
SizeUnitMeasureCode	nchar(3)	null
WeightUnitMeasureCode	nchar(3)	null
Weight	decimal(8, 2)	null
DaysToManufacture	int	not null
ProductLine	nchar(2)	null
Class	nchar(2)	null
Style	nchar(2)	null
ProductSubcategoryID	int	null
ProductModelID	int	null
SellStartDate	datetime	not null
SellEndDate	datetime	null
DiscontinuedDate	datetime	null
rowguid	uniqueidentifier	not null	(newid())		AK_Product_rowguid
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Production.ProductModel	ProductModelID	ProductModelID
Production.ProductSubcategory	ProductSubcategoryID	ProductSubcategoryID
Production.UnitMeasure	SizeUnitMeasureCode	UnitMeasureCode
Production.UnitMeasure	WeightUnitMeasureCode	UnitMeasureCode

Detail Table	Column	Referencing Column
Production.BillOfMaterials	ProductID	ComponentID
Production.BillOfMaterials	ProductID	ProductAssemblyID
Production.ProductCostHistory	ProductID	ProductID
Production.ProductDocument	ProductID	ProductID
Production.ProductInventory	ProductID	ProductID
Production.ProductListPriceHistory	ProductID	ProductID
Production.ProductProductPhoto	ProductID	ProductID
Production.ProductReview	ProductID	ProductID
Purchasing.ProductVendor	ProductID	ProductID
Purchasing.PurchaseOrderDetail	ProductID	ProductID
Sales.ShoppingCartItem	ProductID	ProductID
Sales.SpecialOfferProduct	ProductID	ProductID
Production.TransactionHistory	ProductID	ProductID
Production.WorkOrder	ProductID	ProductID