Product Table (AdventureWorks)
Contains the products sold or used in the manufacturing of sold products.
Product Table Definition
The Product table is contained in the Production schema.
Column |
Data type |
Nullability |
Description |
|---|---|---|---|
ProductID |
int |
Not null |
Primary key for Product rows. |
Name |
Name (user-defined type) nvarchar(50) |
Not null |
Name of the product. |
ProductNumber |
nvarchar(25) |
Not null |
Unique product identification number. |
MakeFlag |
Flag (user-defined type) bit |
Not null |
0 = Product is purchased. 1 = Product is manufactured in-house. |
FinishedGoodsFlag |
Flag (user-defined type) bit |
Not null |
0 = Product is not a salable item. 1 = Product is salable. |
Color |
nvarchar(15) |
null |
Product color. |
SafetyStockLevel |
smallint |
Not null |
Minimum inventory quantity. |
ReorderPoint |
smallint |
Not null |
Inventory level that triggers a purchase order or work order. |
StandardCost |
money |
Not null |
Standard cost of the product. |
ListPrice |
money |
Not null |
Selling price. |
Size |
nvarchar(5) |
null |
Product size. |
SizeUnitMeasureCode |
nchar(3) |
null |
Unit of measure for Size column. |
WeightUnitMeasureCode |
nchar(3) |
null |
Unit of measure for Weight column. |
Weight |
decimal (8,2) |
null |
Product weight. |
DaysToManufacture |
int |
Not null |
Number of days required to manufacture the product. |
ProductLine |
nchar(2) |
null |
R = Road M = Mountain T = Touring S = Standard |
Class |
nchar(2) |
null |
H = High M = Medium L = Low |
Style |
nchar(2) |
null |
W = Women's M = Men's U = Universal |
ProductSubcategoryID |
smallint |
null |
Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. |
ProductModelID |
int |
null |
Product is a member of this product model. Foreign key to ProductModel.ProductModelID. |
SellStartDate |
datetime |
Not null |
Date the product was available for sale. |
SellEndDate |
datetime |
null |
Date the product was no longer available for sale. |
DiscontinuedDate |
datetime |
null |
Date the product was discontinued. |
rowguid |
uniqueidentifier ROWGUIDCOL |
Not null |
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also