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

Help and Information

Getting SQL Server 2005 Assistance