Production.Product

Table: 'Production.Product'

25 fields. 368 bytes.

Products sold or used in the manfacturing of sold products.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ProductIDint identity int Not nullPrimary key for Product records. 
NameName nvarchar(50) Not nullName of the product. 
ProductNumbernvarchar25  Not nullUnique product identification number. 
MakeFlagFlag bit(1)Not null0 = Product is purchased, 1 = Product is manufactured in-house. 
FinishedGoodsFlagFlag bit(1)Not null0 = Product is not a salable item. 1 = Product is salable. 
Colornvarchar15  NullProduct color. 
SafetyStockLevelsmallint   Not nullMinimum inventory quantity. ([SafetyStockLevel]>(0))
ReorderPointsmallint   Not nullInventory level that triggers a purchase order or work order. ([ReorderPoint]>(0))
StandardCostmoney19,4decimal(19,4) Not nullStandard cost of the product.([StandardCost]>=(0.00))
ListPricemoney19,4decimal(19,4) Not nullSelling price.([ListPrice]>=(0.00))
Sizenvarchar5  NullProduct size. 
SizeUnitMeasureCodenchar3  NullUnit of measure for Size column. 
WeightUnitMeasureCodenchar3  NullUnit of measure for Weight column. 
Weightdecimal8,2  NullProduct weight.([Weight]>(0.00))
DaysToManufactureint   Not nullNumber of days required to manufacture the product.([DaysToManufacture]>=(0))
ProductLinenchar2  NullR = Road, M = Mountain, T = Touring, S = Standard(upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL)
Classnchar2  NullH = High, M = Medium, L = Low(upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL)
Stylenchar2  NullW = Womens, M = Mens, U = Universal(upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL)
ProductSubcategoryIDint   NullProduct is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.  
ProductModelIDint   NullProduct is a member of this product model. Foreign key to ProductModel.ProductModelID. 
SellStartDatedatetime   Not nullDate the product was available for sale. 
SellEndDatedatetime   NullDate the product was no longer available for sale. 
DiscontinuedDatedatetime   NullDate the product was discontinued. 
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.Product'

Primary Key NameField Name
PK_Product_ProductIDProductID

Foreign keys for table 'Production.Product', 4 items

ForeignPrimaryKey Name
Product.ProductModelIDProductModel.ProductModelIDFK_Product_ProductModel_ProductModelID
Product.ProductSubcategoryIDProductSubcategory.ProductSubcategoryIDFK_Product_ProductSubcategory_ProductSubcategoryID
Product.SizeUnitMeasureCodeUnitMeasure.UnitMeasureCodeFK_Product_UnitMeasure_SizeUnitMeasureCode
Product.WeightUnitMeasureCodeUnitMeasure.UnitMeasureCodeFK_Product_UnitMeasure_WeightUnitMeasureCode

Indexes for table 'Production.Product', 4 items

Index NameDescriptionClusteredUniqueFields
PK_Product_ProductIDClustered index created by a primary key constraint.YesYesProductID
AK_Product_NameUnique nonclustered index.NoYesName
AK_Product_ProductNumberUnique nonclustered index.NoYesProductNumber
AK_Product_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid

Triggers for table 'Production.Product', 1 item

NameDescriptionTypeEnabled
uProductAFTER UPDATE trigger setting the ModifiedDate column in the Product table to the current date.after Update Yes

Dependencies for table 'Production.Product', 17 items

Object NameTypeField Name
dbo.ufnGetProductDealerPricescalar functionN/A
dbo.ufnGetProductListPricescalar functionN/A
dbo.ufnGetProductStandardCostscalar functionN/A
dbo.uspGetBillOfMaterialsstored procedureN/A
dbo.uspGetWhereUsedProductIDstored procedureN/A
Production.CK_Product_Classcheck cnsN/A
Production.CK_Product_DaysToManufacturecheck cnsN/A
Production.CK_Product_ListPricecheck cnsN/A
Production.CK_Product_ProductLinecheck cnsN/A
Production.CK_Product_ReorderPointcheck cnsN/A
Production.CK_Product_SafetyStockLevelcheck cnsN/A
Production.CK_Product_SellEndDatecheck cnsN/A
Production.CK_Product_StandardCostcheck cnsN/A
Production.CK_Product_Stylecheck cnsN/A
Production.CK_Product_Weightcheck cnsN/A
Production.uProducttriggerN/A
Production.vProductAndDescriptionviewN/A