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
Reference
BillOfMaterials Table (AdventureWorks)
ProductCostHistory Table (AdventureWorks)
ProductDocument Table (AdventureWorks)
ProductModel Table (AdventureWorks)
ProductProductPhoto Table (AdventureWorks)
ProductReview Table (AdventureWorks)
ProductSubcategory Table (AdventureWorks)
UnitMeasure Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary