Tables SQL 2005 Adventure Works OLTP

Production.ProductSubcategory

Object type: Table

Product subcategories. See ProductCategory table.

Columns 

Name  Data type  Nullable  Description 
ProductSubcategoryID  int  No Column has identity seed value of 1 with a step value of 1.
Primary key for ProductSubcategory records. 
ProductCategoryID  int  No Product category identification number. Foreign key to ProductCategory.ProductCategoryID. 
Name  Name  No Subcategory description. 
rowguid  uniqueidentifier  No Default value: NEWID()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDate  datetime  No Default value: GETDATE()
Date and time the record was last updated. 

Constraints 

Name  Type  Columns  Description 
DF_ProductSubcategory_rowguid  DEFAULT  rowguid  Value: NEWID()
Default constraint value of NEWID() 
DF_ProductSubcategory_ModifiedDate  DEFAULT  ModifiedDate  Value: GETDATE()
Default constraint value of GETDATE() 
PK_ProductSubcategory_ProductSubcategoryID  PRIMARY KEY  ProductSubcategoryID  Clustered index created by a primary key constraint. 
FK_ProductSubcategory_ProductCategory_ProductCategoryID  FOREIGN KEY  ProductCategoryID  Reference table: Production.ProductCategory
Foreign key constraint referencing ProductCategory.ProductCategoryID. 

Indices 

Name  Description 
AK_ProductSubcategory_Name  Unique nonclustered index. 
AK_ProductSubcategory_rowguid  Unique nonclustered index.Used to support replication samples. 

Triggers 

Name  Description 
Production.uProductSubcategory  AFTER UPDATE trigger setting the ModifiedDate column in the ProductSubcategory table to the current date. 

Linked tables 

Name  Description 
Production.Product  Products sold or used in the manfacturing of sold products. 

Accessed by 

Name  Description 
Company Sales  Adventure Works sales by quarter and product category. This report illustrates the use of a matrix data region that provides drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of background images. 
Employee Sales Summary  Adventure Works sales for an individual employee. This report includes Sales Comparison and Current Month Sales Comparison charts in addition to a Current Month Order Summary table with drillthrough to individual orders. This report illustrates the use of multiple datasets, charts, tables, drillthrough, and dynamic parameters. 
Product Catalog  Adventure Works full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map. 
Product Line Sales  Adventure Works top five sales people and stores. This report illustrates a dataset with queries containing the TOP clause. It also illustrates the use of tables, charts, parameters, calculated fields, and drillthrough links. 

Modified by 

Name  Description 
Production.uProductSubcategory  AFTER UPDATE trigger setting the ModifiedDate column in the ProductSubcategory table to the current date. 

Applies to

Tables | User
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.