Tables | SQL 2005 Adventure Works OLTP |
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